Load all records on startup
Load all records on startup
I have a very simple form that I used the Wizard to create but unless I scroll to the end it only opens a few records at a time ( out of about 2500) so if I use the built in search at the bottom it only search those few records and not everything. How do i get it to OPEN with all everytime?
- Attachments
-
- Capture.JPG (22.98 KiB) Viewed 3014 times
Win10
OpenOffice 4.1.7
OpenOffice 4.1.7
Re: load all records on startup
Does your application face the same situation if you open the table instead?
Thanks for letting me know...
Nick
Thanks for letting me know...
Nick
Libre Office 6.0.7 on Ubuntu 18.04
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: load all records on startup
Ciao, that limitation is only apparent, the asterisk indicates that there are other records beyond 52.
If you hold down the left mouse button on the Next record icon, the number that appears will progressively update.
In other words: everything is fine.
If you hold down the left mouse button on the Next record icon, the number that appears will progressively update.
In other words: everything is fine.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Re: load all records on startup
@ Fred
Should you need to filter your form. Please let me know.
@ Charlie
Grazie Charlie, la parola spettava a te.
Translation:
Thanks Charlie, pretty good hint.
Nick
Should you need to filter your form. Please let me know.
@ Charlie
Grazie Charlie, la parola spettava a te.
Translation:
Thanks Charlie, pretty good hint.
Nick
Libre Office 6.0.7 on Ubuntu 18.04
Re: load all records on startup
Does your application face the same situation if you open the table instead?
Yes it does
Yes it does
Win10
OpenOffice 4.1.7
OpenOffice 4.1.7
Re: load all records on startup
I know the records are there If I scroll down or do as you suggested, but I really would like to be able to open the form and do the search right away. If I dont scroll down (or or more likely simply forget to) so that it shows the record number without the * then the search is limited the the number of records shown with the * - in otherwords I will get a search with no results when I should get dozenscharlie.it wrote: ↑Sun Sep 03, 2023 5:53 pm Ciao, that limitation is only apparent, the asterisk indicates that there are other records beyond 52.
If you hold down the left mouse button on the Next record icon, the number that appears will progressively update.
In other words: everything is fine.
Win10
OpenOffice 4.1.7
OpenOffice 4.1.7
Re: load all records on startup
Thanks thats where I was heading orginally but I am extremely short on time - I looked through the tutorials but couldnt find one to populate a listbox from a textbox ( then the next step would be showing an image from the highlighted record in the listbox) - I tried making a query but cant get the correct phrasing and also cant figure out how to use the textbox keystroke event. so I was just going to go with the built in search
Win10
OpenOffice 4.1.7
OpenOffice 4.1.7
Re: load all records on startup
Good evening Fred,
Glad to hear from you. Please find a first example of a form with images.
Feel free to edit the form and see fields and buttons properties...
Regards
Nick
P.S. : Regarding form with filter, kindly take a look at what follows: download/file.php?id=47559
Glad to hear from you. Please find a first example of a form with images.
Feel free to edit the form and see fields and buttons properties...
Regards
Nick
P.S. : Regarding form with filter, kindly take a look at what follows: download/file.php?id=47559
- Attachments
-
- fishes.odb
- (32.47 KiB) Downloaded 248 times
Libre Office 6.0.7 on Ubuntu 18.04