[Solved] Filter Base table with buttons on form

Creating a macro - Writing a Script - Using the API

[Solved] Filter Base table with buttons on form

Postby flyyboyy » Thu Nov 02, 2017 3:10 am

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
Last edited by flyyboyy on Mon Nov 06, 2017 9:54 pm, edited 1 time in total.
OpenOffice 3.1 on Windows 7
flyyboyy
 
Posts: 1
Joined: Thu Nov 02, 2017 2:25 am

Re: Filter Base table with buttons on form

Postby UnklDonald418 » Thu Nov 02, 2017 5:01 pm

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
https://forum.openoffice.org/en/forum/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 subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 587
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 8 guests