Search results

Thank you for your time. I hope I have answered your question: cmb_INDUCTIONS_region is the Combo box name in the form REGION is a column name on the table The end-user does not have to select a “REGION” for the parameter query to run. For this reason I wrote: Or REGION Like...

Mr. Crake, I appreciate your time I’m still receiving the "Syntax error missing operator" message while highlighting "BETWEEN" SELECT REGION, UNIT, INSTALLATION, FINISHED_DATE, END_DATE FROM INDUCTIONS WHERE REGION=[Forms]![frm_COMPLETE_INDUCTIONS_User_Request]![cmb_INDUCTIONS_region] Or...

[Forms]![frm_COMPLETE_INDUCTIONS_User_Request]![cmb_INDUCTIONS_edate] Or Like [Forms]![frm_COMPLETE_INDUCTIONS_User_Request]![cmb_INDUCTIONS_edate] Is Null This part works for each combo box. Allowing the user to make a selection or have the combo box contain a Null. When I try to pace a...

Thank you for your response. I’m not sure where to place it and how to write it correctly. This is what I have however I receive a syntax error missing operator in query expression. Please see below code. SELECT INDUCTIONS.REGION, INDUCTIONS.UNIT, INDUCTIONS.INSTALLATION...

I’m using Access 2007 on a vista platform. I have a parameter query which is run using a form. On the form I have 5 combo boxes: Region, Unit, Installation, Beginning Date and End Date. I want this parameter query to pull all the dates BETWEEN Beginning Date and End Date, however I am...

Sorry, I should have added that to my posting I'm using Access 2007.

Hello, I have a form that contains five combo boxes two of which have an activeX control “ using the calendar Control 12.0 . The first date represents the “Beginning Date” and the second represents the “End Date”. My problem is: · It’s not retrieving all data between these two dates...