ACCESS FEED: Re: [MS_AccessPros] Adding a Library Reference using VBA

Kamis, 06 Februari 2014

Re: [MS_AccessPros] Adding a Library Reference using VBA

Jerry-

Your VBA code sits inside your database file - a VBA "Project". Darrell is right that you set the References inside the project inside your database and then compile and save. Access is *sometimes* good about fixing up references if, for example, you compile and save the project using Access 2010 but then someone tries to run it using Access 2013. Unfortunately, changing the reference at startup "decompiles" your project, so it will run more slowly. That's why many of us use "late binding" to get around the whole library references issue.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Feb 6, 2014, at 8:14 PM, Jerry Mathers <jerrymathersasthebeav@yahoo.com> wrote:

>I assumed he was working in an enterprise environment

You are correct. Everyone in the entire school system should be on the same version of software, at least they are supposed to be.

>That's not an Access setting. It is a database or project setting.

I'm curious about this. I'm not sure I understand the distinction between Access and a database or project.

Thanks a lot for your help. Greatly appreciated--always!!!

Jerry

On Thursday, February 6, 2014 11:31 AM, "Embrey, Darrell" <DEmbrey@bcbsm.com> wrote:

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.