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 SkipVought 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: *

  1. dbarnard

    Not in List and Trailing space

    Lisa, Thanks for the bit of code. I'd bodged it another way with a DLookup, so I'll change it to the above. Cheers Dean
  2. dbarnard

    Not in List and Trailing space

    Thanks for the tips. Lisa, I had tried something similar to what you've put above, but my problem is that once the space has got trimmed I need a way of getting the 'Not in List' event to trigger again if the 'trimmed' entry is not in the list. At the moment, after the code above runs with an...
  3. dbarnard

    Not in List and Trailing space

    Hi, I'm using Access 2007 and I have a combo box which uses the 'Not in List' event to check to make sure the entry is in another table, and if not asks the user if they want to Add the record. The code then does an INSERT INTO.... to add the new record, but... Although when entering the data...
  4. dbarnard

    Querying which SQL database being used in ODBC

    Hi Geoff, Thanks for the response, but as we are using the User DSN it does not seem to return the server it is connected to. I've managed to get round it by doing a WSHShell.regread on the relevant registry key. Regards Dean
  5. dbarnard

    Querying which SQL database being used in ODBC

    Hi, I am using Access 2007 to connect to one of two SQL databases via ODBC. One is our live database on a network server and the other is the test database (stored at the moment on my laptop). Both SQL databases are using either SQL 2005 or SQL 2005 Express. My problem is trying to write some...

Part and Inventory Search

Back
Top