Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: andytheit
  • Content: Threads
  • Order by date
  1. andytheit

    Left Function in a query

    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
  2. andytheit

    trying to show a date record in a form

    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...
  3. andytheit

    trying to show a date record in a form

    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...
  4. andytheit

    VB in access 97 to 2003

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

Part and Inventory Search

Back
Top