In this Microsoft Access Tutorial TechHelp video, I'll show you how to set up your form so that users can ADD new records, but they can't EDIT or DELETE existing data. We will learn how to use the Allow Edits and Allow Deletions properties. I'll also show you how to set up a quick and simple Admin form so YOU can make changes, but your regular users can't.

Hema asks, "Hi. Can you help me? How do you disable data editing after inputting values in a form? I tried locking but it is not allowing me to enter new data as well."

BONUS FOR CHANNEL MEMBERS: Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. They will learn how to set up a Main Menu form and set it as the Startup Form for the database. Learn how to disable the Navigation Pane, most of the Ribbon, and the Shortcut Menus so your users can't go poking thru your database. Learn how to ask for a PASSWORD to gain access to the Admin Menu. Plus lots more.

Become a member here: [ Ссылка ]

MEMBERS ONLY VIDEO: [ Ссылка ]

RESOURCES:

FREE Customer Template Database: [ Ссылка ]
Locked v. Enabled: [ Ссылка ]
Allow Additions: [ Ссылка ]
Allow Edits: [ Ссылка ]
Allow Deletions: [ Ссылка ]

FREE Access Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Your Questions Answered: [ Ссылка ]
Learning Connection 50% OFF: [ Ссылка ]

Richard's Blog: [ Ссылка ]
Access Forum: [ Ссылка ]
Twitter: [ Ссылка ]

Email Me: amicron@gmail.com

[ Ссылка ]
[ Ссылка ]
[ Ссылка ]

TOPICS COVERED IN MEMBER VIDEO:
Creating a Main Menu Form
Setting a Startup Form
InputBox Function for a Password
Form .AllowEdits .AllowDeletions Properties

свернуть