AllowAdditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I want users to only be able to Edit the selected
records--no Deletions orAdditions. I have the form AllowEdits propert set to
Yes, and the AllowDeletions and AllowAdditions properties set to No.

When I have records displayed with this form, I can still delete records and
add new records.

Can someone tell me what I am missing?

PS: I am using Access 2002.

Thanks.
 
Check the code in the form, mybe there some code that changing the setting
=================================================
Do you use a subform for the records, and if so did you change this settings
for the sub form and not to the form, or are you deleting strait from the
main form.
 
Martin said:
I have a form that I want users to only be able to Edit the selected
records--no Deletions orAdditions. I have the form AllowEdits
propert set to Yes, and the AllowDeletions and AllowAdditions
properties set to No.

When I have records displayed with this form, I can still delete
records and add new records.

Can someone tell me what I am missing?

PS: I am using Access 2002.

Thanks.
Click to expand...

Post the command that is used to open the form. It might contain an
argument that changes some of those settings.
 
Thanks for the reply.

This is the main and only form. The only code I have is on the Open event
to dispaly another form to prompt the user for query parameters. Would
bringing up that other form cause problems? Would the fact that my form is
set to Datasheet mode have any affect? (I forgot that earlier.)

I have been working on other things since my earlier post. I am trying to
have another query ran when this form is closed. I noticed that event
procedures on things like Close, Deactivate, Unload, etc do not seem to work.
Could this be related to the original problem?

Thanks.
 
At this point, I am just developing this, so I am opening the form by
double-clicking on the form name. Eventually, I plan to open this via VB,
but I haven't gotten that far yet.

Thanks.
 
Martin said:
At this point, I am just developing this, so I am opening the form by
double-clicking on the form name. Eventually, I plan to open this
via VB, but I haven't gotten that far yet.
Click to expand...

I just tested this and using a Datasheet form I was NOT able to delete or
insert new reocrds with those settings so I can't explain what is going on.

Create a test table with one field, throw a few records in and then use
AutoForm to slap up a quick datasheet form for it and try the same settings
(basically what I did). If that one works then you have *some* setting or
code or macro in your current form that is messing with those settings.
 
Thanks for the help. I tried your suggestion of a test table and form and I
cannot delete nor add with the test. Now, just trying to find the problem
with mine.
 
Martin said:
Thanks for the help. I tried your suggestion of a test table and
form and I cannot delete nor add with the test. Now, just trying to
find the problem with mine.
Click to expand...

You might experiment with importing the table and form into a new file and
see if the problem persists. If not then the form might be slightly
corrupted. Deleting it and importing it back from the temp file might fix
it up.
 
Back
Top