Access Database

[Guest]

I have created a database to monitor absentism in our office and I am working
with a from that updates my histroy table...When I enter the time requested
by an employee sometime it is for only part of the day, therefore I would
like to double click on the field - have a calculator appear - perform the
calculation - and have the result entered in the field when I hit the equal
sign?

Can this be done?

 

[John Vinson]

I have created a database to monitor absentism in our office and I am working
with a from that updates my histroy table...When I enter the time requested
by an employee sometime it is for only part of the day, therefore I would
like to double click on the field - have a calculator appear - perform the
calculation - and have the result entered in the field when I hit the equal
sign?

Can this be done?

Well, it may not be necessary to pop up a calculator at all. There is
a built-in function named DateDiff() which can calculate time
differences (in seconds, minutes, or hours) automatically. Just what
calculation are you trying to do? It's certainly possible to have VBA
do a calculation for you; actually popping up the Windows Calculator
might be possible (I don't know how offhand) but may be overkill for
what you need, as well as being more difficult than just storing the
time off directly.

John W. Vinson[MVP]