Locks records in access database

Asked By renato 10 points N/A Posted on - 08/05/2011

How can you lock records in MS Access database once you update it? And how will you set up the user interface to include only the form you would like for the user to complete?

Thanks,

Renato

• Status: Open
• Question Views: 854
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Caroline Joseph 0 points N/A #99380

Locks records in access database

Hi,

Yes, you can lock record in the Access database using some VBA code in a form’s OnCurrent event. You can make a field in the table called “ISLOCKED”. After that in the OnCurrent event code is:

IF ISLOCKED THEN

       FORM1.ALOOWEDITS =TRUE

ELSE

       FORM1.ALLOWEDITS = FALSE

END IF

You may also want to set ALLOWDELETIONS too.

If you want to allow the users to see only some textboxes of the form, you need to make then visible or invisible.

IF ISLOCKED THEN

       FORM1.ALOOWEDITS =TRUE

       FORM.TEXTBOX1.VISIBLE = TRUE

ELSE

       FORM1.ALLOWEDITS = FALSE

       FORM1.TEXTBOX1.VISIBLE = FALSE

END IF

Let me know if you have any other questions or comments.

Thanks.

About Caroline Joseph

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/06/2011
• Question Category: MS Access