[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-02-13 Thread ptoye
Robert, Sorry not to have been back sooner - I got distracted by some more important work than managing my wine. I've worked out now how your filter_without_macros works now, and am in the process of adding the procedures into my database. I've also found your Base handbook on the LO

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-28 Thread Drew Jensen
Howdy Peter, I'm only a user of the software. Anyone can request a change and it is pretty easy to do. Likely getting one of the developers to want to code it will be a bit more of a trick, but there is a process and if no one ever enters a request it certainly won't happen. Just in case: - the

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-28 Thread ptoye
Friday, January 27, 2017, 6:05:01 PM, you wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table > in the Display

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-28 Thread ptoye
Hi Drew, I'm very happy to hear that Base is being worked on. It's always struck me as the Cinderella app in the suite. Would you like me to issue a RFE or will you do it yourself? IMHO, even more important than this would be Update and Delete queries. It's been decades since I used MS

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table > in the Display part of the form is populated by the "filterquery" >

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread Drew Jensen
howdy, Ah, considering that the project is actively working on the Base module at the moment this might be a great time to open a Request For Enhancement. In this case a request to add a ReloadWith (for example) function on the data set (form) which would reload the data using the current

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread ptoye
Hi Robert, I've had a look at some of your forms now, especially filter_without_macros and I'm a bit puzzled. I see that the table in the Display part of the form is populated by the "filterquery" query, which references "filter". The table "filter" has one entry - the selection(s) I made in

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread ptoye
HI Tom, Thanks for this, but my basic question was whether there's an easier way than using macros :) I'm not frightened by macro programming (I wrote my first ever program in about 1961, and was in the profession for far too many years). Except for the difficulty in working out which method

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-26 Thread Tom Davies
Hi :) Chapter 13 of the "Getting Started with LibreOffice" Guide may help with understanding macros. There is an outstandingly good entire book about LibreOffice/OpenOffice macros by Andrew Pitonyak but that probably goes into far more detail than you need right now. Regards from Tom :) On 26

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-26 Thread ptoye
Hi Robert, Thanks very much for the database example. A lot to look at there - I'll have to take some time to work out exactly how your forms and macros work. Best regards, Peter mailto:l...@ptoye.com www.ptoye.com - Tuesday, January 24, 2017, 4:47:52 PM, you wrote:

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-24 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Peter, have a look here: http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb You don't need anything elese but a form and a subform. The example includes different forms, some of them working without any macro. Regards

[libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-24 Thread ptoye
Robert, That sounds great - I'm sure I should have thought of this all by myself. But there's an added complication which I didn't mention before. When the user types in a criterion, this needs to populate a table on the form. He/she then selects a row which fills in some fields in the form.