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

[Rio Liaden]

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

Hopefully you have received the screen shots. Ignore the comment box that says the calendar is informational. I want it to be functional.

[NeoPa]

Some links don't work when first posted (many web links for instance).
I get around it by editing post immediately and saving with the 'Automatically parse links in text' option set.

[Rio Liaden]

Some links don't work when first posted (many web links for instance).
I get around it by editing post immediately and saving with the 'Automatically parse links in text' option set.

Thanks! I actually tried that but my shots were too large even after I zipped them. Is that common?

[MSeda]

Just to describe the form for others:
the form view is set to continuous forms so a user can enter multiple records into the time sheet. there is a calendar control in the form footer whose on click sets the work_date textbox in the detail section.

My previous comment of having multiple textboxes applied to a single form view. you have a continuous form view. The work_date text box is currently unbound.
so when calendar changes the date all work_dates in the detail section change since there is nothing to hold the value.
Once you set work_dates "control source" property to the field you want to store the date in, this will stop and the calendar will only reset the current records date.

[NeoPa]

I thought I saw star quality.
MSeda - a credit to these forums.

[Rio Liaden]

Just to describe the form for others:
the form view is set to continuous forms so a user can enter multiple records into the time sheet. there is a calendar control in the form footer whose on click sets the work_date textbox in the detail section.

My previous comment of having multiple textboxes applied to a single form view. you have a continuous form view. The work_date text box is currently unbound.
so when calendar changes the date all work_dates in the detail section change since there is nothing to hold the value.
Once you set work_dates "control source" property to the field you want to store the date in, this will stop and the calendar will only reset the current records date.

What is the WorkDate control source? I sort of understand, but I need to bind the text box to the control source and I'm not sure what the control source is. It is the calendar but I'm a bit confused.

[MSeda]

The Control Source is the field in the underlying table where the data is stored.
i.e. when you have a combo box named Task ID on your form when a user selects a task it saves there selection in the task ID column of the underlying table. if you open the properties menu for the task ID combo box on the data tab you will see "control source" says "task ID".
The Work Date text box on the form you sent me reads "Unbound" meaning it is not set to save the data anywhere. open the properties window for work date and set the control source to the appropriate feild in your table. you will find Control Source has a drop down list of all feilds in the source table or query. If you don't already have a date feild in the table you need to create one with a date/time data type before you can do this.

[Rio Liaden]

The Control Source is the field in the underlying table where the data is stored.
i.e. when you have a combo box named Task ID on your form when a user selects a task it saves there selection in the task ID column of the underlying table. if you open the properties menu for the task ID combo box on the data tab you will see "control source" says "task ID".
The Work Date text box on the form you sent me reads "Unbound" meaning it is not set to save the data anywhere. open the properties window for work date and set the control source to the appropriate feild in your table. you will find Control Source has a drop down list of all feilds in the source table or query. If you don't already have a date feild in the table you need to create one with a date/time data type before you can do this.

You know, MSeda, you are a credit to this forum. I needed a memory jog and you gave it to me. I have been so frustrated with other aspects of my job that I could not think. I have built many databases from scratch but unfortunately, I inherited this one. I did not go back to basics and therefore, sounded like an idiot on this forum. Forgive me. I did as you instructed, put in a WorkDate field (duh!) bound it and my form is doing exactly what I needed.

Thank you so much again and when my head settles back on my shoulders, believe it or not, I may one day be able to help you! Definetely not as much as you helped me, but hopefully a fraction!

Rio