Thank you for this. I don't know what the difference is because I entered the macro line just as you had it and it did not work. I opened your version of it and it worked great. But thank you very much.
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 5:03 PM
Subject: RE: [MS_AccessPros] Data Type Mismatched
Art,
You could have answered my request "Please share your appropriate lines in the macros."
I just uploaded my version of the corrected code.
Duane Hookom MVP
MS Access
----------------------------------------
> From: mailto:dbalorenzini%40yahoo.com
>
> Maybe its something on my system. Could you make the update to the form and post it and I can download it and see if it works?
>
>
> With Warm Regards,
>
> Arthur D. Lorenzini
>
> ________________________________
> From: Duane Hookom <mailto:duanehookom%40hotmail.com>
>
> 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: mailto:dbalorenzini%40yahoo.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 <mailto:duanehookom%40hotmail.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
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[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 (7) |
Tidak ada komentar:
Posting Komentar