Search results

Hello LPurvis Thanks for the code and the clarification. Do I have to clean up the SQL from the access to pass it into your function. If so, is there an easier way to convert the SQL from Access into simple SQL statement that I can assign to strSQL in VBA. I am using the following code after...

I am trying to run the Query "Q_Shipper_Export" from the code and don't know how to pass the data from the form.

you are absolutely right. Query Q_Shipper_Export is a select statment doing one join and filtering data. Here is the Query Q_Shipper SELECT [Select], Network_ID, INV_PMR_TE AS Pay_Terms, SHP_NR_TE AS Shipper_No, Trim([CNT_NA_TE]) AS Dear_Name, Trim([CNT_EML_TE]) AS Contact_EMail...

Hi Guys I am using Access 2003 and running the following code but I am not able to run. I am getting the following error message: "No value given for one or more required parameters." and the debugger stop at the following line rs.Open strSql, CurrentProject.Connection Here is the full...