Search results

rs.Open "SELECT Reservation from tblProductType where ProductType LIKE '*" & ProductTypeCheck & "*'", CurrentProject.Connection This line is returning a 'No value given for one or more required parameters' error. What it should do is select the value of the field 'Reservation' of the record...

Currently I have a piece of code GCriteria = "DrawingNumber" & " LIKE '*" & QDrawingNumber & "*'" Form_Main.RecordSource = "select * from tblMain where " & GCriteria This allows the user to type in a value in the text box 'QDrawingNumber' and find all records in tblMain...

Hi, I'm a Access/VBA newbie and hit a problem while doing a project. I'm building a table right now for 'product types', and each type can, but not necessarily has to, have a reserved range of 'drawing numbers'. So basically 3 fields: type, starting number, end number. My problem is when I...