ansaurus

Question

Answer 1

A:

To get the file path for the access application

CurrentProject.Path & "\"

Then just add the other files into the same directory and get them by name. i.e.

Dim filepath As String
filepath = CurrentProject.Path & "\name_of_file.mda"

Russ Cam 2009-09-07 14:47:26

unfortunately then my code would not compile...(unless I moved to late binding I guess)

MT 2009-09-07 14:59:05

ah, I understand now. I think late binding might be the way to go with this.

Russ Cam 2009-09-07 15:16:00

Russ, could you explain how late binding would work with Access MDBs/MDEs? I'm unaware of how to do this.

Tony Toews 2009-09-07 23:22:21

This article explains it quite well -http://www.granite.ab.ca/access/latebinding.htm it's been a while since I did anything in Access but this may work for the OP, depending on what kind of application they're building

Russ Cam 2009-09-08 06:01:43

@Tony- Am I right in thinking you wrote that article?!

Russ Cam 2009-09-08 06:51:21

Russ, correct, I wrote that article. Late binding works well with Excel, Word, Lotus Notes, Outlook, etc. But I'm not aware of how Access MDBs can use late binding to reference functions in other Access MDBs.

Tony Toews 2009-09-08 07:51:18

@Tony- I stand corrected. I've used late binding in Excel VBA before, but not in Access. I thought that it would have been possible in versions of Access 2000+ onwards (IIRC, that was the version where changes were made to Access VBA to bring it inline with other office VBA).

Russ Cam 2009-09-08 11:10:39

Russ, so far as I know, it's not possible but then sometimes folks can do some interesting tinkering and solve problems. So I was rather curious. For others reading this thread see "Late Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm

Tony Toews 2009-09-08 18:44:05

Answer 2

A:

You can add VBA references through VBA itself.

Dim sFilename As String
sFilename = CurrentProject.Path & "\" & whatever.mda

Application.References.AddFromFile sFilename

Just put that in your AutoExec and that reference ought to be available for everything. Of course, you'll have to check if the reference already exists before adding it, otherwise you get an error. But that's just a matter of looping through Application.References.

Mike 2009-09-07 18:37:40

If the original poster is distributing the app as an MDE/ACCDE this solution won't work as you can't update references in an MDE/ACCDE.

Tony Toews 2009-09-07 21:29:23

Answer 3

+6 A:

Why not just place the three MDEs in the same folder on the target system? Access should find the MDE references just fine.

Or are you using the add-in logic with the USysRegInfo table? You don't really need to do that with your own add-ins. Just with developer type add-ins such as Rick Fisher's Find and Replace.

If this isn't working for you then tell us what error messages or symptoms.

Tony Toews 2009-09-07 21:50:03

awesome. I'll give his a go.

MT 2009-09-08 13:02:28

Works a treat. Thanks. I had no idea that it would try to resolve the references itself in such a way.

MT 2009-09-08 13:07:56

BTW you can also use the the free Auto FE Updater utilitiy at http://www.autofeupdater.com/ to make downloading any new versions relatively painless. Also note that if your main FE is an MDE and you make any changes to the referenced MDEs you must make a new FE MDE as well.

Tony Toews 2009-09-08 18:47:11

ansaurus

tags:

views:

answers:

Access VBA - relative file references

related questions