D
Don S.
I have a database which opens to a switchboard immediately. I converted this
recently to Office 2007 from a previous version. I have numerous buttons on
two tabbed pages which open forms and reports. I have four buttons which run
a macro each that "Output To" an excel file. These buttons work fine.
This morning I added another button to "Output To" another file. I have two
problems:
(1) Immediately upon setting it up, it worked fine except I got a message
asking to confirm if I wanted to update the already existing file. I have
checked to see if there is anything different from the other four and they
are all the same setup. Not a real problem but an annoyance.
(2) I closed the file after making the above changes but when I attempted to
reopen it, it would not open and I received the message: "The expression On
Open you entered as the event property setting produced the following error:
Return without GoSub
The button runs a macro as follows:
Name: ConsAnnRptLstinExcel
Action: Output To
Object Type: Query
Object Name: Annual Report Query
Excel Workbook (*.xlsx)
Output File: \\Powervault1\VIP\Annual Report List.xlsx
Auto Start: Yes
Fortunately I had a backup and restored but I really need this button to
initiate this action.
Thank you for you help as always. You assist us greatly.
recently to Office 2007 from a previous version. I have numerous buttons on
two tabbed pages which open forms and reports. I have four buttons which run
a macro each that "Output To" an excel file. These buttons work fine.
This morning I added another button to "Output To" another file. I have two
problems:
(1) Immediately upon setting it up, it worked fine except I got a message
asking to confirm if I wanted to update the already existing file. I have
checked to see if there is anything different from the other four and they
are all the same setup. Not a real problem but an annoyance.
(2) I closed the file after making the above changes but when I attempted to
reopen it, it would not open and I received the message: "The expression On
Open you entered as the event property setting produced the following error:
Return without GoSub
The button runs a macro as follows:
Name: ConsAnnRptLstinExcel
Action: Output To
Object Type: Query
Object Name: Annual Report Query
Excel Workbook (*.xlsx)
Output File: \\Powervault1\VIP\Annual Report List.xlsx
Auto Start: Yes
Fortunately I had a backup and restored but I really need this button to
initiate this action.
Thank you for you help as always. You assist us greatly.