Restrict a Table

R

Rick Brandt

One way:

Create an INTEGER field in your table and the Validation Rule is set to

IN (1,2,3)

Then set the Required property to True.

Now you have to supply a value for the field and it can only be 1,2 or
3.
Click to expand...


It would also need to be uniquely indexed though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Protecting Word 2019 document 0
Restrict a Table number of Records 5
Word 2013 - Could not remove Restrict editing 0
Clearing Fields in a Word Form 5
Restrict a Text Box 9
Restricting User Access In Access 2010 Sharepoint With Hydrated Database 0

Top