 |
Welcome to the EMuUsers discussion forums. All registered users are
encouraged to post new topics and also to participate in existing
discussions.
* You must register first if you wish to make postings.
* You can subscribe to one or more forums to receive email notification when new messages are posted.
* Click on a correspondent’s name to find out their title and institution.
|
| Author |
Messages |
|
Paula DeStefano
Posts:4
 |
| 12-02-2009 1:52 AM |
 Alert
|
Has anyone set up reports using Word and Excel using the VB code mentioned in the Help section?
When setting up my Word report I keep getting a runtime error 5922 and the is highlighted in yellow:
.OpenDataSource _
Name:="", _
Connection:="DSN=EMu Catalog;", _
SQLStatement:="SELECT * FROM ecatalog.csv", _
Subtype:=wdMergeSubTypeWord2000
The last line has an arrow next to it.
Any suggestions?
I also noticed in the help section for the Excel reports they just copied the code for Word with a few modifications at the beginning. Will this work?
If some could share their code I would be most grateful!
|
|
|
|
|
Bernard Marshall
Posts:41
|
| 12-02-2009 8:17 AM |
Alert
|
Hello Paula,
The VB code you have looks correct. I suspect that the DSN name is incorrect. The Data Source Name for the catalogue module is "EMu Catalogue", so I would suggest changing:
Connection:="DSN=EMu Catalog;", _
to
Connection:="DSN=EMu Catalogue;", _
Regards
bern. |
|
Bernard Marshall
KE Software
Melbourne, Australia |
|
|
Paula DeStefano
Posts:4
|
| 13-02-2009 12:53 AM |
Alert
|
Hi Bernard-
Thanks for your reply.
I tried your suggestion without any luck.
The KE help section on Word reports has a section on DSN tables. The DSN listed for catalogue is EMu Catalog- this must be a typo.
Is there anything else I am missing?
Is there some revised code available that I could use.
Thanks again-
Paula |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
 |