[Solved] Keyboard shortcuts for forms

Creating and using forms

[Solved] Keyboard shortcuts for forms

Postby geoffrose » Fri Apr 20, 2012 4:44 am

I have a form that browses and edits a table very effectively, no problems. I need keyboard shortcuts for "Next Record," "Previous Record," "New Record" and "Delete Record." I cannot find those operations in Tools > Customize > Keyboard. I've scoured the documentation here and elsewhere, no luck. Can someone here help, please?
[Solved]: The key-customization commands are in Tools > Customize > Keyboard > (.) Base: Form Design > Category > Controls.
Last edited by geoffrose on Sat Apr 21, 2012 9:56 am, edited 1 time in total.
geoffrose
 
Posts: 12
Joined: Tue Oct 12, 2010 1:52 am

Re: Keyboard shortcuts for forms

Postby Villeroy » Fri Apr 20, 2012 9:52 am

In a form for a single record I use Tab which visits to the next record after the last field or Shift+TAB which visits the previous record before the first field.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27223
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Keyboard shortcuts for forms

Postby geoffrose » Fri Apr 20, 2012 11:03 pm

Villeroy, thank you. Unfortunately that requires manually tabbing all the way through the form, and does not address "New Record" or "Delete Record." I was hoping for a more direct solution. I guess my next step is to try keystroke macros. I'll amend this thread if I'm successful. Meantime, others, the question remains open.
geoffrose
 
Posts: 12
Joined: Tue Oct 12, 2010 1:52 am

Re: [Solved] Keyboard shortcuts for forms

Postby geoffrose » Sat Apr 21, 2012 9:59 am

The solution is appended to the text of the original post, now flagged "[Solved]."
geoffrose
 
Posts: 12
Joined: Tue Oct 12, 2010 1:52 am

Re: [Solved] Keyboard shortcuts for forms

Postby Villeroy » Sat Apr 21, 2012 12:30 pm

Thank you for solving this. I was not aware of shortcuts for Base forms.
For those who prefer stand-alone forms: Command category "Controls" is availlable for Writer and Calc too.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27223
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Keyboard shortcuts for forms

Postby ardeley » Sat Nov 24, 2012 6:10 pm

Not sure that this solution goes all the way. Specifically, in Category "Controls" I have tried to add Ctrl+Alt+Right for "Next Record", and Ctrl+Alt+Left for "Previous Record" (these are supposed to be the shortcut-keys for Form Navigation). But I'm not getting the desired result.
OpenOffice 4.0.1 on Windows Vista
ardeley
 
Posts: 3
Joined: Sat Nov 24, 2012 6:00 pm

Re: [Solved] Keyboard shortcuts for forms

Postby sleeve98 » Fri Nov 09, 2018 7:19 pm

Yes, yes, yes, external Writer forms are all well and good - unless you're running into this bug:

https://bugs.documentfoundation.org/sho ... ?id=114596
"Bug 114596 - External forms for a database doesn't save data - closing form with dataloss"

Saw a thread that suggested this was an invalid format/data entry issue, but not this time. :crazy:

Also recall that years ago I saw a way to rig a desktop shortcut to an internal Base form (without "exposing the Base GUI"), whether by extension or macro, by hook or by crook, I don't remember, and can't find it again now.
LibreOffice 6.0.5.2 on Ubuntu MATE 18.04 LTS
sleeve98
 
Posts: 1
Joined: Fri Nov 09, 2018 7:08 pm

Re: [Solved] Keyboard shortcuts for forms

Postby Ratslinger » Mon Nov 12, 2018 7:27 am

sleeve98,

There is another reported bug regarding standalone forms in LO - #112458:
https://bugs.documentfoundation.org/show_bug.cgi?id=112458

which mentions the standalone works in LO if the database is split. I have found this to be correct in my minimal testing.

Also regarding the minimized GUI, this may be what you are referring to:
https://ask.libreoffice.org/en/question/53310/how-do-i-ensure-that-the-lo-gui-is-minimised-on-startup/
LibreOffice 6.1.3
OpenOffice 4.0.1
Ubuntu Mate 18.04
Mint 18.3
Ratslinger
 
Posts: 20
Joined: Sun Mar 01, 2015 3:34 am


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest