ms access and active directory

[pablohassan]

Hello

A. I have a form in which one of the fields needs to have default value taken from currently logged user (AD user not access). I will have a table populated by various users, and one column of this table will contain user who added a record.

B. Now, I need to prevent users from deleting / changing records (should open a warning window) if their active directory name is different from the name populated in the record by the code from question A.

Thanks

 

[fneily]

If you post in one of the following, you'll receive more answers:
Microsoft: Access Forms
Microsoft: Access Modules (VBA Coding)
Microsoft: Access Other topics