How to Create a Library File Containing Shared Subs and Functions in Microsoft Access

Do you have certain functions or subroutines that you use in lots of different databases? And every time you change one of them or make a modification or an enhancement, you have to go and then change it in 10 different database files? Well, in today's video, I'm going to teach you how to create a shared Library database where you can use the modules from it in any of your other Microsoft Access databases.
Mason from Hoffman Estates, Illinois (a Platinum Member) asks: I've got a function that I use in all of my different databases that I wrote myself called FormatMyDate. Some of the reporting my company uses requires a specific date-time format, and that's what this function does. However, they change the format once in a while, and I have to go through and modify it in 15 different database files. Is there any way I can use this one shared function in all of my databases so I don't have to keep updating it everywhere?
Silver Members & up get access to an Extended Cut of this video. Members will learn how to set up a shared library file with an encrypted ACCDE file. There are a few more steps involved, but if you're working with a multi-user networked Access solution, this is what you'll have to do to set up a shared library.
MEMBERS-ONLY EXTENDED CUT VIDEO:
• Shared Library Databas...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Shared Library: 599cd.com/Shar...
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
Create Function: 599cd.com/Crea...
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, create shared library database, shared subs, shared functions, Microsoft Access tutorial, library file, shared modules, shared database files, Tools, references, missing or broken reference, project explorer, accdb, accde
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@JamalAmeen]

Man, you're a national treasure, I mean this is awesome, there is a plenty of KZbin tech channels out there, but you're one of the best. Much blessing from the east hemisphere. thanks for the support.

[@599CD]

Glad to help

[@replicaman9215]

I love how you keep your "mistakes" in the video (even though in this case it wasn't really a mistake). Love how you effortlessly parlayed it into another learning opportunity. A+ stuff, man. Thank you.

[@599CD]

Glad you enjoyed it!

[@ITPMMentor]

I have been using Access since 1999. Learn something new from you all the time. Love the library reference trick.

[@599CD]

Glad it was helpful!

[@xavierbatlle1828]

Interesting and useful video! I began to use Access libraries after 20 years of programing in VBA because nobody told me they exist. 😢

[@599CD]

Glad it was helpful!

[@easyspeak101]

Thank you Richard, always the best.. and glad to shout out recommendations and praises.. maybe that's old school in this day and age tho, not sure ☺️👍

[@599CD]

Greatly appreciated thank you

[@Shadow.Dragon]

Richard, thanks for the excellent and timely video! The last couple of days, I've been thinking about how to organize/use a module with all my "common" code. This video is just what I need! BTW, I wonder how many viewers caught the Doublemint Gum reference! LOL!!!

[@599CD]

You're the first to mention it LOL

[@omar16966]

another great video, Thanks.👏

[@599CD]

Thanks for watching!

[@janvanantwerp6574]

Tks. One problem sorted for me. 😊

[@599CD]

Welcome

[@hassanrozh6579]

Great video, thanks a lot.

[@599CD]

Glad you liked it!

[@alializadeh8195]

Thanks

[@599CD]

Welcome

[@ozairkhalid]

Nice video, thanks

[@599CD]

Glad you liked it!

[@gregoryjeffries8475]

Will this work on a compiled shared database file?

[@kaoxingsingthavong1245]

Thank you...

[@599CD]

Welcome

[@marwanaltai6867]

Hello mr ritchard.l watched most of your videos. I designed clinic mangment program with invoicing and evrything that i need. Now i have one issue, if i close the software for longe time i lose most of the enterd data. Although its there if i close it and re open it directly after entering data. What could be the problem?. Causing me headache.

[@599CD]

599cd.com/NoIdea

[@douglascoke4235]

Too Cool!

[@599CD]

Thanks