[Solved]Push Button assigned to same function as Next Record

Creating and using forms
Post Reply
SuchALlama
Posts: 4
Joined: Thu Oct 12, 2017 2:37 pm

[Solved]Push Button assigned to same function as Next Record

Post by SuchALlama »

Hi,

I've been trying to make a stand-alone form, which would take data as input and save it to database.
So, to make a clearer GUI for end-user is there a way to make a macro (or any other way) which would assign push button to do same as "Next Record" in the lower tool bar?


Any help is appreciated.
Last edited by SuchALlama on Fri Oct 13, 2017 10:40 am, edited 1 time in total.
OpenOffice 4.1.3 on Win7
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Push Button assigned to same function as Next Record

Post by Villeroy »

1. You can attach (parts of) a navigation toolbar to the form.
Toolbar "Form COntrols" > [More Controls] > Navigation Bar. Draw it on the form and in the properties you can hide everything but the navigation buttons (first, last, next, prev., new).

2. Draw a button and set its "Action" property.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
SuchALlama
Posts: 4
Joined: Thu Oct 12, 2017 2:37 pm

Re: Push Button assigned to same function as Next Record

Post by SuchALlama »

Thanks for the answers. Just a little question about the second answer:
Villeroy wrote:2. Draw a button and set its "Action" property.
So does this mean basically assigning a macro with a couple of rows of code?
Is there an example for this or do I need to study BASIC or etc. myself from the guide and get it correct with try and error? (Recording macro didn't help much).


e: Okay, I actually got now what you meant as I don't have the OO language in English so I was mistaken. Thanks for this!
OpenOffice 4.1.3 on Win7
Post Reply