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 TouchToneTommy 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: omooreirl
  • Content: Threads
  • Order by date
  1. omooreirl

    Delete record matching form value

    Hi I have a form in which the use enters a batch number. On clicking Continue, the table is referenced to see whether the value exists or not. If it does then the user has the option to delete the row in the table. The code I am using for the delete query is as follows: DoCmd.RunSQL Delete...
  2. omooreirl

    Query not running through VBA but will if query clicked seperately

    Hi all I have the code below in my on click event in a form. The append query referenced will not run and I am getting no error alert. When I then go to the database window and manually double clik the query it works with no problems. My call for the query is simply: DoCmd.OpenQuery...
  3. omooreirl

    File name on form read by module

    Hi all I have a module written to import a text file into my access database. The name of the text file will change about every 3 days or so and is not predictable. I need the user to enter the name of the new file on my form such that my module can then read the name and open it. Can anyone...
  4. omooreirl

    Query criteria Count accross rows

    Hi all I have a table with 13 columns. Column 1 is my primary ID. The other twelve columns are all weights measured against the primary ID. I need to create a query to count against each primary ID, the number of weights that meet a certain criteria. I can create the SQL for the count for...

Part and Inventory Search

Back
Top