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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|