Re: VBA that opens parameter query in excel spread***
- From: "Roger Carlson" <RogerCarlson@xxxxxxxxxxxxxxx>
- Date: Thu, 13 Nov 2008 10:20:48 -0500
What is the SQL error?
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
"pedro" <pedro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CD8DB9E8-3EEF-465B-9397-14AAE25B00DD@xxxxxxxxxxxxxxxx
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!
.
- References:
- Prev by Date: Access 2007 Visual Basic Running Total and Percent of Total....
- Next by Date: Re: Access 2007 - whatever happened to ADO and DAO ?
- Previous by thread: VBA that opens parameter query in excel spread***
- Next by thread: Calculated fields in subforms of Tab Control not refreshing
- Index(es):
