Error probably caused by lack of library reference

[EagleOne@microsoftdiscussiongroups]

2003

Getting an error on the last arguement in the following command:

DoCmd.OutputTo acOutputTable, "CHR_ALL_TBL",
"Excel97-Excel2003Workbook(*.xls)", "CHR_ALL_TBL.xls", False, "", 0,
acExportQualityPrint

I get a variable not found re: acExportQualityPrint.

The line of code was Converted VBA from my Home system. The code worked
fine at home. But not at work. What library do I need to reference? Or
different issue?

Any thoughts helpfull!!

EagleOne

 

[Arvin Meyer [MVP]]

Probably DAO 3.6 usually located at:

C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"EagleOne@microsoftdiscussiongroups"

 

[EagleOne@microsoftdiscussiongroups]

Arvin, THanks for your time and knowledge.

In VBA window, Reference to DAO360.dll (in the directory as specified) was
already linked in. Therefore I de-linked then re-linked the .dll.

Anything else which will give a variable not defined error?

 

[EagleOne@microsoftdiscussiongroups]

Arvin,

Additional experimenting lead to:

Thinking that the last argument "acExportQualityPrint" may be optional, I
deleted it and pressed on only to get an another error: "The format in which
you are attempting to output the current object is not available"

EagleOne

 

[EagleOne@microsoftdiscussiongroups]

Arvin,

Additional research has found this possibility.

My home machine uses Access 2007 whereas at Work I have Access 2003

THerefore: Access 2003 did not recognize all arguments to:

DoCmd.OutputTo acOutputTable, "CHR_ALL_TBL",
"Excel97-Excel2003Workbook(*.xls)", "CHR_ALL_TBL.xls", False, "", 0,
acExportQualityPrint

That said what does Access 2003 want to see so that I can get an operating
DoDmd?

TIA

EagleOne

 

[Douglas J. Steele]

Take a look in the Help file. Make sure you're in the VB Editor when you
look.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"EagleOne@microsoftdiscussiongroups"

 

[EagleOne@microsoftdiscussiongroups]

Doug,

Amoung the attempts to fix this:
DoCmd.OutputTo
acFormatXLS,"SND_ALL_AAAUIC_TBL",acFormatXLS,"SND_ALL_AAAUIC_TBL.xls",0

I have looked at the help file in VB Editor. Obviously, I am missing
something.

Thoughts?

EagleOne

 

[EagleOne@microsoftdiscussiongroups]

Got it Doug!!

DoCmd.OutputTo acOutputTable, "SND_ALL_AAAUIC_TBL", acFormatXLS,
"SND_ALL_AAAUIC_TBL.xls",0 ' False also works in lieu of 0

 

[Nicholas Meyer]

hmmmm
"EagleOne@microsoftdiscussiongroups"