Hello, all -- first time poster. . . I've searched for weeks here and elsewhere for what seems should be an easy solution. I have a table of 3000+ records that I would like to filter with push buttons placed on a form -- each button running a different query. I see that buttons are intrinsically designed to navigate through the table and/or edit a displayed record (not what I'm after), so I assume it would need to be done with a macro called when pushing the button, i.e. an SQL query. I have had no success so far; I've studied BASIC Programming Guide and Pitonyak's guide but still missing it. I understand that there is SO much that I don't know, but have not found the resources I need to learn.
So, two questions:
1 - (Specifically) how to build a macro to filter a table when pressing a button on a form, and
2 - (More broadly) where else can I go for more documentation to learn how to implement the tools included in OO Basic
Thanks -- flyyboyy
[Solved] Filter Base table with buttons on form
[Solved] Filter Base table with buttons on form
Last edited by flyyboyy on Mon Nov 06, 2017 9:54 pm, edited 1 time in total.
OpenOffice 3.1 on Windows 7
-
- Volunteer
- Posts: 1548
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Filter Base table with buttons on form
I found the book “Database Programming with OpenOffice.org Base & Basic” by Roberto Benitez to be helpful.
http://www.baseprogramming.com/
That said, I'm not sure you need a macro. Look at
viewtopic.php?f=100&t=42845
scroll to the bottom and download "LIKE_user_input_filter.odb" for filtering examples without macros.
http://www.baseprogramming.com/
That said, I'm not sure you need a macro. Look at
viewtopic.php?f=100&t=42845
scroll to the bottom and download "LIKE_user_input_filter.odb" for filtering examples without macros.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11