not able to save/added text box or label in design view of some fo

[babs]

I have inherited a database and want to modify some forms - I looked in the
user groups and permissions and everything show editable- nothing set up in
here - prev. user not adv. enough to set this up??

I am able to add a text box and or labels to Some of the forms but not to
others. I looked at the properties ALL tab for One of the forms I CAN edit
vs. One I can not SAVE after I edit - the only difference in the ALL tab
properties of the Form is the Has Module Property ( the one I can edit is
set to No and the one I can't is set to Yes)

I do not know what this setting is for?- could that be the reason why I
can't save the changes in design view and should I set the one I can't edit
to NO???

Not sure what that propety is for???

thansk soo much,
barb

 

[Daryl S]

The Has Module property only indicates that there are procedures attached to
the form - usually behind controls on the form or for events on the form
itself. It does not control whether or not you can save any design changes
to the form.

What kind of message do you get indicating you cannot save the changes to
the form?

 

[babs]

It just asks me if I want to save the form when I go to close it even after I
click on the save button- then I say yes - and form Won't close only if I say
no to save - when reopen - changes made are NOT saved??

thanks,
barb

 

[babs]

when I change has module in properties to NO , I am able to save the changes
to the form - it does warn me that code will be deleted- then also said
macros and event proc. will not be affected??? I copied whole database and
messed with a copy - it appears to work fine even when I change the has
Module to No - NOT sure if it really deletes any code- not clear on why now I
can save form if has nothing to do with saving??for the has module???

thanks,
barb

 

[Daryl S]

Babs -

I would suggest you make another copy of your original database and look at
the code behind the form. You can do this by choosing Modules, and opening
any of them. In the code window, to the left, look for the form you are
working on (in the Microsoft Office Access Class Objects folder of the
Project window).

Double-click on the name of your form to see the code in the large window to
the right. Use the left-hand drop-list at the top of the code window to
select 'Form' to see what code has been entered on form events. Maybe there
is something on the Open or Close event that is causing the issues. There
may be an explanation along with the code.

 

[babs]

I made a copy and am looking at that.

There is only One module in the entire database - when i try to open it it
says it does not exist.

I know there is No event procedure in the Properties window of the overall
form- there is some vb code tied to some command buttons but even when I made
a copy before of the database and turned the has module to no - the command
button work- not clear on what the has module - yes vs. no really does???

for some reason when set to yes - can Not save changes to the form(and close
it) but when turn it to No -can save changes????????
I don't want to clear out any Code- not sure there is any though?????
besides the event procedures on the dif. control boxes/text boxes?


any other ideas?
thanks again for helping
barb

 

[Daryl S]

I wonder if the database is corrupt. I'm sure you have compacted/repaired it
by now. You may want to be safe and open a blank database and import all the
objects from this one and see if that helps.

I would like to know if anyone has encountered this, or has any other ideas?

 

[MacNut2004]

Hello,

I actually have the same problem. I was exporting a form to my master
database, and my computer froze up, so I had to reboot. Well NOW, that form
that i tried exporting...it will not allow me to save any changes I make to
it, it will not allow me to save as, it will not allow me to RENAME that form
even!

What can I do to correct this??

Thanks,
MN