Access ?

csgraves

Board Regular
Joined
Dec 9, 2002
Messages
106
Hi! Does anyone know if it would be possible to do the following:

Set up a access page on each employee computer so that they can use it as a time clock. If I set up a table with employee listing and they just find their name and enter the time in and times out, would it go to the database I created. If so, is there a way to embed a button to enter the correct time?

I am probably asking for a great deal or for something not possible.

If anyone could help, I would aprreciate it.

Thanks!

Scott
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

tails

Board Regular
Joined
Jan 30, 2005
Messages
130
Yeah there is, you can make it so it automatically puts in the date and time as soon as they open the form. This is pretty simply to do. When you open the form, right click on the text box you are using for the time and click properties.
Then got to the data tab and enter the Default Value as =Time()
that should work
do the same thing for the date text box except under Default Value, enter =Date()

I hope thats what you were looking for...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,630
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top