DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly

DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly

am 09.04.2008 02:35:40 von learning_codes

Hi....

I am learning about read only. I set read only but except one field
that need to be edit. I am not going to figure it all night long.
Please help me if there is a way to make "edit" one field and other 7
fields should be read only on the form.

I would appreciate your help.
Thanks

Re: DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly

am 09.04.2008 03:43:07 von fredg

On Tue, 8 Apr 2008 17:35:40 -0700 (PDT), learning_codes@hotmail.com
wrote:

> Hi....
>
> I am learning about read only. I set read only but except one field
> that need to be edit. I am not going to figure it all night long.
> Please help me if there is a way to make "edit" one field and other 7
> fields should be read only on the form.
>
> I would appreciate your help.
> Thanks

In Access help, look up the
Locked property
and the
Enabled property.

Set the Locked property of each control on the form you do NOT wish to
be editable to Yes.
Or..
Set their Enabled property to No.
Or..
Set both their Locked property to Yes and their Enabled property to
No.

Experiment with the differences between them.

The just open the form normally.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Re: DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly

am 09.04.2008 04:18:06 von Lyle Fairfield

"learning_codes@hotmail.com" wrote in
news:6b13f200-a77c-4549-b8d8-8a41d1b2d28a@s8g2000prg.googleg roups.com:

> I am not going to figure it all night long.

One generally learns 37 other things if one takes the trouble to "figure it
all night long".

I know, I know. The time when work and study were valued activities of
which one was proud are long past.

Well I can understand that. If you do work hard when you're old the
government will say, "Not poor, eh?" and then it will punish you.

No apologies for industry, frugality or sound investment will be accepted.
YOU WILL BE PUNISHED!