G
Guest
Good morning you all! I have a problem and since reading through all these
posts actually gives me new hope in finding the answers to my other problems,
I thought I would try asking a question to my new problem.
My work decides to assign me the task of making this huge database for one
of our task force. Since I have computer knowledge and they don't, they
think I the best thing since sliced bread. But anyway, here is my problem...
In one of my tables, I have a "Yes/No" field created named "ArchivedChk". I
am using this Yes/No field as a checkbox in the data entry form. Also in
this table, I have two other fields created. One is named "DateArchive" and
the other is "ReasonArchived". In the form, I also have these three fields
present, but in the form, I want the two fields "DateArchived" and
"ReasonArchived" to be greyed out or "Locked". Basically the way that I
would like for it to work is when the user checks the "Yes/No" checkbox, the
"DateArchived" and the "ReasonArchived" becomes available for the user to
input information. Any other time they would be "Locked" out. I hope I
didn't confuse any of you in trying to explain this and if so, please forgive
me. I am not an expert in VBA or any other developing tool. As a matter of
fact, I just started using Access this year and I learned quickly. So if you
can help me out with this question, it would greatly be appreciated!! Thank
you so much!!
Sincerely,
Leonard Peacock
posts actually gives me new hope in finding the answers to my other problems,
I thought I would try asking a question to my new problem.
My work decides to assign me the task of making this huge database for one
of our task force. Since I have computer knowledge and they don't, they
think I the best thing since sliced bread. But anyway, here is my problem...
In one of my tables, I have a "Yes/No" field created named "ArchivedChk". I
am using this Yes/No field as a checkbox in the data entry form. Also in
this table, I have two other fields created. One is named "DateArchive" and
the other is "ReasonArchived". In the form, I also have these three fields
present, but in the form, I want the two fields "DateArchived" and
"ReasonArchived" to be greyed out or "Locked". Basically the way that I
would like for it to work is when the user checks the "Yes/No" checkbox, the
"DateArchived" and the "ReasonArchived" becomes available for the user to
input information. Any other time they would be "Locked" out. I hope I
didn't confuse any of you in trying to explain this and if so, please forgive
me. I am not an expert in VBA or any other developing tool. As a matter of
fact, I just started using Access this year and I learned quickly. So if you
can help me out with this question, it would greatly be appreciated!! Thank
you so much!!
Sincerely,
Leonard Peacock
