?
Solved

Make form data invisible to data entry user Access 2010

Posted on 2016-08-04
3
Medium Priority
?
84 Views
Last Modified: 2016-08-04
In Access 2010, I have an employees form. When a new user needs to input their information, I want them to be able to open the form and type in their info, but not see any info of other employees. I just want them to see a blank form for data entry. How can I do this in Access 2010
0
Comment
Question by:contrain
3 Comments
 
LVL 23

Expert Comment

by:Kelvin Sparks
ID: 41743368
Set the forms property  for Data Entry to True.

Kelvin
0
 
LVL 42

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 41743369
The same way you would do it in all the other versions.  Open the form in Add mode.

docmd.OpenForm "xx",acNormal,,,acFormAdd

If the form is always ONLY going to be used for "Adds", then you can set the DateEntry property on the Data tab of the form properties dialog to Yes.
0
 

Author Closing Comment

by:contrain
ID: 41743393
This was the best solution; it was very complete, gave me options and let me know where to find the option I was looking for and what to look for in the drop down list. This accomplished what I needed to do.
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question