PDA

View Full Version : Solved: Update Query



Skaapn
06-08-2012, 12:40 AM
Hi,

I'm trying to update a record in my database.
This is the query:


Dim UpdateQuery As String
Dim currentOfferteNummer As Long
currentOfferteNummer = (Form_Main.Hidden2)

UpdateQuery = "UPDATE [Offerte Items] SET [Item 1] = 'test' WHERE [Offertenummer] = '" & currentOfferteNummer & "'"
When i run this query, i get the following error message:
"Data Type Mismatch in criteria expression"


I'v checked both datatypes.
Offertenummer is defined as a Number(long int), same as the variable 'currentOfferteNummer'

I don't know why i get this error message :dunno

Skaapn
06-08-2012, 04:23 AM
I've solved it by using the Query designer and switch to sql view to get a working code :)