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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Accees2000 queries in Module
I think it will not work out for me.....- bwmarents
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Accees2000 queries in Module
Hwen I do this: DoCmd.RunSQL "SELECT ANP01D_ANRG.RGNR, ANP01D_ANRG.RGRCSTCD, ANP01D_ANRG.RGNM, ANP01D_ANRG.VSNR, ANP01D_ANRG.RGTLNR, ANP01D_ANRG.RGMGNM, ANP01D_ANRG.RGMGNMVN, ANP01D_ANRG.RGMGNMAN FROM ANP01D_ANRG WHERE (((ANP01D_ANRG.RGRCSTCD)=1));" It gives an error "SQL...- bwmarents
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Accees2000 queries in Module
Thanks. I tried that, but the helpfile says it only can be used for action or definition query....not for a selection query. Is that correct?- bwmarents
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Accees2000 queries in Module
How can I - excuse my ignorance - run a select query from a module? I want to run the query a couple of times on different database libraries (on a AS400 through ODBC). It works as a seprate query, but I want to run it from a module on different tables. query: SELECT ANP01D_ANVS.VSNR...- bwmarents
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
