Darrell-
That's not an Access setting. It is a database or project setting. Once you set the reference in the master copy and distribute it to the users, the reference remains checked in each user's local copy.
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jerry Mathers
Sent: Thursday, February 06, 2014 11:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Adding a Library Reference using VBA
Okay, this time I've got it right--I have an Access question! :-)
I found some VBA code that does exactly what I need in that it sends Query results to an Excel file. The code requires that the Microsoft Excel 14.0 Object Library is available. By default it seems to be unchecked so I've gone in and checked it. Once I do that everything works. But, what I need to do is find a way to "check" this reference on other people's computers who will be using the Access database. There's no way I'd be able to get them to do that the the way I had to so I'm wondering if there is a way to do this with some VBA so they won't have to get into the guts of the database to turn on the Excel Library Reference.
Thanks for any help you can offer!
Jerry
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar