Selasa, 28 Mei 2013

Re: [MS_AccessPros] Data Type Mismatched

 

Still getting the same error. This is created like this in order to export it as a flat file into an excel spreadsheet for analysis as it contains survey data.

With Warm Regards,

Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."


________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Tuesday, May 28, 2013 4:15 PM
Subject: RE: [MS_AccessPros] Data Type Mismatched

 

Art,
It looks like RandomID is text and you are treating it like it's numeric. Try change the macro line to:

="[RandomID]='" & Nz([RandomID],0) & "'"

This needs to be done for both Open and Random ID columns.

BTW: have you considered normalizing your database?

Duane Hookom MVP
MS Access

----------------------------------------
> From: mailto:dbalorenzini%40yahoo.com
>
> I am uploading by database because when I open my Survey List form and then click to 'Open' to open a record I get a Data Type Mismatch error. I rechecked all the tables and the PK in all the tables are all Short text. Fairly confused.
>
> Thanks
>
> Art Lorenzini
> Sioux Falls,SD


[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
.

__,_._,___

Tidak ada komentar:

Posting Komentar