By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Start Job, Finish Job times...

P: n/a
I may be barking up the wrong tree here (maybe I can do all this in
Excel) but...

I have created an Excel sheet that lets me input job start and finish
times and the amount of work done within the jobs so that I can work
out "total work per hour" etc....it works very well but I have to
input the times and workload manually...

Now is there anyway Excel or Excel linked with Access can be used so
that for example, someone comes along and hits "start" at the start of
their job and "finish" at the end of it so that the times of these
button presses are recorded by the PC itself (and thus using Excel
it'll work out total job time etc)?

I am a novice at Access but I'm willing to spend time to do this...I
just want to know if it will be possible...

Basially I just want a nic frontend with start job and finish job on
it with corresponding buttons....

Any Help would be appreciated!

--
The Zero ST
Feb 23 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Craig

That would be very easy to do.

Create a table with fields like StartTime, EndTime, JobNumber. Create a
form based on that table. Add two buttons (Start and Stop). Fill in the
JobNumber control. On the on-click event of the start button, assign the
current time to the StartTime control. On the on-click event of the stop
button assign the then current time to the StopTime control. Hit enter and
the record is added to the database table.

To get the time devoted to a job run a query to get stopTime - StartTime by
JobNumber.

Craig Coope" <co*******@hotmail.comwrote in message
news:4f********************************@4ax.com...
>I may be barking up the wrong tree here (maybe I can do all this in
Excel) but...

I have created an Excel sheet that lets me input job start and finish
times and the amount of work done within the jobs so that I can work
out "total work per hour" etc....it works very well but I have to
input the times and workload manually...

Now is there anyway Excel or Excel linked with Access can be used so
that for example, someone comes along and hits "start" at the start of
their job and "finish" at the end of it so that the times of these
button presses are recorded by the PC itself (and thus using Excel
it'll work out total job time etc)?

I am a novice at Access but I'm willing to spend time to do this...I
just want to know if it will be possible...

Basially I just want a nic frontend with start job and finish job on
it with corresponding buttons....

Any Help would be appreciated!

--
The Zero ST

Feb 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.