Category Archives: Modules

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 , , , , | 2 Comments

Using Access Forms VBA: Passing Values Using OpenArgs

Using MS Access Forms VBA: Passing Values Using OpenArgs Just getting to grips with Access Forms VBA? A very popular keyword is the DoCmd object and this command calls one of several actions within the database application including how to … Continue reading

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

Microsoft Access Properties: What’s The ‘HasModule’ Property In An Access Database?

Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database? There are many Microsoft Access properties to set and control your Access database with and when combined in certain permutations, it changes the whole dynamics of your database … Continue reading

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

Compile Access? What About Decompiling Microsoft Access Databases Too?

Compile Access? What About Decompiling Microsoft Access Databases Too? The Compile Access VBA and the need to decompile your code can significantly reduce the file size of your Access database and also resolves corruptions (if found). Microsoft Access stores VBA … Continue reading

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

Access DAO or ADO: 3 Key Points Microsoft Access VBA Recordsets

Access DAO or ADO: 3 Key Points Microsoft Access VBA Recordsets I wrote an EzineArticle this month about Access DAO (and ADO) using Microsoft Access VBA focusing on the Recordset object and just in case you missed it, here’s the … Continue reading

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

Access Requery Or Not To Requery – That Is The Question

Access Requery Or Not To Requery – That Is The Question The following four methods can be found in Microsoft Access and have different uses: Access Requery Access Refresh Access Repaint Access Recalc They can be split into two parts … Continue reading

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

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2 So here are the remaining 3 (of 7) reasons why you should use Access database VBA in your application. Manage more powerful procedures that Microsoft … Continue reading

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

Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010)

Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010) This quick 2 minute video tutorial shows you how to handle Access security warning for version 2007 (which is the similar for Microsoft Access 2010). Take … Continue reading

Posted in Macros, Modules, MS Access, Utilities | Tagged , , , , | Leave a comment

Microsoft Access Database: Access VBA Database Refresh or Requery?

Microsoft Access Database: Access VBA Database Refresh or Requery?   One of the quickest ways when using an Access VBA database and is also a shortcut to relisting and rebuilding data lists and control values is to call the Refresh … Continue reading

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

Microsoft Access Database: Access DLookup Function Example with Access VBA

Microsoft Access Database: Access DLookup Function Example with Access VBA Take a look at this six and half minute video of how to utilise the Access DLookup function using a little of Access VBA code too (not too difficult but … Continue reading

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