[libreoffice-users] How to change Writer form letter database connection

2016-10-11 Thread Gary Dale
How does one go about changing the database that a form letter connects to? I have this problem in several "form letters". I want to connect to a different database than the one they were created against for the simple reason that I have a different set of data that I want to print against. I

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-11 Thread Tom Davies
Hi :) Is it F4 to bring up a "connected databases" toolbar? Regards from Tom :) On 11 October 2016 at 17:00, Gary Dale wrote: > How does one go about changing the database that a form letter connects to? > > I have this problem in several "form letters". I want to connect to a > different databa

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-11 Thread Gary Dale
No. I think you're thinking about Ctrl-Shft-F4 which brings up the the Data Sources toolbar. Actually, it's started working now for some reason. The error message I was getting has gone away. Weird. On 11/10/16 12:22 PM, Tom Davies wrote: Hi :) Is it F4 to bring up a "connected databases" t

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-11 Thread Gary Dale
Spoke too soon. The data source changes but not the fields. Unless I change the fields in the document (re-insert them from the current data source), they show up as blank. This is NOT what I want. I want the fields to move to the new data source. In fact, I can't think of a reason for the cur

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-12 Thread Paul D. Mirowsky
Are the field names identical from original to newer data? Are you creating new/updated queries? I'm always switching to new single source databases from boilerplate Writer and haven't had a problem. I have not tried multiple sources though. Also beware that while the fields may update to the

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-13 Thread Gary Dale
On 12/10/16 11:00 AM, Paul D. Mirowsky wrote: Are the field names identical from original to newer data? Are you creating new/updated queries? I'm always switching to new single source databases from boilerplate Writer and haven't had a problem. I have not tried multiple sources though. Als

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-14 Thread Paul D. Mirowsky
In my circumstance, I am copying over an old database to a new one and changing the name. Then I add new data to the new database. After that I update the query to access the new data only. I copy over to a new database as a way to remove old records (data) and keep Base from losing it when it

Re: [libreoffice-users] How to change Writer form letter database connection

2016-10-16 Thread Gary Dale
Thanks Paul. You're right, that does work. However it begs the question of why bother to bring up the database selection dialogue in the initial Mail Merge panel - especially given that it doesn't actually work? IMHO the Edit | Exchange Database menu item is a travesty that should be removed.