Button last called

[Guest]

Have a form I would like to add a last talked to button, this button would be
used to show the operator the last time (time not date)they called a
technician. The information doesn’t need to be saved, if that helps.

 

[Al Campagna]

Robert,
You don't need a button for that. You can just place a calculated unbound text control
on the form that displays the DMax date and time from your Calls table. (or wherever you
have that data stored)
Use the operator key field to define which operator Call time to return.
basic example... customize to suit your needs
=DMax("[CallDateTime]","tblCalls", "OperatorID = " & OperatorID)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Al,
can you give me a little more guidance. I’m just not getting this to work. I
guess I need more detail thanks.

Robert,
You don't need a button for that. You can just place a calculated unbound text control
on the form that displays the DMax date and time from your Calls table. (or wherever you
have that data stored)
Use the operator key field to define which operator Call time to return.
basic example... customize to suit your needs
=DMax("[CallDateTime]","tblCalls", "OperatorID = " & OperatorID)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Have a form I would like to add a last talked to button, this button would be
used to show the operator the last time (time not date)they called a
technician. The information doesn't need to be saved, if that helps.

 

[Al Campagna]

Robert,
My code is just an example. You'll need to customize the DMax function to suit your
table design.

Tell me about the table where you keep track of who called and when. Describe the
important fields.
In other words, in that table, how would you "manually" locate that information you
need.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Al,
can you give me a little more guidance. I'm just not getting this to work. I
guess I need more detail thanks.

Robert,
You don't need a button for that. You can just place a calculated unbound text
control
on the form that displays the DMax date and time from your Calls table. (or wherever
you
have that data stored)
Use the operator key field to define which operator Call time to return.
basic example... customize to suit your needs
=DMax("[CallDateTime]","tblCalls", "OperatorID = " & OperatorID)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Have a form I would like to add a last talked to button, this button would be
used to show the operator the last time (time not date)they called a
technician. The information doesn't need to be saved, if that helps.