Attendance Tracking

Hi Experts!

I am beginner in MS Access and i am trying to develop an attendance tracking for my office. But i am not able to complete the project due to lack of my experience. Could anyone help me in this regards to accomplish my vision.

I have attached necessary files for better understanding.

What i need:
:banghead:

When a student select his name lets say Andrew (9900023) he should be able to select and opt a combo box that contain the type of attendance field ie. "AttAbbre" from the "Attendance Table". Suppose if he is present he will be selecting "P" and the in the specific cell it should show the abbreviation along with the color code. Presently this is asking the user to append an entry. But it should prompt the user to select the abbreviation and after that it can append the data.

I have attached the Access file and some screen shots too..

Please help me to fix this!
Best Regards
PC

cross posted http://www.utteraccess.com/forum/index.php?showtopic=2038146&hl=

Please see how to cross post and why

Sorry for the cross posting.

Well i have done the process with some other method. But i am not able to delete the entry once it is done by clicking delete option on the "frmInputBox" which is appearing on the main calendar form. Could anyone look in to this

very nice but the delete appears to work for me. i would suggest that you make the input form modal so as to not bury it inadvertently behind the calendar form.

try this maybe this will help, try deleting entry.

Paul,

Some nice code. Lots of comments in the modules/procedures.
The calendar form, as moke mentioned, seems to take up too much screen real estate and hides the input form.

Perhaps you could adjust the size of the calendar form??? Do the individual Day representations have to be as big as they are?? It also seems a little busy, but with some training I'm sure users will learn how to use the form.

Perhaps you could use tempvars and some control on the calendar or another form to maintain control of program flow without changing the calendar size???

I would have expected a table of LeaveTypes, eg vacation, sick, jury duty.... for ease of maintenance.
Instead of a report for each leave type, perhaps a common report with option to pick the type(s) of leave..

Anyway, good stuff. Good luck with your project.

Thank you all..

Arnel its fine now. Thanks a ton!! i have i more issue with the replacement of legends. For some cells its fine but for some If i am choosing another legend in the same cell, then the system is notifying a duplication error. Could you please look in to this if possible.