Excel and Access Training and Application Development
Here is a way to launch a calendar control against an unbound textbox on a user form. Yes, you can simply add a field to a form and specify the Format attribute to be a date format (e.g. Medium Date) and then ensure the Show Date Picker field is set to For Dates. The user […]
Forcing a Calendar on a Text Field Read More »
Database developers often face the dilemma of how to provide different access permissions to their databases for different users. For example: Certain forms or all forms should only be displayed Read/Only to some users, OR One or more fields on a form should either be disabled or not displayed at all Access does not include
Controlling User Access Read More »
Scenario: Your Access database environment consists of a backend database (containing the shared data tables), with each user maintaining their own copy of the frontend database (containing local tables, forms, queries, reports and modules) stored locally on their PC. As the database administrator, you are likely updating and enhancing database functionality contained in database objects within the
Distributing Database Objects to User Databases Read More »
This one was intended to solve an issue that I regularly faced. I often have both a test and production version of a database and I found it arduous to transfer new versions of database objects (tables, forms, queries, reports, modules) from my test to production environments. I spent too much time selecting each individual
Transferring Multiple Database Objects Between Databases Read More »
As an Access administrator, there are times when you need exclusive use of the database to make modifications. Often you may discover that others are already in the database, but you have no easy means to determine who. There are hacks available on the web to interrogate the database locking file, but there is a
Keeping Track of Who is in the Database Read More »
To minimize the Access ribbon when a database opens, add the following line of VBA: CommandBars.ExecuteMso “MinimizeRibbon” To prevent the ribbon from displaying at all, add this VBA statement: DoCmd.ShowToolbar “Ribbon”, acToolbarNo Creating a macro called Autoexec forces actions to take place as the database opens. For example, if you need to run a procedure
It is often helpful to provide the user a subset of current queries and reports available in a database, and allow that user to edit, run, and export the results. This avoids the need to acquaint the user with all the potential pitfalls of using the database navigation and administrative tools. This example provides a
Queries and Reports Form Read More »
In this example, I provide a simple form allowing the user the option to select entries from an “Available” list to be added to a second “Selected” list. In this scenario, we have an Employee table (tblEmployees) with EmployeeID as the unique field (and primary index). In the listboxes, we only want to show the
Select Items and Move to Another Listbox Read More »
This example provides the user a means to immediately change languages on all open forms at the click of a button. It is currently designed to flip between two languages (in this case English and French), but with some simple modifications, could be extended to support additional languages. Note that only captions are translated… text