Category Archives: Modules

Microsoft Access Database: Using The Tag Property in Microsoft Access Forms

Microsoft Access Database: Using The Tag Property in Microsoft Access Forms Using a Microsoft Access database always requires a plan when developing software applications, which includes the scoping, specification, building and then testing begore using. Building Access forms and especially … Continue reading

Posted in Forms, Modules, MS Access, VBA | Tagged , , , , | 3 Comments

Microsoft Access Database: Access VBA to Microsoft Outlook Tasks

Microsoft Access Database: Access VBA to Microsoft Outlook Tasks Take a quick look at this Access VBA video (less than 3 minutes) of my latest utility offer demonstrating how to send data using Microsoft Access VBA to a new task … Continue reading

Posted in Forms, Modules, MS Access, Utilities, VBA | Tagged , , , , | 1 Comment

Microsoft Access Database: Why I Don’t Use Microsoft Access Macros

Microsoft Access Database: Why I Don’t Use Microsoft Access Macros I’m often asked about Microsoft Access Macros and Access Modules (VBA) and why we have two ways to program and automate an Access design database application. They both provide a … Continue reading

Posted in Macros, Modules, MS Access, Utilities, VBA | Tagged , , , , | 6 Comments

Microsoft Access Database: Looking For Microsoft Access Application Programmer?

Microsoft Access Database: Looking For Microsoft Access Application Programmer? If your custom built Microsoft Access database application is not providing the service or richness you are after then an Access  application programmer (using Access VBA) maybe the route you nee … Continue reading

Posted in Database Theory, Modules, MS Access, Utilities, VBA | Tagged , , , , | 1 Comment

Microsoft Access Database: Exporting, Importing Microsoft Access VBA Modules

Microsoft Access Database Tutorial: Exporting & Importing Microsoft Access VBA Modules First of all, a big thank you to one of my subscribers (Bob) for giving me the idea and inspiration to mention a little about how to manage Microsoft … Continue reading

Posted in Modules, MS Access, Utilities, VBA | Tagged , , , | 5 Comments

Microsoft Access Database: Protecting your VBA Code in Microsoft Access

VBA (or Visual Basic for Applications) is the main programming language used in Microsoft Access and it provides a rich set of functionality enhancing and adding the ‘bells & whistles‘ to your database application. You will need to start protecting … Continue reading

Posted in Modules, MS Access, Utilities | Tagged , , , , | 1 Comment

Microsoft Access Database: Creating an Audit Trail in Microsoft Access

Some Microsoft Access database systems require an audit trail feature built to track the movement of sensitive records that administrators need to monitor and control data processing tasks. I found this article from a popular database solution resource which is … Continue reading

Posted in Forms, Modules, MS Access, Utilities, VBA | Tagged , , , , | 2 Comments

Microsoft Access Database VBA Programming – 3 Ways How You Can Automate Your Access Application

I haven’t really talked about Microsoft Access database VBA (Visual Basic for Applications) before as this is not for beginners! However, I do get asked about how to program with Microsoft Access using VBA and in some cases macros too. … Continue reading

Posted in Modules, MS Access, VBA | Tagged , , , , | 3 Comments

Microsoft Access Database: How many users can it support?

Microsoft Access Database: User one, two, three …. thirty? About six years ago, I was asked to build an Access Database for over 30 users to utilise and place orders, process them and have other members fulfil the goods in … Continue reading

Posted in Database Theory, Forms, Modules, MS Access, Reports, Tables, Utilities, VBA | Tagged , , , , | 1 Comment

Microsoft Access Database: Create a macro that runs when you open an Access database

Microsoft Access Database – AutoExec Macro Using the AutoExec Macro in Microsoft Access is one of the special reserved macro keyword names that in this case will trigger when you load your database. It is called before any other macro … Continue reading

Posted in Forms, Macros, Modules, MS Access, VBA | Tagged , , , , | 1 Comment