Re: Calculating separate date and time fields
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
bupton wrote:
I have to track them separately based on the actual date and time
that an e-mail has been received. Since the date and time is not the
same as the db entry it has to be separate. Same with the response,
the db entry may occur hours after the actual time the e-mail was
responded to.
So you have one DateTime field for when the record was created (if you need
that) and another DateTime field that holds the date AND time that the Email was
received.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
Relevant Pages
- Re: combo box - warning if new data entered (not in list)
... from the list (does this mean you've set the LimitToList property to "No"?). ... trigger when the entry is not in the list. ... Response As Integer) ... Response = acDataErrContinue ...
(microsoft.public.access.formscoding) - RE: ComboBox - changing entry
... 'Present a message box to ask the user if they want to add the new entry to ... Set rst = Me.RecordsetClone ... 'This is the response constant you use when you add a new record. ... combo does the same thing except it only requeries its own row source query. ...
(microsoft.public.access.forms) - Re: How to write a new entry in a combo box to its underlying table
... I have a assets database. ... then write it to the underlying Manufacturers table. ... add that new entry to the list. ... Response = acDataErrAdded ...
(microsoft.public.access.modulesdaovba) - RE: ComboBox - changing entry
... 'Present a message box to ask the user if they want to add the new entry to ... Set rst = Me.RecordsetClone ... 'This is the response constant you use when you add a new record. ... combo does the same thing except it only requeries its own row source query. ...
(microsoft.public.access.forms) - Re: Multiple Level Index
... puts a separate line for each Reports Switchboard. ... Field codes: XE (Index Entry) field ... do not use hidden text formatting to keep sensitive ...
(microsoft.public.word.pagelayout) |
|
