Selasa, 28 Mei 2013

RE: [MS_AccessPros] Data Type Mismatched

 

I'm surprised you are getting the error since I change both occurrences and the surveys opened fine regardless of which control I clicked on.

Please share your appropriate lines in the macros.

You can always use a crosstab query to "de-normalize" a normalized table structure. 

Duane Hookom MVP
MS Access

----------------------------------------
> From: dbalorenzini@yahoo.com
>
> 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
>
> ________________________________
> From: Duane Hookom <duanehookom@hotmail.com>
>
> 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

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

__,_._,___

Tidak ada komentar:

Posting Komentar