Search results

  1. M

    Date Query using VB in Access XP

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

    Run Time Error 13 - Type mismatch, Something to with Date??

    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)...
  3. M

    Problem with between date SQL using Access 02

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

    Combo Box Syntax Error

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

    How to use reports with comboxes Access 2002

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

    Dropdown lists on parameter boxes

    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
Back
Top Bottom