Search results

I have it creating the report and exporting a separate pdf file with the delegate name in the name, however each pdf has every page in it. Both the prior suggestions were very helpful.. thank you so much! this is what I have: Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot) Do...

Removed this from the SQL statement "PARAMETERS [Forms]![frm_parameters_by_state]![Period_start_date] DateTime, [Forms]![frm_parameters_by_state]![State] Text ( 255 );" & _ and it corrected the errror.

I made the changes to the strSQL statement that JBH suggested.. Now I am getting the error: too few parameters expected 2. On the parameter form I am asking for period starte date and the state. These parameters are passed to the query (which is the strSQL statement).. The actual report...

when I enter the parameters in my form and click the button the whole strSQL is highlighted in yellow and I get the object required error.

I have parameter form that ask for state and begining date. on click it runs a query and creates a report by state that has multiple pages.. I want to create a separate pdf file for is page (which would be by delegate_name). This is the coding I have so far and am gettting the error '424'...

Hello from Florida, usa. I have not used Access in about 9 yrs and recently took a job that is having me work with Access Databalse. It has been a challenge but starting to look familiar to me again! :)