S
Swannie
Error 2046
Has anyone encountered this before ?
What I am trying to do is use acSendQuery to excel and
receive the following error message.
"The command or action 'OutputTo' isn't available now.
You may be in a read only database or an unconverted
database from a previous version.
The Type of object the action applies to isn't currently
selected or isn't in the active view.
Use only those commands and macro actions that are
currently available for this database."
The code that this is based on is
DoCmd.SendObject acSendQuery, "qryX2", acFormatXLS,
strCoordMail, , , "Report for " & Me.cboBrand.Column
(1), "" & vbCrLf & "", False
Everyone should be using access 97.
Thanks
Has anyone encountered this before ?
What I am trying to do is use acSendQuery to excel and
receive the following error message.
"The command or action 'OutputTo' isn't available now.
You may be in a read only database or an unconverted
database from a previous version.
The Type of object the action applies to isn't currently
selected or isn't in the active view.
Use only those commands and macro actions that are
currently available for this database."
The code that this is based on is
DoCmd.SendObject acSendQuery, "qryX2", acFormatXLS,
strCoordMail, , , "Report for " & Me.cboBrand.Column
(1), "" & vbCrLf & "", False
Everyone should be using access 97.
Thanks