Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-31-2012, 09:54 AM   #1
Newly Registered User
Join Date: Jul 2011
Location: CA
Posts: 186
Thanks: 24
Thanked 0 Times in 0 Posts
umair434 is on a distinguished road
timestamp when a button is clicked


So I have a form set up which has a button.. the onclick event of this button runs some code and produces a report.. This usually takes 2-3 mins.

I am actually looking for a way that if it has been less than 20 mins since the user clicked that button, a macro is skipped (no need since data wont be updated)..i.e a line of code is skipped.

something alone the line:

If datediff("mi", timestamp, now()) < 20 then..

^ something's wrong here .. any suggestions please?

umair434 is offline   Reply With Quote

button , form , timestamp , user activity

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
activate button after another button clicked honnour Forms 7 07-07-2012 05:16 AM
disable button until button above is clicked newtoaccess Forms 2 07-16-2009 11:15 AM
Update a timestamp when a button is pressed JBHTeng05 General 3 05-29-2008 10:54 AM
Question about Radio button and Timestamp fastmike Forms 2 09-20-2007 08:00 AM
Button and timestamp kermit95 Forms 2 04-17-2001 09:50 PM

All times are GMT -8. The time now is 04:57 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World