Thank you for taking the time to report an issue.
What's wrong... Please write below.
How do I find out WHICH User defined type is not defined, especially when I have not got any (or do not want to use any) user defined types?
Thank you in advanced programming wizards. Kind regards, Adam.
Microsoft Office Access can't change the data type.
There isn't enough disk space or memory.
What causes this error and what can I do to fix it?
Private Sub AreaCalc()
Me![PreferredArea] = " "
If Me![Oregon] Then
Me![PreferredArea] = "Oregon"
If Me![Washington] Then
Me![PreferredArea] = Me![PreferredArea] & ",Washington"
The following code should do the same thing on 3 different check box fields. All I want is for the 3 underlying fields (if checked) to add the text to the [Type] field. The field [Type] is also a text field.
Private Sub TypeCalc()
Me![Type] = " "
If Me![TypeHouse] Then
Me![Type] = "House"
If Me![TypeCondo] Then
Me![Type] = Me![Type] & ",Condo,Plex"
If Me![TypeApartment] Then
Me![Type] = Me![Type] & ",Apartment"
I get the following error message:
Object doesn't support this property or method (Error 438) .
I'm getting an type mismatch error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getdate'
The field for TodaysFeatured is VarChar. Is that what is causing the error message?
1) MsgBox "Total trip miles = " & lngTripMiles & vbCrLf & _"and the leg miles total " & _ DSum("LegMiles", "qryCalculateTripLegs"), , "Trip calculation error[/indent]"
I'm also getting a Type Mismatch error with the following SQL. I've searched and everything I can find seems that I have my quotes correct. I even tried replacing the form control reference with a variable, which evaluated correctly, but still did not work.
strSQL = "SELECT * FROM ORDER_DATA WHERE ORDER=" & curOrder rst_orderData = db.OpenRecordset(strSQL)
The ORDER column from ORDER_DATA is a double number type, and curOrder is of type double as well.
The error I'm getting points to the second line and says "Syntax error on WHERE clause".
Why do you think this is? Is it a possible type conflict
the part that's bold and underlined is were I am getting the error