Timestamp

"Tony Toews [MVP]" wrote:

Visit www.courts.gov.wa

I screwed that one up. http://www.courts.wa.gov

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Arron,
I hope you never reply to any of my posts, I will ignore them. For someone
trying to help, you are very condescending and immature with your responses.
This is not a debate forum, this is a "help forum" where those who are more
knowledgeble HELP those who are less knowledgeable...not to post
unprofessional banter saying who's better and who's not... and who's a
"jerkoff".

If I see anymore of this, I will report you. In meantime, be helpful, not a
nuisance.

"a a r o n . k e m p f @ g m a i l . c o" wrote:

I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.
I would like the Time_In to populate automatically when the form
opens.

On Apr 17, 4:44 am, "BruceM" wrote:
Actually, it was "when the form opens", which really cannot be taken as a
specific question about the form's Open event. In any case, the Open event
is too soon to be writing to a record.
BTW, emoticons have their place, but a representation of a wink does not
mitigate ugly jabs at people.

"a a r o n . k e m p f @ g m a i l . c o m" wrote in
...
Equally interesting... is that the poster is asking for FORM_OPEN not
FORM_CURRENT

kinda funny that nobody caught that either

I'll try to stay on topic.

But I will not put up with organized, perpetual calpaign of
misinformation about SQL Server.
It's like these jerk-offs all get paid for Larry Ellison or
something.. Either that or they're just sleeping with Larry.

-Aaron

On Apr 16, 10:12 pm, "George" wrote:



Interestingly enough, the Current event is a fom level event, not a
control
level event, so it fires once, on each current record, not on 40 different
controls on a form. Therefore, writing it ONCE in the form's Current event
is all that is required.

Equally interesting is that the poster only mentions a single control (the
TimeOut field) , not 40 different controls on a form.

Of course, it is also true that your answer could have been relavant to a
question about time stamps in SQL Server tables or to triggers, had either
of those been the actual question presented.

Please try to focus. It's not that hard to do. If you do want to have a
positive infleunce on others, you need to be able to project a coherent,
cogent presence.

"a a r o n . k e m p f @ g m a i l . c o m" wrote
in
...
SQL Server and mySql has native timestamps. Access doesnt' support
this functionality; because Access isn't a real database.

Furthermore, you could do anyhting like this-- that you wanted to do--
with a trigger.

I just don't think that writing the same piece of code in 40 different
text boxes-- I just don't think that sounds like fun.

-Aaron

On Apr 16, 12:46 pm, Beeyen wrote:

Good Day All,

For the purpose of tracking changing in the my form I have added a
timestamp
with fields called Time_In and Time_Out (where Time Out should populate
when
the status drop-down is completed) I would like the Time_In to populate
automatically when the form opens. Could someone share coding as to how
best
to accomplish this?

Thanks- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -