Maybe try adding this to the following line:
strCriteria = strCriteria & "Like '" & Chr(34) _
All I did was add an ' after the Like, but whenever I use a like function to return results, that works for me.
WiscCard
Last Activity: Mar 24 '08, 04:22 PM
Joined: Mar 3 '08
Location:
-
What if you create a query with something like this in Criteria area of the column you want to search:
Like "*" & [Which Customer Name are you looking for?] & "*"
Then, create a command button that opens this query and then set your form data source to the query.Leave a comment:
-
Add a "loop" section to module
I have an Access report that I need to print the 1st page on letterhead and the 2nd page on blank paper, then move on to the next record and do the same.
I used the VBA code at the below link exactly and it works perfect, except that it literally does the 1st and 2nd pages and then stops. It does not move on to the next record in the report.
Is there any way to add a "loop" or something to this module so... -
Combo Box that combines multiple row source codes
I have a Yes/No combo box that is based on a table that uses -1, 0 to return those values.
I use the following SQL in RowSource to change that -1, 0 into a Yes/No:
However, all my other combo boxes have an All option that was added through SQL RowSource coding like this:Code:SELECT DISTINCT CUSTOMERS.CONTRACT, IIf([CONTRACT]=-1,"Yes","No") AS YN_Value FROM CUSTOMERS;
...Code:SELECT CONTRACT
-
Thank you, but I would prefer if All were a part of each combo box.
For example: If someone just wanted to see all East customers, they would selecte East as Zone and All as broker.
Any suggestions?...Leave a comment:
-
Show all records through combo box and command button
This seems simple enough, but I am having problems.
I have a table of customer information. I have a form with various combo boxes displaying unique customer information (in this case, zone and broker, but I'll add others before it is done.
I want each user to choose what they want out of the combo boxes, then hit the command button, which will display the results on a customized form. If they choose both combo boxes, it works gerat....
No activity results to display
Leave a comment: