Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "access vba" (Page 2)

Tag Archives: access vba

Compile Access? What About Decompiling Microsoft Access Databases Too?


Microsoft Access Database

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 code as both source and compiled code and sometimes some of the compiled VBA code can become corrupt meaning it needs to be flushed or rinsed clean. Therefore, running Microsoft Access in a “decompile” mode causes all the compiled VBA code to be flagged as invalid which then is […]

Tags: , , , , ,

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


Microsoft Access Database

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 first part below: Working With Access VBA Recordsets Using DAO or ADO: 3 Key Points With VBA Recordsets Here are 3 key points to note and be mindful of when coding with Access VBA using either DAO or ADO to connect with other databases. There are common traps and useful tips […]

Tags: , , , ,

Microsoft Access To Excel VBA – Automating Between MS Office Applications


Microsoft Access

The power of Microsoft Access to Excel VBA is revealed here in this quick two and half minute video demonstration of how popular Microsoft Office applications are & can communicate when using Access VBA (Visual Basic for Application code) Microsoft Access To Excel VBA – Automating Between MS Office Applications Now you’ve seen it done – how does it work? Using Access to Excel VBA requires some foundation VBA code knowledge and may say they are not programmers – well […]

Tags: , , , , ,

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


Microsoft Access 2007

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 Access macros lack or is limited by creating references and links with other proccesses including custom built functions. Allows you to communicate with other applications and across platforms increasing the seamless power of Access VBA (Visual Basic for Applications). You can gracefully handle errors (if or when they happen) and will happen from time to […]

Tags: , , , ,

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


Access Database VBA

Some of my subscribers send me emails regarding learning about Access database VBA and when they should use it. So I’ve written the first part (of two) given you 7 reasons why. First thing to note and that is it’s not an exclusive component to Microsoft Access and that is also is available and compatible with other Microsoft Office applications including Microsoft Excel, Microsoft Word and Microsoft Outlook. Access VBA has the power to communicate with other applications beyond the […]

Tags: , , , ,

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 or Requery command using the Me object which is very handy indeed. Take a look at the following article… Microsoft Access – Refresh Or Requery? When using Microsoft Access, many novice developers have difficulty understanding the difference between Me.Refresh and […]

Tags: , , , ,

← Older posts Newer posts →