A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 5th, 2009, 04:03 PM posted to microsoft.public.access.forms
babs
external usenet poster
 
Posts: 409
Default not able to save/added text box or label in design view of some fo

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
  #2  
Old November 5th, 2009, 05:46 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default not able to save/added text box or label in design view of some fo

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?
--
Daryl S


"babs" wrote:

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

  #3  
Old November 5th, 2009, 06:04 PM posted to microsoft.public.access.forms
babs
external usenet poster
 
Posts: 409
Default not able to save/added text box or label in design view of som

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

  #4  
Old November 5th, 2009, 06:22 PM posted to microsoft.public.access.forms
babs
external usenet poster
 
Posts: 409
Default not able to save/added text box or label in design view of som

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

"babs" wrote:

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

  #5  
Old November 6th, 2009, 02:41 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default not able to save/added text box or label in design view of som

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.



--
Daryl S


"babs" wrote:

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

"babs" wrote:

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

  #6  
Old November 6th, 2009, 04:09 PM posted to microsoft.public.access.forms
babs
external usenet poster
 
Posts: 409
Default not able to save/added text box or label in design view of som

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" wrote:

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.



--
Daryl S


"babs" wrote:

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

"babs" wrote:

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

  #7  
Old November 6th, 2009, 05:26 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default not able to save/added text box or label in design view of som

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?

--
Daryl S


"babs" wrote:

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" wrote:

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.



--
Daryl S


"babs" wrote:

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

"babs" wrote:

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

  #8  
Old November 23rd, 2009, 04:08 PM posted to microsoft.public.access.forms
MacNut2004
external usenet poster
 
Posts: 73
Default not able to save/added text box or label in design view of som

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

"Daryl S" wrote:

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?

--
Daryl S


"babs" wrote:

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" wrote:

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.



--
Daryl S


"babs" wrote:

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

"babs" wrote:

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

"Daryl S" wrote:

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?
--
Daryl S


"babs" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.