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 IamaSherpa 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. Markita

    Type Mismatch in Converted 97 Database (from 2000)

    I have converted my Access 2000 database to 97 and now get a type mismatch error. I have dealt with the references problem and have saved and compiled all the modules. The error occurs when I run a module that has the Cmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,, acMenuVer70 code in...
  2. Markita

    Type Mismatch when comparing dates

    I have an update query that compares dates. I use #" & theDate & "# in the SQL string to reference the date variable but my problem is that this does not work on all the machines I have tested the database on. All my dates have the format shot date. Can anybody help me?
  3. Markita

    Type Mismatch with date variable in update query

    I have a database that lives on a network. When I open and use it on one machine it works fine but on another I get a Type Mismatch error when specific update queries are run. These queries use date variables as parameters. I have checked the regional settings for the machine and the date format...

Part and Inventory Search

Back
Top