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...
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...
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...
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.