I am creating a database application in Access 2000, That will interact with Excel and Word. The problem area is when I transfer my recordset to an Excel Template.
The Steps are: User enters in a begin date and an end date, then clicks the transferbutton.
The first time the program does what it is suppose to, but if you close Excel and try to run a second report. Excell starts to open, it shows the top half of the window, but does not show the sheet, the report is created but not shown whenI click the X to close it it will ask if I want to save if I say yes and save it I can open the report in Excell (but not by double clicking the file).
What I have found out is If I open the code window (it does not show any code running) and clickthe reset button I can go back to the form and click the button to create the report and it will work one time, I reset it works. If you need to see the code I have a copy in Word, as it will not fit in this window