Category Archives: VBA

Microsoft Access Forms: Working With The KeyPreview Property

Microsoft Access Forms: Working With The KeyPreview Property Working and managing data via Microsoft Access forms is only as good as the design and if the user becomes frustrated then don’t expect your database (and you) to receive any credit. One element overlooked when … Continue reading

Posted in Database Theory, Forms, Modules, VBA | Tagged , , , , | 2 Comments

Access Form Controls: Coloured Tabs For Your MS Access Forms

Access Form Controls: Coloured Tabs For Your MS Access Forms Working with Access form controls may not always be as flexible as one would like and a particular control that comes to mind is the Tab Control. I have often … Continue reading

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

Access CurrentUser Function: Are There Any Benefits Here?

Access CurrentUser Function: Are There Any Benefits Here? Some of my students during a training session recently discovered the Access CurrentUser function listed from the Expression Builder tool which is one of the predefined members of the MS Access ‘built-in … Continue reading

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

Using An Access Data Entry Form With Some VBA

Using An Access Data Entry Form – Querying A Database With Some VBA It’s during day three of an Access training course teaching keen ‘developer’ students the art to using an Access data entry form and immediately they realise creating such a form is … Continue reading

Posted in Forms, MS Access, Queries, VBA | Tagged , , , , | 1 Comment

Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window

Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window Here is one my free weekly tips (No. 86) for you that I wanted to share today because one particular client recently asked how you can … Continue reading

Posted in MS Access, Queries, Utilities, VBA | Tagged , , , , | 3 Comments

What Is Database Auditing – Microsoft Access Tools

What Is Database Auditing Using Microsoft Access Tools? The question I’m often asked is What is database auditing and how do I create an audit trail in Microsoft Access? The second part to that question means the inquisitor has realised there … Continue reading

Posted in Database Theory, Forms, MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

Access Forms VBA: IsLoaded Property Check

Access Forms VBA: Using The IsLoaded Property Most of the time when developing with MS Access to achieve a really smooth look and feel to your database you will need to eventually code your application and one area where you … Continue reading

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

How To Convert Numbers To Words: Access VBA Function

How To Convert Numbers To Words: Access VBA Function Once again, I’ve been asked by a client to create procedure to turn a monetary number (numerical value) into its text equivalent and so I wanted to share with you how … Continue reading

Posted in Functions, Modules, MS Access, VBA | Tagged , , , , | 2 Comments

How To Backup Access Database Files

How To Backup Access Database Files – The Conventional Way With most versions of this database application, you have a built-in utility to backup a database (mdb or accdb) file and just in case you were not aware of how … Continue reading

Posted in MS Access, Utilities, VBA | Tagged , , , , | Leave a comment

Microsoft Access Programming – VBA InputBox Function

Microsoft Access Programming: Learn How to Use The VBA InputBox Function Let’s get some prospective here regarding the VBA Inputbox function by first identifying if there is a real need to use this function at all considering we can build … Continue reading

Posted in Modules, MS Access, VBA | Tagged , , , , | Leave a comment