VBA that opens parameter query in excel spreadsheet

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add additional information to excel form after original data entry 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word OLE to check spelling in text box 1
Autonumber field in Excel that behaves the same as Access 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word macro that can call cells out of Excel for a find and replace 0
Excel - Wich Function should I use? 1
Macro warning in word 1

Top