The code is
################
stDocName = "fisfinrpt"
DoCmd.OutputTo acOutputReport, stDocName, outputformat,filename, False
stDocName = "SubRpt"
==> DoCmd.OutputTo acOutputReport, stDocName, outputformat, filename1
################
The line with the arrow is causing the...
Hi
I tried to do it. When i run it,
it hit this error.
"Run-time error '3464'
Data type mismatch in criteria expression"
When I press "debug"
It highlighted this line of code to me
"DoCmd.OutputTo acOutputReport "Report1", "Snapshot Format...
When i run the report manually, the report will prompt the user to input some value and later it runs.
How do i write a marco that will automate the process of accepting the input agruement to the report and output it into a snapshot format?
thanks
Hi
I realised that the format of my report will be out when I tried to output it to rtf or other format. I tried to output it to snapshot format. It looks ok. But is there ways other than outputting it in snapshot format? or are there ways to convert the snapshot format to a word/text/pdf? thanks
Hi
Is there a maximum number of queries hitting an access tables? "Out of memory" message box appear when i have add a new queries to the tables. thanks
Hi,
When I generate the report, it will run for a while then it pop up a message box says that it is "out of memory". Does that mean that I have too many queries in the report? Is there a limit to the number of queries in the report? how to solve the "out of memory"...
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.