I've created a database for the single purpose of tracking training expiration dates for employees. When opened, it displays a report that shows a list of employees who's training dates are nearing expiration. Combined with Windows Task Scheduler, I have it set to run on a Supervisor's computer so that each day when he logs in, it runs the report for him.
I would like to have Access open, calculate the results, and then output the report (in a read only format, I do not wish to save the file first,) to an external format such as Word, Excel, or as a .PDF file. The Database would then automatically close.
Basically, I want to the supervisor to log in, maybe see the DB come up briefly, but then go away leaving him with just a simple report up on his screen that isn't reliant on Access remaining open.
I can successfully use the OutputTo command as a PDF file, but that prompts the user to save the results as a file first. I simply want it for viewing. They could then decide to save or discard it without saving.
Any ideas? Thanks in advance.
I would like to have Access open, calculate the results, and then output the report (in a read only format, I do not wish to save the file first,) to an external format such as Word, Excel, or as a .PDF file. The Database would then automatically close.
Basically, I want to the supervisor to log in, maybe see the DB come up briefly, but then go away leaving him with just a simple report up on his screen that isn't reliant on Access remaining open.
I can successfully use the OutputTo command as a PDF file, but that prompts the user to save the results as a file first. I simply want it for viewing. They could then decide to save or discard it without saving.
Any ideas? Thanks in advance.