Short time vs short date
- From: "RobUCSD via AccessMonster.com" <u34500@uwe>
- Date: Fri, 08 Jun 2007 17:10:01 GMT
In my form I have a fldOutOfRoom which the user inputs a short time into the
field, i.e, 0900.
I have the following code in the open event of another form called frmRNnotes:
If DateDiff("h", Forms!frmPtDemographicNew!frmVisitNewEdit.Form!OutOfRoom,
Now) >= 1 Then
Me.cmdRNnotesEdit.Visible = False
This code gives the RN one hour to complete a note and then he/she can no
longer edit the note.
What I want to know is the Short Time format going to let the cmdRNnotesEdit
button be visible everyday within one hour of the of the original time? That
is, is the short time just a time or does it also know the date that the time
was entered? Or do I need to use a short date format for this field?
Hope that's clear, thanks Rob
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200706/1
.
- Follow-Ups:
- Re: Short time vs short date
- From: Douglas J. Steele
- Re: Short time vs short date
- Prev by Date: Re: Dynamic Sub Form Record Source
- Next by Date: Re: Dynamic Sub Form Record Source
- Previous by thread: Setting values into a table using the PK of the just created record
- Next by thread: Re: Short time vs short date
- Index(es):