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
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