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

Groups > comp.databases.ms-access > #9002 > unrolled thread

time check

Back to article view | Back to comp.databases.ms-access

Contents

  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

#9002 — time check

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.

[toc] | [next] | [standalone]

#9003

bobh <vulcaned@yahoo.com> wrote in
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.
> 
if datepart("n",time()) >19

or, better

if datepart("n",now()) >19 Then
 
-- 
Bob Q.
PA is y I've altered my address.

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[toc] | [prev] | [next] | [standalone]

#9004

Bob Quintal expressed precisely :
> bobh <vulcaned@yahoo.com> wrote in
> 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.
>> 
> if datepart("n",time()) >19
>
> or, better
>
> if datepart("n",now()) >19 Then

Shouldb't that be:
Datepart("H", Now())

Rdub

[toc] | [prev] | [next] | [standalone]

#9006

Ron Weiner <rw@domain.com> wrote in news:ldgpoc$tdj$1@dont-email.me:

> Bob Quintal expressed precisely :
>> bobh <vulcaned@yahoo.com> wrote in
>> 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.
>>> 
>> if datepart("n",time()) >19
>>
>> or, better
>>
>> if datepart("n",now()) >19 Then
> 
> Shouldb't that be:
> Datepart("H", Now())
> 
> Rdub
> 

oops, n is minutes, h is hours. ....

-- 
Bob Q.
PA is y I've altered my address.

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[toc] | [prev] | [next] | [standalone]

#9008

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. 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web