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 bkrike 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 jwhearn

  1. jwhearn

    Explicit reference to form-instance

    Does anyone know what my problem might be? I am trying to refer to a certain instance of a form that I've added to a collection. I am adding several instances of the same form to a Collection object called colForms, then trying to access the information on them from a different module. In the...
  2. jwhearn

    Refering to certain instance of a form in a collection

    Does anyone know what my problem might be? I am trying to refer to a certain instance of a form that I've added to a collection. I am adding several instances of the same form to a Collection object called colForms, then trying to access the information on them from a different module. In the...
  3. jwhearn

    Building a Search Engine (looking for individual words within fields)

    I don't know why I hadn't considered that. The InStr function sounds great. For instance my WHERE clause could look like this: &quot;InStr([Title], TitleStr) <> 0&quot; Now all I need is to be able to narrow this down to whole words only. In other words, if TitleStr=&quot;age&quot;, then the...
  4. jwhearn

    Building a Search Engine (looking for individual words within fields)

    I am building a search engine, and would like to get your ideas on how to (elegantly) search for individual (whole) words within fields. For instance if I want to search for a book by entering a word (or mulitiple words) into the Title field (of the search form), what is the best way to form the...
  5. jwhearn

    Run code as database quits??

    You can create a form with nothing on it, and have it open up on Startup (Tools menu, then Startup...). Use the form's Open Event to set it's Visible property to False (i.e. Me.Visible = False) - (you can also use this event to open another form that you may already need to open on Startup). The...
  6. jwhearn

    Hiding a Macro's Dialogue Boxes

    Try the SetWarnings Method: DoCmd.SetWarnings False Code...Code...Code DoCmd.SetWarnings True You may also want to use this in conjunction with the Echo Method, such as: DoCmd.Echo False DoCmd.SetWarnings False Code...Code...Code DoCmd.SetWarnings True DoCmd.Echo True Hope this helps, JW.
  7. jwhearn

    DAO and JET topics missing from VBA help

    I just got a new computer and installed my Office 2000 Premium. When I got back to work on my database, I noticed that all the help topics related to JET and DAO are missing from the VBA help. For instance, when I go to Help from the VBA editor and search for &quot;HAVING CLAUSE&quot;, or...
See more

Part and Inventory Search

Back
Top