Ok... Ive been reading all the other horror stories on this forum about trying to export a report directly to excel and how the formatting is totally stripped.
However a simple acformatxls is a 90% solution to what I am doing because it allows me to apply my search filters to the query as...
I am relatively new to using SQL but I have gotten several insert and update queries working quite well. I cannot however seem to figure out how to use the SELECT SQL to get a value from a table.
Here is my code that is under the "Click" action of a button:
Dim db As DAO.Database
Dim strSQL...
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.