Not to allow entering data from Datasheet view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Situmorang - 30 Oct 2007 11:27 GMT

Hello,

Can anybody help me how to make datasheet view of the form not to allow
entering data?, ecxept for for a check box field?. All entering the data
should be from Form view

Thanks

Frank

Reply to this Message

Klatuu - 30 Oct 2007 15:01 GMT

Set the Enabled property to No and the Locked property to Yes for all
controls except the check box.

Signature

Dave Hargis, Microsoft Access MVP

> Hello,
>
[quoted text clipped - 5 lines]
>
> Frank

Reply to this Message

Kitform - 30 Oct 2007 15:56 GMT

>Hello,
>
[quoted text clipped - 5 lines]
>
>Frank

I don't think you can protect the actual table itself as this would
stop the 'form' from functioning. If you just want to edit data from
a form then I would suggest you hide the column in the table to stop
people entering data via the table itself.

It won't stop anyone who really wants to edit the table directly but
it would prevent novice users from 'poking' about with the table and
force them to use the form instead.

HTH

Reply to this Message

Kitform - 30 Oct 2007 19:33 GMT

>>Hello,
>>
[quoted text clipped - 16 lines]
>
>HTH

In fact you could hide the table all together by renaming it.
add Usys to the begining of the table and it will hide it as a system
object.

Reply to this Message