Re: [libreoffice-users] Base - need to re-point a form

That's exactly what I wanted and couldn't find anywhere! I'm very grateful

John

On 17 October 2012 21:14, Girvin R. Herr <girvin.herr@sbcglobal.net> wrote:

> John Clegg wrote:
>
> > I have a base file attached to a MySQL database on a remote server. I have
> > a form that I use to view and edit the data in one table.
> >
> > Others also access the database, and I need to experiment with the data in
> > that table without molesting the master copy.
> >
> > One solution would be to make a complete copy of the database, but as I
> > want to make copies of the main table many times a day that would be a
> > laborious solution
> >
> > It is easy to make a duplicate of the main table within the database, and
> > also easy to make a copy of the form in the base file, but what I need to
> > do now is point the copy of the form at the copy of the table.
> >
> > I thought it might be possible to open the odb file as a zip file and find
> > the form data containing the table name somewhere in it, and edit it to
> > the
> > copy table name, but I haven't succeeded yet.
> >
> > Does anybody know if this is possible - or even if there is a much easier
> > way?
> John,
> I am assuming you need to change the table that your form points to.  You
> can do this by:
>
>   1. Bring up your form in edit mode (right click on form name and
>      select "Edit".)
>   2. Select the "Form Properties" window (this is the icon that looks
>      like a window with 2 buttons with an arrow pointing to it, and
>      with a help balloon that says "Form".
>   3. In the popup window, select the "Data" tab.
>   4. Change the "Content" box to the table you want to use from the list.
>
> If the new table's column (control) names are different, you will have to
> change those too in the form editor.  You do that by Ctrl-left-clicking on
> the form's control box and selecting its "Data" tab and selecting the new
> name from the list derived from your new table.  Do that for each control
> that has a different name from your old table.
> Hope this helps.
> Girvin Herr
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org <users%2Bhelp@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted