Insert File

Insert File

There’s a fantastic, useful, clever feature of MS Access (actually I think it’s in all of the VBA products) where you can store code snippets in the normal file structure of Windows. Basically you have a folder which is accessed quickly and easily through the — >>>Insert >>>File — menu. This menu is shown when you are in the VBA interface. When you open it, you have access to this folder. You can have subfolders in any/all of those folders. You can have text files containing your code, Code Modules, Code Snippets, Class Modules Anything Textual you Want! Clicking on any of the text files automatically copies the contents of that text file straight into your Code/Class Module. But here’s the thing, you can also access any of those code snippets stored in the text files and edit them. You can simply and easily keep your stock of code available, ready and updated. And to top it all, it’s immediately available to any of your MS Access database projects.

"Insert File" - Demonstration

"Insert File" - Demonstration

Video 1 (Less than a Minute!)

Insert File Demonstration. In this video I show you how to quickly and easily insert a code snippet into your MS Access form Code Module using “file – Insert” menu option. In particular, I demonstrate inserting a “Custom Property” which, in this particular case is designed to hold an “Object Variable”…

Video 1 (0:38)

Nifty Access YouTube Thumb Nail
Play Video

… …

Add to "Insert File"

Add to "Insert File"

Video 2 (Less than a Minute!)

In this 40 second video clip I demonstrate how easy it is to add and modify code in the “File Insert” section of “MS Access”… It’s one of the little used features of MS Access. It’s so helpful and can speed up your development process no end. If you are not currently using it I highly recommend you get conversant with it, start adding your favourite code snippets in there. I find the biggest problem is “Categorising my Code Snippets” I never know whether to categorise it by objects like, Form, Report, Module — or by what the code does! If you’ve got any ideas, then I’m all ears! 

I’ve also made a note of this Tip in the Nifty Tips section of my website…

Video 2 (0:40)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

Leave a comment

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.