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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
get invoice numbers
Hello, I am trying to build an access application that creates invoices that will be imported into Great Plains. In this process, I need to get the next invoice number from great plains so I can store in in access with the invoices. My problem is I have no idea how to do this. The data will...- stockboy
- Thread
- Replies: 1
- Forum: Microsoft: Dynamics GP (Great Plains)
-
passing parameter to query
Cosmo-- The problem is passing a parameter or critia item to the query. Any ideas?- stockboy
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
passing parameter to query
Cool. Can I then delete the Query after I use it?- stockboy
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
passing parameter to query
I thought about that but I read somewhere that TransferText will not take an SQL statement as the source. I tried your example but it throws an error saying "MS Jet database engine could not find the object 'SELECT * FROM invoice. Make sure the object exists and that you spell its name...- stockboy
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
passing parameter to query
Hello, I hope someone can help me out on this problem. I need to use the TransferText command to transfer data from the access db to a text file. I got that to work but now the user wants to limit the records that get put into the text file. I have created a query with a parameter but I...- stockboy
- Thread
- Replies: 10
- Forum: Microsoft: Access Modules (VBA Coding)
