Selasa, 29 November 2016

RE: [MS_AccessPros] Finding and re-using code

 

Ray,

 

You could set up an Access file as a code library and import the module into it, then export code from it when needed You can also have a compiled version of the library and set up a reference to it in the VBA. With a code library, the code needs to be generic. That sometimes takes a while to design and write but having a code library can prove to be a worthwhile investment of your time.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, November 29, 2016 1:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Finding and re-using code

 

 

Hi Everyone

I'm looking for your thoughts on this, any help appreciated.  I'm finding as I code more modules, I would like to re-use that little trick again.  Rather than rely on my memory that may or not remember that I solved that problem in database xyz, I'd like to save code to be found at a later date.  What I'm thinking is to copy the code into a OneNote page and give it a reasonable title.  I'd be able to search OneNote and copy and paste it into my new database.  Is there a slicker way to have a central code store?  I'm using Office 2016.

Many thanks

Ray

__._,_.___

Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar