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 Mike Lewis 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. Prof63

    How can you bypass MS generated message box

    How's about adding in your code DoCmd.SetWarnings False and at the end DoCmd.SetWarnings True this turns off *all* messages in Access 97
  2. Prof63

    SQL Date Format

    Thanks for the feedback. Just to confirm I have understood whats being said... I don't need to do anything in the SQL statement other than enclose the variable (string from textbox) with # ie ......between #" & datStart & "#..... I have an input mask on the textbox such that the...
  3. Prof63

    SQL Date Format

    Keimpe What about if I'm passing a variable, such as datStartDate?
  4. Prof63

    SQL Date Format

    Hi I have an input box with input mask for two dates as dd/mm/yyyy which I pass as variables to several SQL queries in VBA. When the date is, for example, 17th November the date is passed as 11/17/2002 (correct for SQL) but 1st November is passed as 01/11/2002. Both dates are treated in the...
  5. Prof63

    Where are the macros?

    Did this get sorted?
  6. Prof63

    MS Access Audit Trail

    Sean I'm currently undergoing the very same thing myself. I've got the users stored in a table as they access the DB, all I need to implement now is the date, time, old field value and new field value! I'll post the salient bits of the code when I'm done.

Part and Inventory Search

Back
Top