Error data type mismatch - Microsoft Access / VBA

Eric

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

Subscribe Post Reply

1726

Eric

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

Larry Linson

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

Similar topics

"datatype mismatch error" in MS Access

by: Stephen Briley | last post by:

For some reason, my posts are scrubbed as attachments. Lets hope that sending from the yahoo account works. I'm new to Python and I'm trying to do some database work with MS Access, but I can't...

Python

MS Access datatype mismatch error

by: Steve Briley | last post by:

I'm new to Python and I'm trying to do some database work with MS Access, but I can't seem to get around a "datatype mismatch error".  Here's an example table that I'm working with... ...

Python

type mismatch : Error

by: Arun Wadhawan | last post by:

Hello MY SQL Server is causing me this problem : Microsoft VBScript runtime error '800a000d' Type mismatch: 'ident' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I am getting from...

Microsoft SQL Server

Overflow error

by: Mike | last post by:

I am trying to use the bulk insert command but I am getting the following error: ---Begin Error Msg--- Server: Msg 4867, Level 16, State 1, Line 1 Bulk insert data conversion error (overflow)...

Microsoft SQL Server

Type Mismatch Error On Bulk Insert

by: Mike | last post by:

I am getting a type mismatch error when I do a bulk insert. ---Begin Error Msg--- Server: Msg 4864, Level 16, State 1, Line 1 Bulk insert data conversion error (type mismatch) for row 1, column...

Microsoft SQL Server

error 3464 Data type mismatch error!! ??

by: Chicken Kebab Abdullah | last post by:

Does anyone know why I get the error 3464 Data type mismatch from the following code. I have a form with a combo(to choose a consumable) and 2 list boxes on it. list on left is all printers...

Microsoft Access / VBA

Query Should run but Data Type Mismatch error

by: news.paradise.net.nz | last post by:

I have been developing access databases for over 5 years. I have a large database and I have struck this problem with it before but can find nothing in help or online. Access 2000 I have a query...

Microsoft Access / VBA

Run-time Error message #3464 - Data Type mismatch in criteria expression

by: ArcadeJr | last post by:

Good morning all! I have been getting a Run-time Error message #3464 - Data Type mismatch in criteria expression. While trying to run a query. I have a database where the field Asset_Number...

Microsoft Access / VBA

data type mismatch error

by: amitbadgi | last post by:

I am getting the following error while converting an asp application to asp.net Exception Details: System.Runtime.InteropServices.COMException: Data type mismatch in criteria expression. ...

ASP.NET

Type Mismatch Error

by: kjworm | last post by:

Hello Everyone, I have been fighting with a type mismatch error for many hours today and I can't seem to find what the problem is. Hopefully it is more than a missing apostrophe! I have isolated...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++