Right now my process for deploying updates to a database called chm_tracker.mdb
to an access database includes
1.- Finishing up all the modifications and verifying that it works.
2.- Decompile the chm_Tracker.mdb
3.- Compact and Repair database
4.- ReCompile the database
5.- Make an MDE from the database that gets saved in a network location called "j:\shared\topio\shipping\"
6.- Notify all the users in the outlook list TrackerUpdates that a new version has been place on the server
This is what I want to automatize but I don't know if I can do this from inside the tracker database
or jsut create anew database with a very simple form to perform this activity.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…