Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel VBA DAO - How to open existing Access Query and pass Parameter
Hi Roy, Very embarressed here buddy - but I am having so many problems with this code! I have not used parameters in DAO before, and the MS Excel help on it seems pretty scratchy. The code I have down blow does not work in the slightest, and keeps on crashing - If you can tell me the steps I...- matlong30
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA DAO - How to open existing Access Query and pass Parameter
Hi Skip, This is not exactly true, as I have succeded in doing it in ADO, however it is so messy I am looking for improvements to my very clumsy code, and also way to do it in DAO... Public Sub GetFilesADOViaQuery() ' variables Dim db As ADODB.Connection Dim cmd As ADODB.Command...- matlong30
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA DAO - How to open existing Access Query and pass Parameter
Hi there peoples, First ever post on Tek-tips, so after struggling with this for a couple of days and searching the web, I thought I would try this. How can you use VBA in Excel to open an existing MS Access Query "qryEquityP" (set up to accept user supplied perameters "PDate" [ISO Date field...- matlong30
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
