Search results

Solution Here is the solution to getting the Audit Trail table to work on both the Main form and Subform simultaneously, even if they both have different primary keys and the Subform is based on a query (as in my case). As with most Subform/Audit Trail issues, the Main form sends data to the...

Details I have a Profile form that tracks the expiration date for each client’s various certifications. These dates are set up in the Short Date format in the table design of Access. Problem When a user accidentally presses an alphabetic key while updating an expiration date, an Access error...

I found some VBA code that will generate a list of users who are currently logged into my database. I pasted this code into the VBA window of a new blank form, following the instructions from the developer. The problem is I am getting a compile error whenever I run the code. I am using the Front...

I found some code online that creates an Audit Trail for my database. This code captures all changes (new records, edits and deletions) to my database and writes the changes (old and new values) to a table. It works, but it also gives an error message, “Object Doesn't Support Property or Method...

Details: I have a New User form that I inherited. The form adds a new user to the Users table. It works perfectly, but I want to set up validation rules for the form that require First Name, Last Name and Username to be entered BEFORE the Users table is updated. (The password field is set by...

Details: I found some code for the main menu of my form online through a post on this very forum that allows me to disable almost all menu properties/bypass keys, etc. in Access. Here is the link: iaccessworld . com / how-to-disable-properties I have included the code below. There are three...

I have an unbound combo box that I set up in a form using the combo box wizard in Access 2010. I selected the option that says, “Find a record on my form based on the value I selected in my combo box.” The problem is that the combo box will not always display the correct record. It seems to only...

Is there a way to merge duplicate/similar Access 2010 records into one record? I have researched this question numerous times and have not found an answer specific to my needs. I have an Access table with 1,000 duplicate records, although they are similar and not exact duplicates. As you can...