Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: drctx
  • Content: Threads
  • Order by date
  1. drctx

    use variable name to set textbox readonly

    i've been stuck on this problem all day. how can i use a variable name to set several textboxes to readonly? While MyDataReader.Read if MyDataReader.Item("FieldType") Is System.DBNull.Value then ' do nothing else if MyDataReader.Item("FieldType") = "Hidden" then...
  2. drctx

    reference a control by a variable

    in vb i could use code like this to get the field name from a database table and then hide the textbox with the same name. if rs("FieldName") = "hidden" then me("txt" & rs("FieldName")).visible = false end if but in asp.net using vb.net i can figure it out. the code below gives the error...
  3. drctx

    excel formating problem? enter 1 displays 100

    if i type 1 in a cell it changes to 100. it's like it's formatted for percentage but doesn't show the % sign. i've formatted it to be number and general but it still displays 100. does anyone know what would cause this? thanks.
  4. drctx

    clear Command$

    is there a way to clear the command line arguement that is stored in Command$? i've tried Command$ = Null Command$ = "" i get this error "Function call on left side of assignment must return Variant or Object" Set Command$ = Nothing i get this error "Invalid use of Property
  5. drctx

    Red wavey line infront of server name in Enterprise manager

    i get the little white circle with a green arrow in it then to the right there's a red wavey vertival line. i can't figure out what this is, anybody have any ideas? thanks Doug
  6. drctx

    check for numbers only in text box

    i have an unbound text box that only needs to have numbers entered in it like 123.0005. is there a way to test for only number in the text box?
  7. drctx

    get the current drive and path

    in VBA for access programming i can get the current drive and path using Application.CurrentProject.Path. is there a similar method in VB?
  8. drctx

    trap ctrl+f ?

    the there a way to trap ctrl+f? i want to stop the find window from opening on a form, i want to use my custom find form instead.
  9. drctx

    ASCII code for Ctrl key

    is there a ASCII code for the Ctrl key? i've searched my ASCII table and can't find it.
  10. drctx

    printing a page as the last page of a report

    i'm wanting to print a term of sales page as the last page of a report. i can't think of a way to do it. does anyone have any ideas?
  11. drctx

    get the name of the current database?

    is there a way to get the name of the current database?
  12. drctx

    check a required field when record nav buttons are used

    check a required field when record nav buttons are used. i have a form that has 2 checkboxes. if i click next, previous, add new, last, first, i want to force the user to check one of the checkboxes before they leave. i've got the afterupdate on the checkboxes coded so if one is checked the...
  13. drctx

    is there a way to delete a file? i

    is there a way to delete a file? i have a database that repairs and compacts a list of databases in a table and creates a new db as dbname_C.mdb that's been compacted, then i want to delete the non compacted version and the rename the dbname_C.mdb file. everything works execpt the delete...
  14. drctx

    IIS ip problem

    i've posted this in the IIS forum but no replies (i guess not many read the IIS forum). i've got a IIS server named k8 with a dynamic ip of xxx.xxx.xxx.101 and a static ip of xxx.xxx.xxx.13. when i ping the server using the server name k8 i get back the 101 ip address. but when i enter k8 or ip...
  15. drctx

    IIS ip problem

    i've got a IIS server named k8 with a dynamic ip of xxx.xxx.xxx.101 and a static ip of xxx.xxx.xxx.13. when i ping the server using the server name k8 i get back the 101 ip address. but when i enter k8 or ip xxx.xxx.xxx.101 into internet explorer the web page doesn't show, but if i enter the...
  16. drctx

    create an autonumber ID field with coding

    i want to create an autonumber ID field in an existing table, but when i execute the code i get this error message: run-time error '3293': syntax arror in ALTER TABLE statment. Private Sub Command0_Click() Dim tblName As String Dim SQLstr, sql1, sql2 As String tblName = "TCRM...
  17. drctx

    problem with users tables, views, and SPs having (dbo) at the end

    i have an adp that i finally got working right, but domain admins are the only ones that can run the adp and not have all the tables and queries have (dbo) at the end, regular domain users get tables and queries that look like this: tablename (dbo) viewname (dbo) storedprocedurename (dbo) i've...
  18. drctx

    slow using linked tables to SQL server

    i've imported my back end database to sql server then linked the from end tables to the sql. there are about 3000 record and the searches and queries are extremely slow. is there anything that will speed it up? i have ran the upsizing wizard and had it create an adp but i can run the adp with...
  19. drctx

    refresh the database, queries window, or connection?

    I've got a combo box to select from and then it creates a stored procedure and tries to open it. I get this error message when i select an item from the combo box: "microsoft access can't find the object 'zTest'. when i look at the queries it's not there until i hit F5 to refresh and it...
  20. drctx

    I've got a combo box to select from

    I've got a combo box to select from and then it creates a stored procedure and tries to open it. I get this error message when i select an item from the combo box: "microsoft access can't find the object 'zTest'. when i look at the querries it's not there until i hit F5 to refresh and it...

Part and Inventory Search

Back
Top