Search results

I got it to work. I just needed to put 3 sets of quotes around the form control. Thanks again!

Thanks bjackson. Yes txtcln_plate_id is the form field. Still have a slight problem. Now I am receiving a syntax error "missing an operator in the query expression". The message box is showing 'Clnplateid = 1234567890' ..........which is Clnplateid = " & txtCln_plate_id & " in the...

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

Thanks it helped me sort things out.

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

Thanks Rich and Jack Thanks for the help guys.

Thanks Jack Thank you. I should of seen that. But now it doesn't do anything. None of the boxes change. I'm sorry to ask but could you help me figure out what is wrong. I work for a plant breeding department in a seed company. The project we are doing has started generating over 200 plants...

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