[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 website. It's really useful, and a 
pity it wasn't there when I started working with Base (some years ago now).

So double thanks.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
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 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 the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there? 

Could be this is a special behavior of Base-forms. There are two forms 
beneath each other. One form for "filter" and one for "display". I 
change values in "filter". I move to a button in "display". The 
content of "filter" will be saved when I push the button in "display" 
before the action of the button will happen. So there is needed only 
one button, which should refresh the form "display". The query for 
this form will be filtered by the entries in the table "filter". 


> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance. 

Most listboxes will show some text-content, but are linked to a table 
by an Integer-primarykey. So queries for listboxes look like 
SELECT "name", "ID" form "table_names" 
"name" will be shown. "ID" will be saved in the column of the form. 

You must have a look in the properties > data of the listbox. The 
"bounded field" will be '1' by default - and '1' is (a little be 
confusing, because it begins with '0') the second field. 

If the same content should be shown as it will be saved you could set 
this to '0' - so there must be only asked for one field. 

You could also set this to '-1'. This will save the numer of the row. 
I have never used this, but it works ... 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp 
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize 
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ 
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ 
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W 
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t 
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I 
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT 
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 
93NMpdUU7TC9gmjU8JVp 
=u2Z4 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4207833.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 project uses a ticket system called Bugzilla to track defect reports
and enhancement requests found at https://bugs.documentfoundation.org
- you don't need to create an account in that system if all you want to do
is view what is in the works, but you will need to create one to open a new
request or report a bug.
- there is an explanation of the bug entry process here:
https://wiki.documentfoundation.org/QA/BugReport
--  for an enhancement the only difference is enter a severity level of
'enhancement'

Anyway, I haven't said boo here in a long while but recently have been
looking at the issue tracker and I noticed that there is some talk of
adding a 'search and replace' feature for Base which is what got me
thinking it might be a good moment. On the other hand there is a big push
to finish up the support for a different db engine so an RFE might get lost
in the noise of that..

But hey it sounds like a good idea and if you want to start the process
great, if not, I just might..

Best wishes,






On Sat, Jan 28, 2017 at 5:37 AM, ptoye  wrote:

> 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 Office, but I remember them as being
> available in about 2000. And very useful as one doesn't have to learn SQL.
>
> Best regards,
>
> Peter
> mailto:l...@ptoye.com
> www.ptoye.com
>
> -
> Friday, January 27, 2017, 5:43:50 PM, you wrote:
>
>
> 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 parameter
> variables entered on the initial load.
>
> Just a thought and it couldn't hurt. I think your use case is common enough
> that merits a discussion at least.
>
>
> On Fri, Jan 27, 2017 at 10:21 AM, ptoye <[hidden email]> wrote:
>
> > 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 the listbox. But I can't see how the listbox selections get put
> > into the "filter" table. Can you please help me there? I also can't
> > understand why there are two columns in the "listbox_n_simple", but
> that's
> > of less importance.
> >
> > Best regards,
> >
> > Peter
> > mailto:[hidden email]
> > www.ptoye.com
> >
> > -
> > Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
> >
> >
> > -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
> >
> > Robert
> > - --
> > Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> > -BEGIN PGP SIGNATURE-
> > Version: GnuPG v2
> >
> > iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> > bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> > huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> > alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> > SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> > rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> > gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> > q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> > hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> > 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> > JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> > ILXQuH+aT+/Mas+L4BdB
> > =zULF
> > -END PGP SIGNATURE-
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > 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
> >
> >
> >
> >
> > If you

[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 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 the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there? 

Could be this is a special behavior of Base-forms. There are two forms 
beneath each other. One form for "filter" and one for "display". I 
change values in "filter". I move to a button in "display". The 
content of "filter" will be saved when I push the button in "display" 
before the action of the button will happen. So there is needed only 
one button, which should refresh the form "display". The query for 
this form will be filtered by the entries in the table "filter". 
But how is the listbox connected to the table? The only connection I can see is 
by the name. I think it would be strange to say that a control with a name it 
automatically linked with at table of the same name. Also, the "ID" field in 
the "filter" table is set to YES, while its default is NO, which implies that 
something is changing it.




> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance. 

Most listboxes will show some text-content, but are linked to a table 
by an Integer-primarykey. So queries for listboxes look like 
SELECT "name", "ID" form "table_names" 
"name" will be shown. "ID" will be saved in the column of the form.
The query is SELECT "Sys.", "Sys." FROM "searchtable" GROUP BY "Sys." ORDER BY 
"Sys." ASC
So both columns will have the same contents.

 

You must have a look in the properties > data of the listbox. The 
"bounded field" will be '1' by default - and '1' is (a little be 
confusing, because it begins with '0') the second field. 
Some people start with 0, others with 1. It gets confusing when they're both 
working on the same project.


If the same content should be shown as it will be saved you could set 
this to '0' - so there must be only asked for one field. 

You could also set this to '-1'. This will save the numer of the row. 
I have never used this, but it works ... 
I've not heard of that. Thanks. Could be useful.


Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp 
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize 
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ 
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ 
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W 
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t 
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I 
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT 
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 
93NMpdUU7TC9gmjU8JVp 
=u2Z4 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206441.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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

[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 Office, but I remember them as being available in 
about 2000. And very useful as one doesn't have to learn SQL.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Friday, January 27, 2017, 5:43:50 PM, you wrote:


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 parameter 
variables entered on the initial load. 

Just a thought and it couldn't hurt. I think your use case is common enough 
that merits a discussion at least. 


On Fri, Jan 27, 2017 at 10:21 AM, ptoye <[hidden email]> wrote: 

> 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 the listbox. But I can't see how the listbox selections get put 
> into the "filter" table. Can you please help me there? I also can't 
> understand why there are two columns in the "listbox_n_simple", but that's 
> of less importance. 
> 
> Best regards, 
> 
> Peter 
> mailto:[hidden email] 
> www.ptoye.com 
> 
> - 
> Tuesday, January 24, 2017, 4:47:52 PM, you wrote: 
> 
> 
> -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 
> 
> Robert 
> - -- 
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE- 
> Version: GnuPG v2 
> 
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
> ILXQuH+aT+/Mas+L4BdB 
> =zULF 
> -END PGP SIGNATURE- 
> 
> -- 
> To unsubscribe e-mail to: [hidden email] 
> 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 
> 
> 
> 
> 
> If you reply to this email, your message will be added to the discussion 
> below: 
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html 
> To unsubscribe from Can I reload a form based on a parameter query?, click 
> here. 
> NAML 
> 
> 
> 
> - 
> Peter 
> -- 
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html 
> Sent from the Users mailing list archive at Nabble.com. 
> -- 
> To unsubscribe e-mail to: [hidden email] 
> 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 
> 
> 

-- 
To unsubscribe e-mail to: [hidden email] 
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 



If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206380.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.

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" 
> query, which references "filter". The table "filter" has one entry 
> - the selection(s) I made in the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there?

Could be this is a special behavior of Base-forms. There are two forms
beneath each other. One form for "filter" and one for "display". I
change values in "filter". I move to a button in "display". The
content of "filter" will be saved when I push the button in "display"
before the action of the button will happen. So there is needed only
one button, which should refresh the form "display". The query for
this form will be filtered by the entries in the table "filter".


> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance.

Most listboxes will show some text-content, but are linked to a table
by an Integer-primarykey. So queries for listboxes look like
SELECT "name", "ID" form "table_names"
"name" will be shown. "ID" will be saved in the column of the form.

You must have a look in the properties > data of the listbox. The
"bounded field" will be '1' by default - and '1' is (a little be
confusing, because it begins with '0') the second field.

If the same content should be shown as it will be saved you could set
this to '0' - so there must be only asked for one field.

You could also set this to '-1'. This will save the numer of the row.
I have never used this, but it works ...

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3
93NMpdUU7TC9gmjU8JVp
=u2Z4
-END PGP SIGNATURE-

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

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 parameter
variables entered on the initial load.

Just a thought and it couldn't hurt. I think your use case is common enough
that merits a discussion at least.


On Fri, Jan 27, 2017 at 10:21 AM, ptoye  wrote:

> 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 the listbox. But I can't see how the listbox selections get put
> into the "filter" table. Can you please help me there? I also can't
> understand why there are two columns in the "listbox_n_simple", but that's
> of less importance.
>
> Best regards,
>
> Peter
> mailto:l...@ptoye.com
> www.ptoye.com
>
> -
> Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
>
>
> -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
>
> Robert
> - --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> ILXQuH+aT+/Mas+L4BdB
> =zULF
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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
>
>
>
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html
> To unsubscribe from Can I reload a form based on a parameter query?, click
> here.
> NAML
>
>
>
> -
> Peter
> --
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>
>

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

[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 the listbox. But I can't 
see how the listbox selections get put into the "filter" table. Can you please 
help me there? I also can't understand why there are two columns in the 
"listbox_n_simple", but that's of less importance.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, January 24, 2017, 4:47:52 PM, you wrote:


-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 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
ILXQuH+aT+/Mas+L4BdB 
=zULF 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206117.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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

[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 applies to which object, 
but that's a documentation issue.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Thursday, January 26, 2017, 2:49:47 PM, you wrote:


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 :) 

If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206277.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206352.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 January 2017 at 11:20, ptoye  wrote:

> 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:
>
>
> -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
>
> Robert
> - --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> ILXQuH+aT+/Mas+L4BdB
> =zULF
> -END PGP SIGNATURE-
>
> --
> To unsubscribe e-mail to: [hidden email]
> 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
>
>
>
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html
> To unsubscribe from Can I reload a form based on a parameter query?, click
> here.
> NAML
>
>
>
> -
> Peter
> --
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206255.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>
>

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

[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:


-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 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
ILXQuH+aT+/Mas+L4BdB 
=zULF 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206117.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206255.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
ILXQuH+aT+/Mas+L4BdB
=zULF
-END PGP SIGNATURE-

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

[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. the user then has the 
option of changing some of them before clicking the button. So it seems that I 
need two levels of subform - one for the table and one for the fields (rough 
diagram below). Do you know if LO can handle this or will I have to experiment?

Criterion
|
|Table
   |
   |Fields

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Monday, January 23, 2017, 7:37:14 PM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hi Peter, 

> I have a form which at present is based on a parameter query - the 
> user types in a criterion and only the relevant database rows are 
> shown.When I press a button a macro does various actions, including 
> deleting the currently selected row. After all this I want to 
> reload the form to get the latest version (without the deleted 
> row). But a straight Form.Reload asks again for the criterion, 
> which I don't want. 
> 
> Is there any way of doing this? The only way I can think of is to 
> use a dialogue or input box to allow the user to input the 
> criterion and base the query on a SELECT clause incorporating the 
> criterion. 

You could better put the parameter-values in a form and the query in a 
subform. The values in the form could be saved in a table with only 
one row. Call it "filter" ore something else, primarykey is a boolean 
yes-no-field. So you could type the parameter, change to the subform 
and the subform will be reloaded. It will also be reloaded without 
asking again for the paramter, because this is written down in the 
mainform. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYhlsvAAoJELDKYwaoS9AIA2oQAIVHOOeYxoDNA4ZTg3xSNd3Z 
TLi8XosfAzjeef9KpUJlj4YI5r4ybB2HdJgKz9iEeOvQYe871DoDx87w7PNdRRuu 
WuimnIhDshPMdvGaBNJeZ4NlrlUMb2cAuGfyLlPBG8z0hqyLgDBU2qRIkHta+I8Y 
KmQgjmrPLzI1/M+rIDaUhYn0hxYqg0AM4vPRk+a1z1brdeWEwWxqPcHZ+cWqRUGg 
p+SaiBsU9BLDrUZkKhCpxQp2NXm6hy3RmS/UY1qiP5X8YM+//3BjjwT6l25HhEs4 
RDkOJGiI2P+bffqNzHmdMgz3JyNMCYPINfhV7NkRL95ZdmzDOK5iOXDUGJyXjCPx 
rSSoh3ncl9VWqvam15x1i6ZFZ8iYYbU4xngZsmpT/xH19NrWfvawXDQYcxtrT25E 
CfAo4tiJXgA+3QhjOkjuxzRGGEHRXUCIau7Cyi6T/HgHziARW7hyttR51Kfb83+l 
JXuTcjd+5V861km0Kz62XsLthvhIAIFTIE+QI1xeWdzWZUW4oiL1kdZ8OewllYdx 
kMGFoK3OGPTg7FvIf1zfi6M6PKYL3PWVAzHS/D17R+mGKrC+bue1wrWnZs1fvi0J 
uN9Ie+WqsySO5Hnvc7aTE19hj5k8ETdYiGE5Kd/LQ3EXko/rNAfJ7oc/bRWSWE4x 
mV76ym7os90knS+I67NL 
=oFmg 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
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 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206067.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206101.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@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