|  | Can't save after resizing/moving about form fields - MS 2007 | | |
| | | Karen |  |
|  Posted: Wed Sep 17, 2008 11:27 am Post subject: Can't save after resizing/moving about form fields - MS 2007 |  |
I have a form that is filtering the information from a table (i.e., there's a
criteria in the data property/filter field on the form). I can resize the
form fields and move them about in design view but I cannot save the changes.
Each time I "X"
out of the form, I'm prompted to save. I click Yes, then click "X" but it
doesn't close the form or Access.
Are there criteria in the form that could be preventing the acceptance of
the changes to the form?
Appreciation in advance, for all help.
--
Thanks, Karen |
| |
| | | Karen | |
| | Posted: Wed Sep 17, 2008 12:51 pm Post subject: RE: Can't save after resizing/moving about form fields - MS | |
"Has Module" property was set to yes. I changed it to no and allowed all
views except form view and it allowed me to save the changes.
I still have the original form, however. How can I check what module is
attached to this form and whether it is necessary/useful? I'm not too
certain what a module is and what it may do actually.
--
Thanks, Karen
"Karen" wrote:
| Quote: | I have a form that is filtering the information from a table (i.e., there's a
criteria in the data property/filter field on the form). I can resize the
form fields and move them about in design view but I cannot save the changes.
Each time I "X"
out of the form, I'm prompted to save. I click Yes, then click "X" but it
doesn't close the form or Access.
Are there criteria in the form that could be preventing the acceptance of
the changes to the form?
Appreciation in advance, for all help.
--
Thanks, Karen |
|
| |
| | | Klatuu | |
| | Posted: Wed Sep 17, 2008 1:29 pm Post subject: Re: Can't save after resizing/moving about form fields - MS | |
| |  | |
A form module is where any VBA code used by the form kept. It is considered
a Class module because it relates strictly to th form. Whenever you use any
VBA for a form's events, it is in the module.
The code in the form's module can call procedures in other modules.
A form does not require a module, but if you do not have a module, then all
event actions have to be done with macros and expressions.
"Karen" <Karen@discussions.microsoft.com> wrote in message
news:608F363C-BB3D-420E-B58D-619F964E9D61@microsoft.com...
| Quote: | "Has Module" property was set to yes. I changed it to no and allowed all
views except form view and it allowed me to save the changes.
I still have the original form, however. How can I check what module is
attached to this form and whether it is necessary/useful? I'm not too
certain what a module is and what it may do actually.
--
Thanks, Karen
"Karen" wrote:
I have a form that is filtering the information from a table (i.e.,
there's a
criteria in the data property/filter field on the form). I can resize
the
form fields and move them about in design view but I cannot save the
changes.
Each time I "X"
out of the form, I'm prompted to save. I click Yes, then click "X" but
it
doesn't close the form or Access.
Are there criteria in the form that could be preventing the acceptance of
the changes to the form?
Appreciation in advance, for all help.
--
Thanks, Karen |
|
| |
| | | Karen | |
| | Posted: Wed Sep 17, 2008 2:14 pm Post subject: Re: Can't save after resizing/moving about form fields - MS | |
| | | |
Seems like I have a class module on this form but how can I know that for
certain? I.e., how can I check to be certain there is such a code and what it
is? It is quite possible that "Yes" was entered for a reason b/c there is
truly code behind there but I don't want to delete it without knowing the
implications.
--
Thanks, Karen
"Klatuu" wrote:
| Quote: | A form module is where any VBA code used by the form kept. It is considered
a Class module because it relates strictly to th form. Whenever you use any
VBA for a form's events, it is in the module.
The code in the form's module can call procedures in other modules.
A form does not require a module, but if you do not have a module, then all
event actions have to be done with macros and expressions.
"Karen" <Karen@discussions.microsoft.com> wrote in message
news:608F363C-BB3D-420E-B58D-619F964E9D61@microsoft.com...
"Has Module" property was set to yes. I changed it to no and allowed all
views except form view and it allowed me to save the changes.
I still have the original form, however. How can I check what module is
attached to this form and whether it is necessary/useful? I'm not too
certain what a module is and what it may do actually.
--
Thanks, Karen
"Karen" wrote:
I have a form that is filtering the information from a table (i.e.,
there's a
criteria in the data property/filter field on the form). I can resize
the
form fields and move them about in design view but I cannot save the
changes.
Each time I "X"
out of the form, I'm prompted to save. I click Yes, then click "X" but
it
doesn't close the form or Access.
Are there criteria in the form that could be preventing the acceptance of
the changes to the form?
Appreciation in advance, for all help.
--
Thanks, Karen
|
|
| |
|
|
