Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2008

Tip: Looking for answers? Try searching our database.

Moving to Last record and display

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Samantha - 29 Apr 2008 07:36 GMT
Hi All,

I'm using the form to both display data and data entry. When displaying
data, I have swich off the AllowAddition property of the form, and turning it
back on for data entry. The detailed records are displayed on the Details
section of the form.
The form is set to have record selectors at the bottom. I have trained the
end users to look at the record selectors at the bottom to understand how
many total detailed records are associated with each header ID.  The total
records are displayed next to the record selectors.
The problm is that for whatever reason, it is very slow when trying to
display mulitiple detailed records. Is there a way to manually "move to the
last record" so that we bottom left hand corner of the total records show up
faster? Unless I'm doing something totally ineffective to cause this slow
down in record retreival?
Thanks so much in advance.
Jeanette Cunningham - 29 Apr 2008 07:46 GMT
Samantha,
this is the default access behavior when the form has a large number of
records.
The form loads quicker by loading with only a few records, the rest of the
records load in a few seconds.

> Hi All,
>
[quoted text clipped - 15 lines]
> down in record retreival?
> Thanks so much in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.