UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Call Function From Multiple .accdb Files, Access 2016    
 
   
Pilotwings_64
post Feb 26 2020, 05:05 PM
Post#1



Posts: 283
Joined: 20-August 10



I have a lot of custom functions I would like to use in more than one .accdb file.

Other than just copying the modules to each file, is there a way that I can call the functions from a given file as if they were in a module stored on that same file?

I'm imagining something akin to link tables but with modules.

Thanks in advance
Go to the top of the page
 
June7
post Feb 26 2020, 05:14 PM
Post#2



Posts: 1,316
Joined: 25-January 16
From: The Great Land


Bing: access vba call function from another database

Review https://accessprogrammer.blogspot.com/2005/...edure-from.html

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
cheekybuddha
post Feb 26 2020, 05:18 PM
Post#3


UtterAccess Moderator
Posts: 12,621
Joined: 6-December 03
From: Telegraph Hill


Hi You can set a reference to the 'library' database in much the same way as you might set a reference to Excel.

Then your library modules will be available in your current project.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
June7
post Feb 26 2020, 05:55 PM
Post#4



Posts: 1,316
Joined: 25-January 16
From: The Great Land


More info https://www.devhut.net/2017/11/14/ms-access...rary-databases/

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
Pilotwings_64
post Mar 10 2020, 02:01 PM
Post#5



Posts: 283
Joined: 20-August 10



Thank you cheekybuddha! That's exactly what I was looking for.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    7th April 2020 - 11:55 AM