VBA that opens parameter query in excel spreadsheet

  • Thread starter Thread starter pedro
  • Start date Start date
P

pedro

I have created a button on a form that calls a function to open a query in
excel.

I use the MyRecordset.Open command and this works for a select query,
however I would also like to call a function that opens a parameter query in
excel.

The query prompts for a date range to be entered into the WHERE clause.

When I attempt to call the function I get an SQL error.

Can I remedy this?

thanks!
 
Back
Top