Search results

  1. G

    Problem with MAX function

    I am trying to return a Max value from a table to a form. I keep getting the error message "Too few parameters. Expected 1" Dim db As DAO.Database Dim rst As DAO.Recordset Set db = DBEngine.OpenDatabase("C:\BarCode.mdb") Set rst = db.OpenRecordset("SELECT Max(Clnid)AS MaxOfClnid...
  2. G

    Populate a form field from a non related query

    I am currently working on a project that requires a primary key to be composed of 3 letters starting at AAA, the next AAB when the last letter hits Z then the next set would be ABA and so on. The way I am currently trying to make this work is to store each letter in a separate column in a table...
  3. G

    Help with checking all Checkboxes using recordset

    I have a form with a subform presenting datasheet view. The purpose of the form is to view records that will be printed based on the date. I have a text box on the main form that displays the current date and determines which records are visible in subform. If all the records look ok then a...
Back
Top Bottom