Adding a date field to db

[Rio Liaden]

Hi all!

My database allows all employees to enter their time and get a report at any time. The first screen has a calendar which is locked to the last day of the pay period and that date is the only one currently in place. The user selects his/her name from a dropdown, clicks the calendar, then "Next" to get to the time input screen. There are combo boxes to select the cost code, project, and company name. Separate boxes are available for the number of hours worked Sunday thru Saturday, and the employee can input their time for each day on separate lines, if they choose to. This allows them to have a separate line for regular time, vacation hours, hours worked in different projects, etc. Most of our employees are exempt, but the salaried ones are needing a mechanism to enter the date in each line for all of their hours. With this need in mind, I put in three combo boxes based on three tables: tblMonth, tblDay, and tblYear. Problem is, when I select January, as an example, from cboMonth, all of the available lines are populated with January. The same thing occurs with cboDay and cboYear. I really can't figure out where I have gone wrong and would appreciate any help.

Thanks in advance for whatever help anyone can render, and if you need to actually see the database, I will gladly send it.

Thanks!

Rio

[NeoPa]

I think copying and pasting the code you're actually using would be more useful - to make sure everything is there and in the right place etc.

[Rio Liaden]

This is the code:


Private Sub Calendar1_Click ()

WorkDate = Calendar1.Value

End Sub

[NeoPa]

I should be a dentist ;) (private joke - please ignore)
What is 'WorkDate' and where is it defined.

[Rio Liaden]

I should be a dentist ;) (private joke - please ignore)
What is 'WorkDate' and where is it defined.

Is that because I'm being a pain? My life's work and I'm good at my job! ;)Anyway, WorkDate is a text box, the receptacle for the date from Calendar1. There is no code associated except:

Private Sub WorkDate_Click( )

End Sub

Private Sub WorkDate_GotFoc us()

End Sub


Rio

[MSeda]

Question
In your Initial post you said you have multiple lines to enter employee time. On your form do the text boxes on each line link to the same "control source"?
i.e. do you have a Monday line with a date box with "Control Source" TblDate and the same for Tuesday etc.

[Rio Liaden]

Question
In your Initial post you said you have multiple lines to enter employee time. On your form do the text boxes on each line link to the same "control source"?
i.e. do you have a Monday line with a date box with "Control Source" TblDate and the same for Tuesday etc.

Yes. Each line will enter that day's date, and as I said in the last post, I changed it from tblDay, tblMonth, and tblYear to a calendar on the form. A text box on each of the lines will populate with the date when you click on the calendar date. The problem is, that particular date will populate on each line, and as the date for each new line is inserted, the new, changed date then populates each line, i.e. click on the calendar for Monday, Nov. 6. and that date would be put in the text box on the first line. The next day, Nov. 7 click on the calendar and Nov. 7 would be would be put in the text box on that line and also in the text box for the previous line, replacing Nov. 6.

Thanks for your help!

[MSeda]

If multiple text boxes on your form have the same control source that would cause what you described. A single form only shows one record at a time therefore regardless of the fact that you have multiple textboxes they are all looking at the same feild and record so when calendar or combos update one they all change. send me a screen shot of the design view of your form with a description of the underlying tables, I may be able to make a suggestion.

[NeoPa]

Is that because I'm being a pain? My life's work and I'm good at my job! Anyway, ...

I like to see someone with pride in their accomplishments ;)
If the WorkDate control is a TextBox, then I'm confused.
I'm not a great expert on working with forms and all that, but I would have expected that to work on the current record only (as obviously you did).

BTW if your code is exactly as posted, then you have some empty event procedures in there. They can safely be deleted. They are entered automatically by Access as a type of template for code when you select them. Sometimes you just select them to look and don't want to add code. In that case the empty shells are redundant.

Sorry I couldn't be more help.

[Rio Liaden]

If multiple text boxes on your form have the same control source that would cause what you described. A single form only shows one record at a time therefore regardless of the fact that you have multiple textboxes they are all looking at the same feild and record so when calendar or combos update one they all change. send me a screen shot of the design view of your form with a description of the underlying tables, I may be able to make a suggestion.

Here it is...[IMG]C:\Documents and Settings\blee\D esktop\Screen shot.doc[/IMG]

[MSeda]

That didn't display you can e-mail if you like.