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! 3 2892
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.
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!
"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!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: svilen |
last post by:
hello again.
i'm now into using python instead of another language(s) for
describing structures of data, including names, structure,
type-checks, conversions, value-validations, metadata etc....
|
by: Ken Fine |
last post by:
(originally posted to one of macromedia's groups; no help, so hopefully
someone here can help me out. I'm using VBScript ASP.)
When designing administrative interfaces to websites, we often need...
|
by: Iain Miller |
last post by:
Now this shouldn't be hard but I've been struggling on the best way as to
how to do this one for a day or 3 so I thought I'd ask the assembled
company.....
I'm writing an application that tracks...
|
by: Kelly Olsen |
last post by:
I have created an automatic update field in my Vendor_Table that
automatically updates the date in that field to respond to any changes
made to the record. However, I would like to display this...
|
by: Prakash |
last post by:
Hi !!
In a Continuous Form with say 10 records, I'd like to have 1 button
with an "UP" Arrow & another button with a "DOWN" arrow. By pressing
either the Up or the Down Arrow, I'd like the user...
|
by: csharpa |
last post by:
I have 2 tables Patient(parent) , Battery(Child). when i gave input to it, in parent table the new record will be added but in child table the new record will not be added although I'm sending the FK...
|
by: tech.rawsteak |
last post by:
I have a function that retrieves a user's login name from their
workstation and looks it up on an employee table to return their full
name (ie: jsmith -John Smith). Their full name is then...
|
by: maykut |
last post by:
Is there anybody knows anything about "automatic discovery mechanism". What is it? And what is it using for?
Thans for your help in advance...
|
by: sidd |
last post by:
In the following code:
int i = 5; ---it goes to .data segment
int j; ---it goes to bss segment
int main()
{
int c;
int i = 5; ---stack
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |