[AccessD] Help on entering data -- when to do it?

[rockysmolin bchacc.com]

I assume you have or can retrieve the ID (I always save the user name, ID, access level, etc. in a global variables when they logged in?).

I would use the On Add event which is triggered when a new record is created.  On Dirty is more appropriate I think for editing when you want to test a record to see if the user has made any changes to the record. But I think  either should work.

HTH


Rocky Smolin
Beach Access Software
760-683-5777
www.bchacc.com
www.e-z-mrp.com
Skype: rocky.smolin
 


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Clark
Sent: Monday, December 23, 2019 10:38 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Help on entering data -- when to do it?

Hey All! There are probably many people here who many not remember me. It has been a very long time since asking any questions here. This is because, (A) because of the list I became quite proficient, and (B) I haven't worked with Access in a very long time -- I've done some little stuff here and there, but no programming in a while. I now inherited one of my favorite tasks (I'm being very sarcastic here) and I am fixing the code of someone who is a non-programmer and wrote code that a department now wants to use.

Maybe it is because I have become rusty, but I now find myself needing some help. I've got it mostly working, but I have one little issue at the moment -- I added a field to find the user ID of the person logged in, and I want to be able to put that in the record, so we can track who made the entry. I initially did this for the onOpen event of the form, but now I am unable to turn off filtering and scroll through all the records. I can hit ESC and then do this, but I don't want the user to have to do this. So I'm thinking I need to assign that field elsewhere -- perhaps OnDirty? That is what I am asking -- at what point should I be putting this in? I never used the even OnDirty in all the years I programmed -- don't know why; just never needed to -- so I'm a bit shaky on what it means exactly. Or perhaps there is a better way to do this?


Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. Thank you for your cooperation.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com