Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #9008

Re: time check

From "Access Developer" <accdevel@gmail.com>
Newsgroups comp.databases.ms-access
Subject Re: time check
Date 2014-02-12 13:55 -0600
Message-ID <bm332pF98fuU1@mid.individual.net> (permalink)
References <90186cc8-291b-48de-9c4e-d6be8740077c@googlegroups.com>

Show all headers | View raw


Copied directly from the Immediate Window, Access 2003

? Time()
1:46:54 PM

If Time() > 1900 Then ? Time() Else ? "Nope"
Nope
If Time() < 1900 Then ? Time() Else ? "Nope"
1:53:51 PM


-- 
Larry Linson
  Microsoft Office Access MVP
  Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"bobh" <vulcaned@yahoo.com> wrote in message 
news:90186cc8-291b-48de-9c4e-d6be8740077c@googlegroups.com...
> Hi All,
>
> I must be tired cause I can't figure out the vba to determine if the 
> current time is greater then 7pm
>
> If Time() > 7pm Then  <-- is what I'm trying to get to
>
> help and thanks
> bobh. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

time check bobh <vulcaned@yahoo.com> - 2014-02-12 11:08 -0800
  Re: time check Bob Quintal <rquintal@sPAmpatico.ca> - 2014-02-12 21:27 +0000
    Re: time check Ron Weiner <rw@domain.com> - 2014-02-12 16:40 -0500
      Re: time check Bob Quintal <rquintal@sPAmpatico.ca> - 2014-02-12 23:45 +0000
  Re: time check "Access Developer" <accdevel@gmail.com> - 2014-02-12 13:55 -0600

csiph-web