Try this method to re-link to your DSN then use the autoexec macro to execute the function. I have used this successfully for several off-hour downloads of data. I use launchpad to launch the MDB at the hour I need to process the downloads...
konad,
I believe that a global variable is only one way, for example from main report to sub. If you are using CR8 you can delcare a "shared" variable and it is accessible to any portion of your report, including subreports. I had a similar situation where I uses a shared array and a...
I have a shared array variable that I am passing back and forth between a subreport and the main report that I populate with a 20 character value. This all seems to be working great. However, I need to display the distinct count of values on the first page of the report and this is where I am...
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.