473,788 Members | 2,811 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Creating an automatic Record Display mechanism

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
3 2914
How about right clicking the form and selecting Display As Datasheet?

--
Danny J. Lesandrini
dl*********@hot mail.com
http://amazecreations.com/datafast
"DataBard00 7" <an*******@devd ex.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
Put the following code in the Timer event of your form:
If Not Me.NewRecord Then
DoCmd.GoToRecor d , , 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.TimerInterva l = 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******@pcdata sheet.com
www.pcdatasheet.com
"DataBard00 7" <an*******@devd ex.com> wrote in message
news:3f******** *************@n ews.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
"PC Datasheet" <sp**@nospam.sp am> wrote in
news:uu******** *******@newsrea d1.news.atl.ear thlink.net:
Put the following code in the Timer event of your form:
If Not Me.NewRecord Then
DoCmd.GoToRecor d , , 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.TimerInterva l = 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.c aption = "Preview Records"
me.timerInterva l = 0
IsRunning = false
else
me.btnPvwRecs.c aption = "Stop Preview"
me.timerInterva l = 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******@pcdata sheet.com
www.pcdatasheet.com
"DataBard00 7" <an*******@devd ex.com> wrote in message
news:3f******** *************@n ews.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3671
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. And i have things to offer, and to request. And a lot of ideas, but who needs them.... here's an example (from type_struct.py):
2
587
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 to provide users with a mechanism to change the order of items that are listed on the page.For example, the _New York Times_ website (http://www.nytimes.com) lists a bunch of top news articles, and normally these are ordered by purely mechanical...
2
5972
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 a group of Sales people, the customers they deal with and the business they transact with them. I've got my head around all the tables & some of the basic Query structures OK and am beginning to delve into creating the forms I need to be able...
1
1613
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 information on my Vendor_Form. I would like to display the information contained in that field pertaining to whichever record is shown without the user being able to edit this information. Does anyone know how I would go about doing this? (PS...
6
15815
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 to be able to MOVE the records up or down the order. Something like in a WinAmp or MusicMatch Playlist. A little sample code would be much appreciated.
1
1573
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 to child table and also i set the automatic identity generator for it. why it will not add the new record to child table? string connection = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Program Files\\Microsoft SQL...
5
6344
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 displayed on each form as a greeting, while their login name is used to record their activities, as well as compared to a list of positions that allows different users to access different functions on the database. I have noticed two things however: ...
2
1642
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...
25
2672
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
0
9498
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10172
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9967
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6750
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5398
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5536
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4069
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3670
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.