Search results

Date Query in Access XP Hi, I am trying to run a query that when you click on it, it shows any due dates for inspections test to appear for the month your in. E.g. I want to know all the inspections tests that are due in June. I have the following code but it doesn’t seem to work, it will...

Hi all, I'm trying to write some VB code, the user selects data using a form & when they hit ok it brings up a report displaying all the records that match. The form has three combo boxes & two text boxes. Commercial (combo) Customer (Combo) Status (combo) Beginning Date (txt) End Date (Txt)...

Hi can anyone hlep? I have written a query In Access 2002 that runs off a form. The form has four combo boxes & two text boxes. Business Development (Combo) Commercial (combo) Customer (Combo) Status (combo) Beginning Date (txt) End Date (Txt) So the user could be really specific & use all...

Hi, I have a form with a filter of 3 combo boxes, which the user select to specify the information they want to find.A report will then display all information matching the search criteria. i keep getting the error message of : 'Syntax error (missing operator)in query expression.' Below is my...

I'm trying to get 3 combos on a form to select the records to be shown in a report. have used some VB code on a command button, which should run the code & bring up the report. code is: Private Sub cmdapplyfilter_Click() Dim stryourname As String Dim Strcustomer As String Dim...

Does anybody know how to make a parameter box with a drop down list, so if you can't remember all of someones name you can just select it from the list. Thanks