Category Archives: MS Access

MS Access: HTML Editor Control to Use in Forms

If you want to get HTML editor within MS Access form, there are couple of solutions available. The free solution I know is to get Not So Elegant HTML Editor. The problem with this editor is that After looking at this editor, you will never say “so cool” It is good for basic editing but […]

List of MS Access Properties Available Through CurrentDB.Properties

CurrentDB.Properties is nothing but a collection. If you can iterate through a collection, you will be able to get the list of all the properties. Code to iterate through all properties is It gave me the following list of properties. I don’t know the data types of the these properties but I put it for […]

ADODB Command.Execute Does Not Return Error for RAISERROR

Description I was executing a stored proc which would halt its execution using RAISERROR. When I tried to run the stored proc in Query Analyzer it worked fine and gave me error but in VBA it couldn’t halt the execution and continued to the next statement.

MS Access Pass-Through Query Error: Cannot Execute a Select Query

When I tried to run an UPDATE statement from pass-through query, it throwed error “Cannot execute a select query”. This is due to that fact the property ReturnsRecords is set to True which requires the pass through query to return results. If it does not return recordset, it will throw an error. You can correct […]

MS Access: Check If The Normal Form Or Subform Form Is Loaded

If you need to check if MS Access form is loaded or not, you can easily check it using the folloing code This code is good until you are using single form application. This code will fail if the form is used as subform. To search all the forms including subform, I have created a […]

Microsoft Access: Why qdf.execute Is Not Showing Any Warning?

I had an application in which I had a code like The query was not running because of error but the application was not breaking at the time of error generation. To force the application to break/throw exception write the statement like This way we can catch all errors.