473,326 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Form/Timer

Hi.

In Access 2000 VBA there is Private Sub Form_Timer()object. What can i
do with it? What's the use of it?

Hannu
Nov 13 '05 #1
4 11285
On 30 Sep 2004 23:01:08 -0700, Hannu wrote:
Hi.

In Access 2000 VBA there is Private Sub Form_Timer()object. What can i
do with it? What's the use of it?

Hannu


Well, you could make a label blink on and off every second,or change
color, or close the form if no one has entered data for, say , 10
minutes.

Set the Timer Interval to 1000 (for 1 second).
Code the Timer event:
If [DateControl] < Date() Then
If [DateControl].BackColor = vbWhite then
[DateControl].BackColor = vbRed
Else
[DateControl].BackColor = vbWhite
End If
End If

The date control will alternate backcolors if the date is before the
current date.

Set the Timer Interval to 0 to discontinue the code in the error
event.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2
I once built a form which initiated some very heavy-duty queries against a
SQL Server database. Because the queries took a long time to run, I had
them run asynchronously so the user could be getting on with something else
(a neat trick, works well). I displayed a "Query Running" label, and I used
the form's timer to check every few seconds whether the query was still
running so I could hide the label when it was done.

Never used it for anything else that I can recall.

"Hannu" <ha***************@niiralankulma.fi> wrote in message
news:e6**************************@posting.google.c om...
Hi.

In Access 2000 VBA there is Private Sub Form_Timer()object. What can i
do with it? What's the use of it?

Hannu

Nov 13 '05 #3
ha***************@niiralankulma.fi (Hannu) wrote in
news:e6**************************@posting.google.c om:
Hi.

In Access 2000 VBA there is Private Sub Form_Timer()object.
What can i do with it? What's the use of it?

Hannu


Be Creative! I have a welcome message when an application starts,
that disappears after 5 seconds. The main form of the app takes
about 6 seconds to open so the welcome screen delay distracts the
user for most of that. I'm not making the app faster, just the
user's perception of time. .

Another application has a form that monitors the number of users
logged into a third application. The form's timer event is used
to requery the number of users who have not logged out, every
minute.

You can rewrite a datetime label so that it looks like a digital
clock.

etc.

--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #4
Bob Quintal <rq******@sPAmpatico.ca> wrote in message news:<1096674972.K+vE4RvTeWaey4rKnKfkPg@teranews>. ..
ha***************@niiralankulma.fi (Hannu) wrote in
news:e6**************************@posting.google.c om:
Hi.

In Access 2000 VBA there is Private Sub Form_Timer()object.
What can i do with it? What's the use of it?

Hannu


Be Creative! I have a welcome message when an application starts,
that disappears after 5 seconds. The main form of the app takes
about 6 seconds to open so the welcome screen delay distracts the
user for most of that. I'm not making the app faster, just the
user's perception of time. .

Another application has a form that monitors the number of users
logged into a third application. The form's timer event is used
to requery the number of users who have not logged out, every
minute.

You can rewrite a datetime label so that it looks like a digital
clock.

etc.


Could you please send the code how can i do for instace wellcome
message, which disappears after 5 seconds? Or the code how the form
will be close after 5 minutes if the user do not use it?

thanking Hannu
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
1
by: JC Lewis | last post by:
Looking for code to determine how long it takes for a form to open. Comparing form design. Want to use fastest form. *** Sent via Developersdex http://www.developersdex.com *** Don't just...
3
by: yysiow | last post by:
hi all, now i want to write timer in web form, but i don't know how to write, anybody can tell me. thanks..
15
by: Trint Smith | last post by:
I know how to set a timer in a windows app, but is it possible to fire an event, with out too much processing, every 1000 mil. sec.s using the web form timer? I noticed there's no 'tick' in the...
3
by: aprivate | last post by:
Hi I am having some problem with a form timer. I added a progress bar to increment its value and the timer works when I use form1.showdialog() However when I use form1.show, form1.refresh()...
0
by: Robm | last post by:
I have a minimized form in a 24/7 app which uses a form timer to check various conditions. Sometimes the timer event stops firing until the mouse is moved or a key is pressed. There are other forms...
5
dima69
by: dima69 | last post by:
I have bumped into a strange Access bug. When inactive form has Timer event set, any RunCommand action, like acCmdCopy, (at another form or table) will fail with an error. Is anybody familiar with...
6
by: ewokspy | last post by:
I have a C# program in 2003 that creates a reminder bubble (windows form) to remind a user to pick up their printout. The bubbles show up fine, and they have 2 buttons, a yes and a snooze. The yes...
5
by: stoogots2 | last post by:
I have a Windows Form app in which a Windows Timer (when it ticks) starts a new thread to do a long running process. ThreadStart ts = new...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.