Thank you pmmgpgp
I just spent 3 long hours trying to figure out why my Query with 'like' worked perfectly in Access and complely failed in VB.
the instr works perfectly in both.
Just a little more info
the FAQs ( which I should have read first ) do show a way to work around this which does work. I was wondering if there was a more direct way to do this ie. docmd queryname(param1,param2)
Hi
I am trying to call an access querry and pass it the values for the parameters without Access prompting the user for those parameters.
I dont think I can use ADO (this if for a Word mail merge)
and the mailmerge.openDataSource method only accepts either SQL or a connection in the form of...
Hi
I am trying to generate a word 2000 mail merge document in VB. The problem I am having is that my datasource is a query in Access that takes 3 parameters, I can't figure out how to pass the parameters to the query from the word.document.mailmerger.opendatasource method
without having the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.