[libreoffice-users] Base Forms - and subforms

Hi :)
And a little good news ...

Someone gives hints on how they converted an Access database to Base and
thus been able to completely free themselves from Windows.  Peter Goggin is
one of the people working on the Base Handbook that is making it's way to
https://wiki.documentfoundation.org/Documentation/Publications
Regards from
Tom :)



On 29 September 2014 18:09, Peter Goggin <*hidden*> wrote:

> On 30/09/14 01:11, Mark Stanton wrote:
>
> > Have you checked the contacts table directly? I wouldn't mind betting
> > that you *have* been able to add contacts, but they don't have the
> > people primary key.  I think you'll need to do some extra work
> > manually (ie programming, not literally by hand) to get that to work.
> >
> > This is based on a distant memory though, so I may be wrong.
> >
> > Regards
> > Mark
> >
> >
> >
> >  The data in the two tables, people and contacts are the same as in my
> Access base. In the Access forms I can add contacts in the contact subform.
> In the Base forms when I change the person the contacts subform changes to
> match the person. When I checked the table definitions in Base I found that
> the primary key could not be made auto if there was data in the table. I
> deleted all of the data in the contacts table, changed the primary key
> definition and re-imported data. Now my forms work correctly.  One other
> thing, I found that if the spreadsheet format for date was not YYYY-MM-DD
> the import failed.
>
> I now have a fully functional database which does all that I require and
> so can now drop virtualbox, windows XP and OfficeXP from this machine.

-- 
To unsubscribe e-mail to: users+unsubscribe@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