VBA is not a scripting language. It compiles. As such, it has compilation arguments, which can be changed through code or manually. In MS Access you may find these here: VBEditor>Tools>VBA Project>Database Properties: If you want to use them for…
Tag: access
VBA – Populate data in Access table with VBA
Sometimes you may need to populate data in Access table with VBA. This is actually quite useful, when you are building VBA Access tools. In the current example I will use hardcoding for the data entries, which are to be populated,…
VBA – Access – convert “HH:MM:SS” to double and back
MS Access is something very … interesting. For the last week I was building something on it, which includes dealing with data in HH:MM:SS format. Access has a pretty good feature for dealing with this, but this feature somehow crashes…
VBA – Access – Export a table in HTML and other tricks
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…
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
Top