time serial question

[Guest]

hi - could someone please tell me how to make this time stamp, store the
value in my table? Is this just a calculation? It's only working my from
OpenedTime field. I want it to store the info in ExpectedResponseTime.. How
do I make it store in the ExpectedResponseTime field?

=TimeSerial(Hour([OpenedTime])+1,Minute([OpenedTime]),Second([OpenedTime]))

Thanks for any advice.
Tammy

 

[Douglas J. Steele]

Why? As in why do you need to store if it it's always one hour greater than
[OpenedTime]?

Simply create a query with a computed field in it, and use the query
wherever you would otherwise have used the table.

For what it's worth, you can get by with simply DateAdd("h", 1,
[OpenedTime]), thus saving a few function calls.

 

[Guest]

See:

http://www.microsoft.com/office/com...cess&mid=2c896f28-285f-4481-8429-c603a2faf86e


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

could you tell me how to solve my problem? I need an ExpectedResponseTime 1
hour greater than OpenedTime ??
thanks, Tammy

See:

http://www.microsoft.com/office/com...cess&mid=2c896f28-285f-4481-8429-c603a2faf86e


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

hi - could someone please tell me how to make this time stamp, store the
value in my table? Is this just a calculation? It's only working my from
OpenedTime field. I want it to store the info in ExpectedResponseTime.. How
do I make it store in the ExpectedResponseTime field?

=TimeSerial(Hour([OpenedTime])+1,Minute([OpenedTime]),Second([OpenedTime]))

Thanks for any advice.
Tammy

 

[John Vinson]

could you tell me how to solve my problem? I need an ExpectedResponseTime 1
hour greater than OpenedTime ??

They did. Did you read their answers?

create a Query based on your table.
In a vacant Field cell in the query type

ExpectedResponseTime: DateAdd("h", 1, [OpenedTime])

Use this Query as the source for a form, report, export, etc.

Unless there's some issue that you haven't told us, there is *no* need
or justification for storing ExpectedResponseTime in the Table.

John W. Vinson[MVP]

 

[Guest]

Hi Tammy,

Use the DateAdd function in the control source for the ExpectedResponseTime
textbox, ie:

=DateAdd("h",1,[OpenedTime])

The point is that you should not attempt to store the results of this
calculation in your table. Calculate it on-the-fly, as needed, in a query, or
in the control source for a textbox on a form or report.

Here are some references that you might want to bookmark:

http://office.microsoft.com/en-us/assistance/HA010546621033.aspx

http://support.microsoft.com/?id=210276


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Tom - I added the code you said too, in the text box, but how do i make it
store in my table? The field name is different from the label name. Does
that make sense?

I typed it like this ExpRespMilTimes=DateAdd("h",1,[OpenedTime]) - with
ExpRespMilTimes being the field I want it stored in but it didn't work. If I
just type in a text box control property =DateAdd("h",1,[OpenedTime]) it
doesn't store anywhere.

Hi Tammy,

Use the DateAdd function in the control source for the ExpectedResponseTime
textbox, ie:

=DateAdd("h",1,[OpenedTime])

The point is that you should not attempt to store the results of this
calculation in your table. Calculate it on-the-fly, as needed, in a query, or
in the control source for a textbox on a form or report.

Here are some references that you might want to bookmark:

http://office.microsoft.com/en-us/assistance/HA010546621033.aspx

http://support.microsoft.com/?id=210276


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

could you tell me how to solve my problem? I need an ExpectedResponseTime 1
hour greater than OpenedTime ??
thanks, Tammy

 

[Guest]

Hi Tammy,

If I just type in a text box control property =DateAdd("h",1,[OpenedTime])
it doesn't store anywhere.

That's what I've been saying all along. You should not be attempting to
store the results of any calculation. Did you read my initial answer to your
second posting?

http://www.microsoft.com/office/com...cess&mid=929ef864-5f74-4828-ab2a-8baa74d36e14


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Tom - I added the code you said too, in the text box, but how do i make it
store in my table? The field name is different from the label name. Does
that make sense?

I typed it like this ExpRespMilTimes=DateAdd("h",1,[OpenedTime]) - with
ExpRespMilTimes being the field I want it stored in but it didn't work. If I
just type in a text box control property =DateAdd("h",1,[OpenedTime]) it
doesn't store anywhere.