Recent content by andigirlsc

  1. A

    Using Audit Trail on a Subform with a Different Primary Key

    @ 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. @...
  2. A

    Using Audit Trail on a Subform with a Different Primary Key

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

    Run-time error '2467':

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

    Using Audit Trail on a Subform with a Different Primary Key

    @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...
  5. A

    Using Audit Trail on a Subform with a Different Primary Key

    @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...
  6. A

    Using Audit Trail on a Subform with a Different Primary Key

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

    Using Audit Trail on a Subform with a Different Primary Key

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

    Using Audit Trail on a Subform with a Different Primary Key

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

    Create Disable Alphabetic Keys Function Based on Case Statement

    @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!
  10. A

    Create Disable Alphabetic Keys Function Based on Case Statement

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

    Create Disable Alphabetic Keys Function Based on Case Statement

    @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...
  12. A

    Create Disable Alphabetic Keys Function Based on Case Statement

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

    Create Disable Alphabetic Keys Function Based on Case Statement

    @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...
  14. A

    Create Disable Alphabetic Keys Function Based on Case Statement

    @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...
  15. A

    Create Disable Alphabetic Keys Function Based on Case Statement

    @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.
See more
Top Bottom