Category: Access
MS Access
-
Automating Test Data Loading
Part of the process of creating reports and reviewing the program design involves loading of test data. For the Club Lotto application I wrote the function below to load test ticket sales into the system.
-
Working with Text or CSV Files
Anyone who works with Text or CSV files will know this issue. The CSV file was generated by a machine or exported from a database. But it was opened and saved as a CSV file in Excel by the user to check the contents and in doing so the number value is saved as an exponential value…
-
Offline Club Lotto Automation
Running a club lotto has always been a great way to raise funds, but managing it effectively can be challenging. To streamline this process, we recently introduced Clubforce, a dedicated software solution that allows players to participate in our club lotto online. With Clubforce, players can conveniently choose their numbers, pay through the platform, and…
-
Dynamic Report Heading in an Access Report
When I design an access report which can be used by multiple clients I code the report headings and the data selection for the months to allow the client to change this if required. In the sample above the client financial year starts on the 1st of March. They can set the column heading to…
-
Access Startup on Distributed Applications
When your distributed applications are sent to a wide audience the application may fail to start if the user has not trusted the application and allowed VBA. If your application is programmed to start a form that contains VBA the form may display but all the options will be disabled. To save on support time…
-
Access UI Design
When working on multiple tables to create simple Access UI design forms the process to create each UI can become tiresome. To simplify the process I now take all the fields from the table and place them on the form in the desired position and then call the following code on open event. Access UI…
-
Importing Oracles ALL_TAB_COLUMNS into Access
If you’re working with Oracle databases and need to recreate tables in Microsoft Access for proof of concept or other tasks, Oracles ALL_TAB_COLUMNS view is an invaluable resource. This table provides detailed metadata about all tables, fields, and data types in a given Oracle instance. Here’s how I used it to streamline my process: Step…
-
Deploying Access Databases
When deploying Access databases, it’s essential to enforce best practices for both security and performance. One key strategy I follow is ensuring users only run the program from a local location, such as their personal PC or the My Documents folder, rather than directly from a shared server. The program is linked to either a…
-
Application Deployment
Application Deployment for Access or Excel Apps; When distributing apps I usually create an install program to setup the application correctly for the user. I use Inno setup which does a great job of packaging the files creating the user shortcut and ensuring they have installed the program into the correct location. When deploying these…
-
Checking the References in an Access Database
This code from microsoft learning site is useful to check your references Older version used in our MDBs. This code from the MS site checks the references and can fix broken references – the compile will only work in an mdb version
