ms access – Useful code

VBA – Create Query with VBA

By Vitosh Posted on September 6, 2014 Posted in VBA \ Excel Tagged with create query, ms access, query, VBA

There are many ways to create a query in Access. However, creating a query with VBA code is something quite challenging. The code below creates an object of type query, named “MyQuery”. The SQL of the object is also given …

VBA – Create Query with VBA Read more »

VBA – Access – Export a table in HTML and other tricks

By Vitosh Posted on March 10, 2014 Posted in VBA \ Excel Tagged with access, export table in html, html export, html table export vba, ms access, ms access vba, table export vba, VBA, vba export table

After showing some tricks for VBA MS Access, I have decided to go back to the field again to find a way to export a table in HTML format. Actually, VBA and Microsoft have taken care of the issue (no …

VBA – Access – Export a table in HTML and other tricks Read more »

Tag: ms access

VBA – Create Query with VBA

VBA – Access – Export a table in HTML and other tricks