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!

Recent content by glynch123

  1. glynch123

    Creating a Access parameter query from VB

    Hi Golom, I wonder would you be able to help me with something? With the code you suggested, I created a query using QueryDef. It works, but does not use the correct parameters - it uses the previous parameters. If I overwrite the queryDef with new parameters, it is not until I close the...
  2. glynch123

    Design Question/Problem with Prompts

    Wow, thank you everyone for all of your help! That was really fast. Ed2020: I was using DoCmd.RunSQL. CurrentDb.Execute works great! Thank you very much! RoyVidar: Thanks for the info. :-) I will have to modify that! I tried using queries before but I couldn't get it to work for what I...
  3. glynch123

    Design Question/Problem with Prompts

    Hi, jimbOne. This works! Thank you. But is this a common practice? I wouldn't want to hide important warnings. Thank you.
  4. glynch123

    Design Question/Problem with Prompts

    Hi, I am fairly new at Access and have a question: I have a "Project" database. Each Project has Components. The Components are categorized as follows: Category (i.e. Lights) | SubCategory (i.e. Square, Round Lights) | Component (i.e. 5 inch to 10 inch, 11 inch to 15 inch) I have a...

Part and Inventory Search

Back
Top