Want to see only one month and one date in Micorosft Access form

5 pts.
Tags:
Microsoft Access
I am very new to Access. I am working on an employee db and want to be able to see each one's birth month and day in my form. I currently can see every month and day with the selected ones highlighted. I can change them in the form (ie - they are not 'locked' in the form. How can I 'lock' the selection in the form as well as only see the selections when viewed in my form?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Vikki,


Yes, If you look at your form in “Design Mode”, select your date field, and open the Property Sheet… (That’s on the ribbon, under the Design tab.)


Click on the Data tab of the property sheet. Near the bottom of the list of properties, you’ll see the Locked property. If you set that to True, then no one will be able to change it while viewing your form.


As for the other half of your question about only viewing while looking at your form… What exactly do you mean? Are the users able to view the table? Are you wanting to restrict the viewing to only one record at a time? Are you trying to hide the data any time it’s not being viewed in the form? I’m not clear on just what you are trying to accomplish here.


Regards,


Marvin M80

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    There is a 'locked' property that you should be able to set to "true".  I've only seen it in VBA code, though, but I would expect it to be available at design time.
    69,160 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following