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 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.
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!
"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!
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. 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):
|
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...
|
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...
|
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...
|
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.
| |
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...
|
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:
...
|
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: 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,...
|
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...
| |
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |