Search results for query: *

The error message is "you omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks

I am trying to use the left function in a query in Access 2003 left ([DESC],5). I am entering it in expression builder but it keeps saying invalid syntax.. Also has anyone used Kaione's SprintDB Pro for pocket pc? I am having trouble with that as well!! Thanks for any help Andy

Thanks i have changed it so the form is open first, so simple really. It still does not work so i have posted it in the other forum Many Thanks Andy

I have a database (Access 2003) of vehicles and i need to query when an MOT is due. I Wanted it to open a form and show the MOT date 10 days before the MOT is due. This is what i have so far. All this does is open the form and display th msgbox even when there are mot's due. I would be very...

I have a database (Access 2003) of vehicles and i need to query when an MOT is due. I Wanted it to open a form and show the MOT date 10 days before the MOT is due. This is what i have so far. I keep getting the error that it can't find the form - Forms!FMotDueDate!MOTDate I would be very...

Thanks PH. That works great.

Sorry PHV, I have added the code to the Event Procedure for the button I use to update the table but noting happens.

Thamks for that PHV. I am not sure where to add the code?

I wonder if anyone can help. I need to add a new record in table by taking that last number from the previous record and adding 1. I don't like using the autonumber that Access uses. In Access 97 I would use this and it works fine Dim dbs As Database Dim rst As Recordset Dim temp As...