Search results

@ faryusuf: I too could not get the delete Audit Trail code to work during testing either. I'm sorry you ran into trouble. I did not mention it because I never used the delete portion of the Audit Trail code for the systems I designed as the records were required to be tracked permanently. @...

I haven't been able to visit the forums lately, so I apologize for the late response. I'm busy with a new database myself, so I understand your frustration. There are several ways to accomplish what you are trying to do, but my response below is based solely on the example I posted on 1/21/16...

@RuralGuy Thank you. This link saved me from a migraine.

@hambees Try this: Limit new records to only the entry of the name of your person/product and the primary key (whether it is auto-numbered or not), then force the record window to close and train your Users to open the newly created record to enter the remaining details, which would force the...

@hambees It sounds like you may be missing a specific VBA library reference in Access needed to make the Audit Trail work. I will amend my original post to include it. My apologies for not including this step in my original post. Solution: You must have the Microsoft ActiveX Data Objects 2.8...

@fenhow I will do my best to help. I had the exact same problem with the "Object Does Not Support This Property or Method" error message and it turned out to be an area of the tab control on my subform was tagged that SHOULD NOT have been tagged because I used CTRL A to tag the entire subform...

You are quite welcome! It can be difficult finding solutions online. Sometimes you find a solution summary when what you really need is an answer template instead.

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...

@MarkK Thank you for bringing this to my attention. I now fully understand what error was made. As a result, I have revised my code with the corrections you have shown in Post #15, tested it and found that it works perfectly. Thank you once again!

Correction Post #13 has an error in it on my part. Revising the original code in Post #9 to make it more like a Case statement caused all keys to be disabled, not just alpha keys. Here is the corrected code based on the If/Then statement from Post #9 with the entire list of VBA key codes needed...

@MarkK A million thanks! This is PRECISELY what I was asking for originally. You have solved my problem. I can see now that my original code would have worked had I used the following line of code to call the function: KeyCode = DisableAlphaKeys(KeyCode) Thank you so much! I did revise my code...

@MarkK Thank you for your post. I will try this and report back.

@jdraw The expiration date fields in my Access table are in fact set up as date/time fields using the Short Date format. But as I mentioned before, any non-numeric keys (except for "/" and "-") generate an Access validation rule error message which only confuses my users. Disabling the keys I...

@jdraw My current case statement works fine. This was never the problem. I am only asking to re-write my case statement from Post #1 as a function so that it can be called when needed for date controls. I don't want users to see Access error messages because they are confused by them, that's...

@MSAccessRookie Thank you for your help, but as I mentioned in my reply to jdraw, I am trying to write a function. I am not looking for a shorter case statement. Please re-read my original post.

@jdraw Thank you for the suggestion of using values instead of individual letters for the case statement. This does shorten the code, but I am still interested in writing a function. The Date Picker is already set up as a part of the control, but it is not always used. Some users use 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...

@pbaldy, Everything is working fine now. I found the place on the tab control where the Audit tag was inadvertently listed and removed it. Apparently, tab controls have several clickable areas and I overlooked one of these when removing unnecessary "Audit" tags. Thanks again!

When you ran the code (Audit Trail) did it track the changes you made in fields that were not tagged? I ask because the instructions included with the code indicated that I must tag the fields I want to track, otherwise the software is useless.