Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10623 > unrolled thread

Can't save form with buttons

Back to article view | Back to comp.databases.ms-access

Contents

  Can't save form with buttons Sam Peeps <reading@home.now> - 2015-04-14 21:33 +0200
    Re: Can't save form with buttons Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-14 13:55 -0700
    Re: Can't save form with buttons Ulrich Möller <knobbi38@arcor.de> - 2015-04-14 23:30 +0200
      Re: Can't save form with buttons Sam Peeps <reading@home.now> - 2015-04-14 23:37 +0200
        Re: Can't save form with buttons Ulrich Möller <knobbi38@arcor.de> - 2015-04-15 00:47 +0200
          Re: Can't save form with buttons Sam Peeps <reading@home.now> - 2015-04-15 09:02 +0200

#10623 — Can't save form with buttons

I usually add buttons to my forms for record navigaton and form exit. 
Never any problems, until now. Since a few days, if I add one or more 
buttons and close the form, I get an error message saying

"This form or report contains changes that are incompatible with the 
current database format. The form or report was not saved.

In order to save your changes, you must remove any layouts that have 
empty cells in them and/or set the HasModule property for the form to 
No."

Setting HasMOdule to No will save the form, but then the buttons are 
dead.

Forms with existing buttons work fine, so it must be a problem with the 
saving procedure.

I have run Office 2013 Setup and done a repair, followed by the usual 
and time consuming updates. No effect.

Can anyone help, please?

[toc] | [next] | [standalone]

#10624

On Tuesday, April 14, 2015 at 3:34:19 PM UTC-4, Sam Peeps wrote:
> I usually add buttons to my forms for record navigaton and form exit. 
> Never any problems, until now. Since a few days, if I add one or more 
> buttons and close the form, I get an error message saying
> 
> "This form or report contains changes that are incompatible with the 
> current database format. The form or report was not saved.
> 
> In order to save your changes, you must remove any layouts that have 
> empty cells in them and/or set the HasModule property for the form to 
> No."
> 
> Setting HasMOdule to No will save the form, but then the buttons are 
> dead.
> 
> Forms with existing buttons work fine, so it must be a problem with the 
> saving procedure.
> 
> I have run Office 2013 Setup and done a repair, followed by the usual 
> and time consuming updates. No effect.
> 
> Can anyone help, please?

What is the code for saving?  People often use
  docmd.RunCommand acCmdSaveRecord
or
  Me.Dirty = False
in the button for saving records.  What code do you have?

[toc] | [prev] | [next] | [standalone]

#10627

Am 14.04.2015 um 21:33 schrieb Sam Peeps:
> I usually add buttons to my forms for record navigaton and form exit.
> Never any problems, until now. Since a few days, if I add one or more
> buttons and close the form, I get an error message saying
>
> "This form or report contains changes that are incompatible with the
> current database format. The form or report was not saved.
>
> In order to save your changes, you must remove any layouts that have
> empty cells in them and/or set the HasModule property for the form to
> No."
>
> Setting HasMOdule to No will save the form, but then the buttons are
> dead.
>
> Forms with existing buttons work fine, so it must be a problem with the
> saving procedure.
>
> I have run Office 2013 Setup and done a repair, followed by the usual
> and time consuming updates. No effect.
>
> Can anyone help, please?
>
Hi Sam,

just read the error message. Remove any layouts in designer mode before 
saving the form or convert the database into a newer database format.
Forms with layouts containing empty cells are not supported in the older 
db formats before Access 2007.

Ulrich

[toc] | [prev] | [next] | [standalone]

#10628

In article <mgk0s0$sl6$1@dont-email.me>, knobbi38@arcor.de says...
> 
> Am 14.04.2015 um 21:33 schrieb Sam Peeps:
> > I usually add buttons to my forms for record navigaton and form exit.
> > Never any problems, until now. Since a few days, if I add one or more
> > buttons and close the form, I get an error message saying
> >
> > "This form or report contains changes that are incompatible with the
> > current database format. The form or report was not saved.
> >
> > In order to save your changes, you must remove any layouts that have
> > empty cells in them and/or set the HasModule property for the form to
> > No."
> >
> > Setting HasMOdule to No will save the form, but then the buttons are
> > dead.
> >
> > Forms with existing buttons work fine, so it must be a problem with the
> > saving procedure.
> >
> > I have run Office 2013 Setup and done a repair, followed by the usual
> > and time consuming updates. No effect.
> >
> > Can anyone help, please?
> >
> Hi Sam,
> 
> just read the error message. Remove any layouts in designer mode before 
> saving the form or convert the database into a newer database format.
> Forms with layouts containing empty cells are not supported in the older 
> db formats before Access 2007.
> 
> Ulrich

You correctly assume that I use an older format in Access 2013, Ulrich. 
I usually do my databases in Access 2003 format.

I'm probably uncommonly thick, and certainly inexperienced in Access 
tricks. So forgive me for asking: how do I recognise empty cells?
All fields on the form exist in the relevant table, so that can't be 
what is meant by the error message.

[toc] | [prev] | [next] | [standalone]

#10629

Am 14.04.2015 um 23:37 schrieb Sam Peeps:
> In article <mgk0s0$sl6$1@dont-email.me>, knobbi38@arcor.de says...
>> Am 14.04.2015 um 21:33 schrieb Sam Peeps:
>>> I usually add buttons to my forms for record navigaton and form exit.
>>> Never any problems, until now. Since a few days, if I add one or more
>>> buttons and close the form, I get an error message saying
>>>
>>> "This form or report contains changes that are incompatible with the
>>> current database format. The form or report was not saved.
>>>
>>> In order to save your changes, you must remove any layouts that have
>>> empty cells in them and/or set the HasModule property for the form to
>>> No."
>>>
>>> Setting HasMOdule to No will save the form, but then the buttons are
>>> dead.
>>>
>>> Forms with existing buttons work fine, so it must be a problem with the
>>> saving procedure.
>>>
>>> I have run Office 2013 Setup and done a repair, followed by the usual
>>> and time consuming updates. No effect.
>>>
>>> Can anyone help, please?
>>>
>> Hi Sam,
>>
>> just read the error message. Remove any layouts in designer mode before
>> saving the form or convert the database into a newer database format.
>> Forms with layouts containing empty cells are not supported in the older
>> db formats before Access 2007.
>>
>> Ulrich
> You correctly assume that I use an older format in Access 2013, Ulrich.
> I usually do my databases in Access 2003 format.
>
> I'm probably uncommonly thick, and certainly inexperienced in Access
> tricks. So forgive me for asking: how do I recognise empty cells?
> All fields on the form exist in the relevant table, so that can't be
> what is meant by the error message.
>
Open your affected form in design view and press tab to select one 
control after the other. In the property window you can see the given 
name for the selected control or 'EmptyCell'. Select the layout to which 
the empty cell belongs to and remove the layout. Then it should be 
possible to save the form.

Ulrich

[toc] | [prev] | [next] | [standalone]

#10633

In article <mgk5bo$ej2$1@dont-email.me>, knobbi38@arcor.de says...
> 
> Am 14.04.2015 um 23:37 schrieb Sam Peeps:
> > In article <mgk0s0$sl6$1@dont-email.me>, knobbi38@arcor.de says...
> >> Am 14.04.2015 um 21:33 schrieb Sam Peeps:
> >>> I usually add buttons to my forms for record navigaton and form exit.
> >>> Never any problems, until now. Since a few days, if I add one or more
> >>> buttons and close the form, I get an error message saying
> >>>
> >>> "This form or report contains changes that are incompatible with the
> >>> current database format. The form or report was not saved.
> >>>
> >>> In order to save your changes, you must remove any layouts that have
> >>> empty cells in them and/or set the HasModule property for the form to
> >>> No."
> >>>
> >>> Setting HasMOdule to No will save the form, but then the buttons are
> >>> dead.
> >>>
> >>> Forms with existing buttons work fine, so it must be a problem with the
> >>> saving procedure.
> >>>
> >>> I have run Office 2013 Setup and done a repair, followed by the usual
> >>> and time consuming updates. No effect.
> >>>
> >>> Can anyone help, please?
> >>>
> >> Hi Sam,
> >>
> >> just read the error message. Remove any layouts in designer mode before
> >> saving the form or convert the database into a newer database format.
> >> Forms with layouts containing empty cells are not supported in the older
> >> db formats before Access 2007.
> >>
> >> Ulrich
> > You correctly assume that I use an older format in Access 2013, Ulrich.
> > I usually do my databases in Access 2003 format.
> >
> > I'm probably uncommonly thick, and certainly inexperienced in Access
> > tricks. So forgive me for asking: how do I recognise empty cells?
> > All fields on the form exist in the relevant table, so that can't be
> > what is meant by the error message.
> >
> Open your affected form in design view and press tab to select one 
> control after the other. In the property window you can see the given 
> name for the selected control or 'EmptyCell'. Select the layout to which 
> the empty cell belongs to and remove the layout. Then it should be 
> possible to save the form.
> 
> Ulrich

Ulrich, you found the solution. Apparently an empty cell [I never put it 
there] had crept into the form header. Removed it and everything works 
as intended. Thanks very much! Diolch yn fawr! 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web