Search results

Its a combo box, so.. lookup I guess.

Oh I think I got it, removing the asterisks has done the trick. Thanks a lot for a everybody's help! :)

--------------------------- Microsoft Office Access --------------------------- SELECT tblProductType.Reservation FROM tblProductType WHERE (((tblProductType.[ProductType]) Like '*Test*')) --------------------------- OK --------------------------- This is the message, when the string in...

I did change it before using the code, I was just wondering whether you actually meant that or just a mistake.

This gave the result 'Ticked' for every product type... even for the ones that weren't ticked. Btw Reservation is a check box field, so should it read = True not = "Ticked"?

That's where I'm stuck. It SHOULD be returning a record, because all I've changed is instead of defining the criteria as 'Test' in the code, I'm defining it in the 'ProductTypeCheck' text box.

I used query builder to get this code: SELECT tblProductType.Reservation FROM tblProductType WHERE (((tblProductType.[Product Type]) Like 'Test')) 'Test' is just a dummy product type. And when I transfered it to my original code Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset...

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

Hey thanks a lot! Works like a charm :D

Do you mean like: GCriteria = "DrawingNumber" & " LIKE '*" & QDrawingNumber & "*'" AND "ProductType" & " LIKE '*" & QProductType & "*'" Form_Main.RecordSource = "select * from tblMain where " & GCriteria This gives a 'Type Mismatch' error.

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

Hmm, I'm not quite with you. By suffix/variation do you mean like say the base drawing number is 10000 (they are all 5 digit), the variation could be say 5000 to indicate every drawing number from 10000 - 15000 is reserved? To give a little more info on my database: The table I'm stuck on is...

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