this is driving me crazy i have no table called import or any query's please help
murray83 Games Collector Local time Today, 08:48 Joined Mar 31, 2017 Messages 728 Jun 19, 2017 #1 this is driving me crazy i have no table called import or any query's please help Attachments compliance paperwork monitor.mdb 1.7 MB · Views: 55 help please.png 18.7 KB · Views: 82
murray83 Games Collector Local time Today, 08:48 Joined Mar 31, 2017 Messages 728 Jun 19, 2017 #2 feel like a right idiot the import was from my dlookup how ever i have changed it to look at the table called main now gives following Run-time error 3464 data type mismatch in criteria expression
feel like a right idiot the import was from my dlookup how ever i have changed it to look at the table called main now gives following Run-time error 3464 data type mismatch in criteria expression
NauticalGent Ignore List Poster Boy Local time Today, 04:48 Joined Apr 27, 2015 Messages 6,286 Jun 19, 2017 #3 Is you DB split and if so, are the BE tables on a shore drive or sharepoint server? Mine are and I get this error when I drop connectivity...
Is you DB split and if so, are the BE tables on a shore drive or sharepoint server? Mine are and I get this error when I drop connectivity...
NauticalGent Ignore List Poster Boy Local time Today, 04:48 Joined Apr 27, 2015 Messages 6,286 Jun 19, 2017 #4 murray83 said: feel like a right idiot the import was from my dlookup how ever i have changed it to look at the table called main now gives following Run-time error 3464 data type mismatch in criteria expression Click to expand... Check the field types.
murray83 said: feel like a right idiot the import was from my dlookup how ever i have changed it to look at the table called main now gives following Run-time error 3464 data type mismatch in criteria expression Click to expand... Check the field types.
moke123 AWF VIP Local time Today, 04:48 Joined Jan 11, 2013 Messages 3,852 Jun 19, 2017 #5 also check your delimiters for text,dates, etc.