How do the original NavigationButtons work?

  • Thread starter Thread starter reinumag
  • Start date Start date
R

reinumag

Hi.

Kind of a stupid situation, but I need to scroll through some 10000
records of a form, to calculate some values for them.

I cannot do it simply by going through a recordset with VBA code, as
the data relations are quite complex and it would need a lot of coding.

I tryed to automatize the scrolling process by using DoCmd.GoToRecord ,
, acNext or .movenext in the Form_current sub.
These things work well for some 300 records, and then crash. But when I
am simply keeping mouse down on the original access navigation button,
and scrolling the records, no errors appear (just needs 15 minutes of
waiting to get till the other end..)

So what am I missing out here? Why do the original navigation buttons
work and the code fails? If anybody knows a way how to simulate the
navigation button click in a more reliable way, any ideas would be
appreciated.

Tnx,
Reinumag
 
Hi.

Kind of a stupid situation, but I need to scroll through some 10000
records of a form, to calculate some values for them.

I cannot do it simply by going through a recordset with VBA code, as
the data relations are quite complex and it would need a lot of coding.

I tryed to automatize the scrolling process by using DoCmd.GoToRecord ,
, acNext or .movenext in the Form_current sub.
These things work well for some 300 records, and then crash. But when I
am simply keeping mouse down on the original access navigation button,
and scrolling the records, no errors appear (just needs 15 minutes of
waiting to get till the other end..)

So what am I missing out here? Why do the original navigation buttons
work and the code fails? If anybody knows a way how to simulate the
navigation button click in a more reliable way, any ideas would be
appreciated.

Tnx,
Reinumag
Click to expand...

If you have 10000 records and you wish to go to record 8940 quickly,
all you need do is write 8940 in the record number display box. You
can then continue scrolling from there if you want.

As to why your buttons crash, who knows. We can't see your database.
 
Well, that's not the problem. I want to go through ALL of the 10000
records. And preferably not to see the process.
 
Back
Top