access database and c# form-adding data

[johnnysmith1]

I have a C# form users use to enter hours worked, sick time , vacation. It is connected to access 2003 database. The form does not have a login- each person just selects last name from combo box and any secure data is not visible on form. is there a way I can display a current number of vacation hours, sick time left each week on form for each person. I recieved an excel sheet with total number of vacation hours and sick hours each user has for this year at present. When someone uses time it has to calculated and updated. I am uncertain of how of even how to start on this task. any ideas. I also have to have vacation time and sick time only available to user. no one else can view. thank you,

[Lost User]

You would force a user to select their name first and then query the data on the SelectedItemChanged event, same as you would select data from another data source on a different event, such as saving data on a button click ;)

Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]

[johnnysmith1]

thank you