467,911 Members | 1,376 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,911 developers. It's quick & easy.

Error data type mismatch

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
  • viewed: 1461
Share:
2 Replies
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
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.

Similar topics

2 posts views Thread by Stephen Briley | last post: by
2 posts views Thread by Steve Briley | last post: by
5 posts views Thread by Arun Wadhawan | last post: by
5 posts views Thread by Mike | last post: by
2 posts views Thread by Chicken Kebab Abdullah | last post: by
reply views Thread by news.paradise.net.nz | last post: by
1 post views Thread by amitbadgi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.