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 is dd/mm/yy that is the same as another machine where it works fine. I have made sure that the both the table and form field formats are "short date". Does anyone have any ideas as to what is wrong.
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Type Mismatch with date variable in update query
- Thread starter Markita
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question