allowAdditions = False

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobUCSD - 29 May 2007 22:53 GMT

Is there a work around to the allowAdditions = False problem where the screen
goes blank?

I want the user to open a form and only be able to work on the record if
they have clicked on the edit button. But with allow additions set to False,
the screen comes up blank. If the form has only the allowEdits set to False,
they can add data to a new record without clicking the edit button.

I also need to force them to click edit as I have code that checks if they
have rights to edit and add new.

Your help is greatly appreciated. Thanks Rob

Reply to this Message

Ken Snell (MVP) - 30 May 2007 02:42 GMT

Enable and lock all the controls on the form, then display the data. You'd
need to provide programming to unlock the desired controls for editing, or
(my preference) pop up a form that displays the record selected for editing
and then let the user edit it in the popup form (be sure to requery the
first form when done editing in the popup form).

Signature

Ken Snell
<MS ACCESS MVP>

> Is there a work around to the allowAdditions = False problem where the
> screen
[quoted text clipped - 11 lines]
>
> Your help is greatly appreciated. Thanks Rob

Reply to this Message

missinglinq - 30 May 2007 10:38 GMT

I'm confused by your statement:

"with allow additions set to False, the screen comes up blank."

Under this condition (AllowAdditions = False) the screen only comes up blank
if the form's Record Source is empty! If there are records to be shown,
they'll be there!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

RobUCSD - 30 May 2007 15:27 GMT

the form is not a continuos form, it only shows and allows edits to one
record. When the form is opened and if there is not already an existing
record, a new one can be added. So if I set the allowAdditions = false, the
form comes up blank and the control to allowEdits (cmdEdit) and
allowAdditions (also behing the cmdEdit) is not visible. Any ideas would be
greatly appreciated. I thnk ken has the right approach. Thanks, rob

> I'm confused by your statement:
>
[quoted text clipped - 3 lines]
> if the form's Record Source is empty! If there are records to be shown,
> they'll be there!

Reply to this Message

John Smith - 31 May 2007 15:19 GMT

I've not had to tackle this in a while but if I remember correctly you need to
put cmdEdit in the form header or footer to ensure that it is still there when
there is no record.

HTH
John
##################################
Don't Print - Save trees

> the form is not a continuos form, it only shows and allows edits to one
> record. When the form is opened and if there is not already an existing
[quoted text clipped - 8 lines]
>> if the form's Record Source is empty! If there are records to be shown,
>> they'll be there!

Reply to this Message