Not to allow entering data from Datasheet view

F

Frank Situmorang

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
 
K

Klatuu

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

Kitform

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
Click to expand...


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
 
K

Kitform

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
Click to expand...



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.
 
Top