Prev: Save or Update command
Next: Hyperlink in access 2007 opens with intranet instead of windows vi
From: steve on 14 Apr 2010 13:13
Im using a datasheet view to look at two tables. I dont know how to
make it so that I can only add data into both of these datasheets but
not be able to change previous data.

How can I do this in a datasheet view and a form view. I asume its a
property somewhere? I can get it so I cant add or change anything but
not the combination I mentioned above.

(Access 2002)

Thanks.
From: Al Campagna on 14 Apr 2010 13:43
steve,
As you probably know, you shouldn't be updating any data directly
through the tables. Always build a form to do that.
And... that form's Data Entry property, when set to YES, will only
allow new records to be added to the table. You would not be able to
access any previously entered records through that form.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"steve" <stevesemple(a)lycos.com> wrote in message
news:973c1ce0-60ac-4c9a-9156-c11082e13f1a(a)b23g2000yqn.googlegroups.com...
> Im using a datasheet view to look at two tables. I dont know how to
> make it so that I can only add data into both of these datasheets but
> not be able to change previous data.
>
> How can I do this in a datasheet view and a form view. I asume its a
> property somewhere? I can get it so I cant add or change anything but
> not the combination I mentioned above.
>
> (Access 2002)
>
> Thanks.


From: Hans Up on 14 Apr 2010 14:03
steve wrote:
> Im using a datasheet view to look at two tables. I dont know how to
> make it so that I can only add data into both of these datasheets but
> not be able to change previous data.
>
> How can I do this in a datasheet view and a form view. I asume its a
> property somewhere? I can get it so I cant add or change anything but
> not the combination I mentioned above.

Assuming you're talking about a form in datasheet view, you can set the
form's properties (on the "Data" tab of the property sheet) to:

Allow Edits No
Allow Deletions No
Allow Additions Yes

If you want the users to see (but not be able to modify or delete)
existing records, set the Data Entry property to No. If you do not want
them to view previous records --- only add new --- set Data Entry to Yes.

If your goal includes similar restrictions when directly opening tables
(not within a form), the usual answer is "Don't do that!" Your users
should interact with the data only through forms ... not table (or
query) datasheets.
From: steve on 14 Apr 2010 16:47
Thanks for your help.

I have followed the instructions
> Allow Edits No
> Allow Deletions No
> Allow Additions Yes
>
> If you want the users to see (but not be able to modify or delete)
> existing records, set the Data Entry property to No. If you do not want
> them to view previous records --- only add new --- set Data Entry to Yes.

No
No
Yes
Yes

but when I look at the datasheet it does not show me any previous
records, which I want people to see because, well they need to. Any
thoughts?

Regards
From: Hans Up on 14 Apr 2010 17:32
steve wrote:
> Thanks for your help.
>
> I have followed the instructions
>> Allow Edits No
>> Allow Deletions No
>> Allow Additions Yes
>>
>> If you want the users to see (but not be able to modify or delete)
>> existing records, set the Data Entry property to No. If you do not want
>> them to view previous records --- only add new --- set Data Entry to Yes.
>
> No
> No
> Yes
> Yes
>
> but when I look at the datasheet it does not show me any previous
> records, which I want people to see because, well they need to. Any
> thoughts?

Set the Data Entry property to No.

 |  Next  |  Last
Pages: 1 2
Prev: Save or Update command
Next: Hyperlink in access 2007 opens with intranet instead of windows vi