By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,444 Members | 3,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,444 IT Pros & Developers. It's quick & easy.

Creating an automatic Record Display mechanism

P: n/a
My Access 97 database has a form that contains text boxes that display
people's names, addresses, phone numbers, etc. The record source is a
single table.
I created a NextRecord and Previous Record command button that, when
clicked, will display the next record and the previous record,
respectively.
But what if I want a quick glance at all my records? Is there a way to
get the records to display automatically, one after another, with a time
lag of about .25 seconds? If so, can I do it with the command buttons
and by modifying the code that is currently in their event procedures?
Please let me know. Thank You.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
How about right clicking the form and selecting Display As Datasheet?

--
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"DataBard007" <an*******@devdex.com> wrote ...
My Access 97 database has a form that contains text boxes that display
people's names, addresses, phone numbers, etc. The record source is a
single table.
I created a NextRecord and Previous Record command button that, when
clicked, will display the next record and the previous record,
respectively.
But what if I want a quick glance at all my records? Is there a way to
get the records to display automatically, one after another, with a time
lag of about .25 seconds? If so, can I do it with the command buttons
and by modifying the code that is currently in their event procedures?
Please let me know. Thank You.

Nov 12 '05 #2

P: n/a
Put the following code in the Timer event of your form:
If Not Me.NewRecord Then
DoCmd.GoToRecord , , acNext
End If

Add a command button to your form and label it Preview Records. Put the
following code in the Click event of the button:
Me.TimerInterval = 500

When you click the button, the records will advance on your form every half
second. To speed it up to every quarter second, change the 500 to 250. The Timer
Interval is in milli-seconds (1/1000 of a second).
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DataBard007" <an*******@devdex.com> wrote in message
news:3f*********************@news.frii.net...
My Access 97 database has a form that contains text boxes that display
people's names, addresses, phone numbers, etc. The record source is a
single table.
I created a NextRecord and Previous Record command button that, when
clicked, will display the next record and the previous record,
respectively.
But what if I want a quick glance at all my records? Is there a way to
get the records to display automatically, one after another, with a time
lag of about .25 seconds? If so, can I do it with the command buttons
and by modifying the code that is currently in their event procedures?
Please let me know. Thank You.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #3

P: n/a
"PC Datasheet" <sp**@nospam.spam> wrote in
news:uu***************@newsread1.news.atl.earthlin k.net:
Put the following code in the Timer event of your form:
If Not Me.NewRecord Then
DoCmd.GoToRecord , , acNext
End If

Add a command button to your form and label it Preview
Records. Put the following code in the Click event of the
button: Me.TimerInterval = 500
The O.P. will need a bit more complex function in the command
button, because as written, it can't be stopped once started.

what I've done for something similar is to create a form level
boolean variable, IsRunning, and the following code in the
btnPvwRecs on click event

if IsRunning then
me.btnPvwRecs.caption = "Preview Records"
me.timerInterval = 0
IsRunning = false
else
me.btnPvwRecs.caption = "Stop Preview"
me.timerInterval = 500
IsRunning = true
end if
Bob Q

When you click the button, the records will advance on your
form every half second. To speed it up to every quarter
second, change the 500 to 250. The Timer Interval is in
milli-seconds (1/1000 of a second).
--
PC Datasheet
Your Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DataBard007" <an*******@devdex.com> wrote in message
news:3f*********************@news.frii.net...
My Access 97 database has a form that contains text boxes
that display people's names, addresses, phone numbers, etc.
The record source is a single table.
I created a NextRecord and Previous Record command button
that, when clicked, will display the next record and the
previous record, respectively.
But what if I want a quick glance at all my records? Is
there a way to get the records to display automatically, one
after another, with a time lag of about .25 seconds? If so,
can I do it with the command buttons and by modifying the
code that is currently in their event procedures? Please let
me know. Thank You.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.