By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,286 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,286 IT Pros & Developers. It's quick & easy.

Error data type mismatch

P: n/a
Why it gives that error. Both tables have same type of number
Data type mismatch

qry = "SELECT tbl_EquipmentChronology.Equipment1 FROM
tbl_EquipmentChronology WHERE tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & "';"
Set rst = CurrentDb.OpenRecordset(qry)

tbl_EquipmentChronology
Outlet Number

tbl_Events
PPVVOD_Outlet Number

Type of PPVVOD_Outlet was text then i change it with number but i did
nothing in the form. Is there is any thing which i do in the subform
too?

Aug 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I did some little change in the query but still same error:
qry = "SELECT tbl_EquipmentChronology.Equipment1 FROM
tbl_EquipmentChronology INNER JOIN tbl_events ON
tbl_events.PPVVOD_Outlet=tbl_EquipmentChronology.O utlet WHERE
tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & "';"

Eric wrote:
Why it gives that error. Both tables have same type of number
Data type mismatch

qry = "SELECT tbl_EquipmentChronology.Equipment1 FROM
tbl_EquipmentChronology WHERE tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & "';"
Set rst = CurrentDb.OpenRecordset(qry)

tbl_EquipmentChronology
Outlet Number

tbl_Events
PPVVOD_Outlet Number

Type of PPVVOD_Outlet was text then i change it with number but i did
nothing in the form. Is there is any thing which i do in the subform
too?
Aug 15 '06 #2

P: n/a
You need to remove the quote marks around the reference to
tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & "';"
now that you have changed it to a numeric Field. Try

tbl_EquipmentChronology.Outlet = " &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & ";"

Larry Linson
Microsoft Access MVP

"Eric" <eh******@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
>I did some little change in the query but still same error:
qry = "SELECT tbl_EquipmentChronology.Equipment1 FROM
tbl_EquipmentChronology INNER JOIN tbl_events ON
tbl_events.PPVVOD_Outlet=tbl_EquipmentChronology.O utlet WHERE
tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outle t & "';"

Eric wrote:
>Why it gives that error. Both tables have same type of number
Data type mismatch

qry = "SELECT tbl_EquipmentChronology.Equipment1 FROM
tbl_EquipmentChronology WHERE tbl_EquipmentChronology.Outlet = '" &
Forms!tbl_PPVResearch_Edit!frm_Events!PPVVOD_Outl et & "';"
Set rst = CurrentDb.OpenRecordset(qry)

tbl_EquipmentChronology
Outlet Number

tbl_Events
PPVVOD_Outlet Number

Type of PPVVOD_Outlet was text then i change it with number but i did
nothing in the form. Is there is any thing which i do in the subform
too?

Aug 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.