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!

Register Log in
  • Congratulations derfloh 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: DHSBW
  • Content: Threads
  • Order by date
  1. DHSBW

    Drop Table function

    Hi: The function below deletes a specific table with the user supplying the table name, and deletes it if it does. But the function returns an error "table not found" if the table name has a space in it. How can I get it to accept the space? Thanks for the help in advance. Function...
  2. DHSBW

    Repeating the same procedure over fixed time interval

    My Access database is divided into a front end with all the forms and backend with all the underlying tables. How can I get the backend database to perform a repetitive function, in this case, search for the existence of a specific table every 30 seconds, and if it exists, insert the data into...
  3. DHSBW

    Creating a dynamic query def

    I'm getting a runtime error 3061: "Too few parameters" when I try to create a dynamic query def based on two parameters. Thanks for your help in advance. S1 = "Select [User Name],[Password], [Administrator] from [User Accounts] WHERE (([User Name]= [Forms]![Login]!UID) And ([Password] =...
  4. DHSBW

    disabling all controls on a form save one

    I want to disable all controls on a form open event execept of the textbox Employee ID. Is there some loop procedure I can use to accomplish that?
  5. DHSBW

    Populating text control from Combo Box using DLookup

    Hi: Here is the following simple one code I have in the "On Change" event of combo12 combo box: Private Sub Combo12_Change() [Forms]![Orders Form]!Text25 = DLookup("[Unit Price]", "Products", "[Product Description]= '" & [Forms]![Orders Form]!Combo12 & "'") End Sub I want to use the selected...

Part and Inventory Search

Back
Top