[Solved] Only 41 records insteand of total (655)

Discuss the database features
Post Reply
Rocky62
Posts: 4
Joined: Sat Apr 29, 2017 9:51 pm

[Solved] Only 41 records insteand of total (655)

Post by Rocky62 »

Hi Folks,
when I open a form only 41 records are visible insteand of 655 that exists. Is possible to solve this problem and how?
Thanks a lot!
Last edited by Rocky62 on Thu May 11, 2017 10:53 pm, edited 1 time in total.
Open Office 4.1 on Windows
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: only 41 records

Post by Villeroy »

Scroll down.
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
Rocky62
Posts: 4
Joined: Sat Apr 29, 2017 9:51 pm

Re: only 41 records

Post by Rocky62 »

Thanks for replay.
I tried to scroll down but in doesn't works :ucrazy: and I've necessitary push the jamp last record button on nthe navigation bar...
Open Office 4.1 on Windows
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: only 41 records

Post by Villeroy »

A database table can have billions of records. Base only loads a screenful at a time and reloads when more records are requested.
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
Rocky62
Posts: 4
Joined: Sat Apr 29, 2017 9:51 pm

Re: only 41 records

Post by Rocky62 »

ok. Thanks!
...but real problem is due to the fact that the find function does'n work if all records isn't set down.... :roll:
so, I realy ask for a solution to this problem. Do you know samthing like a macro?
Open Office 4.1 on Windows
Arineckaig
Volunteer
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: only 41 records

Post by Arineckaig »

but real problem is due to the fact that the find function does'n work if all records isn't set down
If "the find function" is that provided by the binocular icon on the Form Navigation Toolbar, then it should work by selecting a couple of its tick boxes. See viewtopic.php?f=13&t=63645#p282336. Macros tend to be specific to each application and are preferable as a last resort.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Only 41 records insteand of total (655)

Post by Nocton »

but real problem is due to the fact that the find function does'n work if all records isn't set down
Set to search backwards will solve the problem.
OpenOffice 4.1.12 on Windows 10
Rocky62
Posts: 4
Joined: Sat Apr 29, 2017 9:51 pm

Re: Only 41 records insteand of total (655)

Post by Rocky62 »

Thanks Nocton. It works!
Open Office 4.1 on Windows
Post Reply