RunningSum or Dsum???

[emc_cos]

So I am relatively new to Access so please bare with me...
I have been able to create a very functional form that will be utilized
for time entry for tasks.

The primary form is a record entry type that has a unique file number
for each entry.

At the bottom of the form I have a set of control buttons that when
clicked ,will open a subform for time entry. Each subform has a text
box that will take numeric values for hours and minutes. At close, the
values that the user enters for minutes and hours are put into the
table ,and the current date is added to the table that signifies the
recent entry date.

I would like to be able to allow the user to enter a new value in these
subforms upon re-opening, for hours and minutes, and thus 'adding' the
existing and the new value together to provide a new total in the
table.

This is what I would like to do:

Ex:

Data_Entry_Hours has a current value of 1 and current entry date

The table Data_Entry_Hours reflects 1

Subform is re-opened and a new value of 1 is put into the text box

Subform is closed and the table Data _Entry_Hours reflects 2,

and so on and so on.
At this point the text boxes are added to the form from the table so
they are merely an entry point. Do I have to have unbound text boxes
for the time values that will be added to the existing values in the
table ( on the fly calculations) or can I use a Dsum, Runningsum type
of expression.

I am confused as to the proper way to set this up.
This is actualy the last step in what has been a harrowing ordeal, and
any help is greatly appreciated.

Thanks in advance

EMC

[Edgar]

One way to accomplish this is to use an unbound textbox, let's call it
AddHrs. On your close button -OnClickEvent, you will add the value of
the AddHrs to the value of the Data_Entry_Hours:

Me.Data_Entry_Hours.value = Me.Data_Entry_Hours.value +
Me.AddHrs.value

I will let you take care of the housekeeping.

Happy coding!

Edgar J.

[Baz]

<em*****@msn.com> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...

So I am relatively new to Access so please bare with me...
I have been able to create a very functional form that will be utilized
for time entry for tasks.

The primary form is a record entry type that has a unique file number
for each entry.

At the bottom of the form I have a set of control buttons that when
clicked ,will open a subform for time entry. Each subform has a text
box that will take numeric values for hours and minutes. At close, the
values that the user enters for minutes and hours are put into the
table ,and the current date is added to the table that signifies the
recent entry date.

I would like to be able to allow the user to enter a new value in these
subforms upon re-opening, for hours and minutes, and thus 'adding' the
existing and the new value together to provide a new total in the
table.

This is what I would like to do:

Ex:

Data_Entry_Hours has a current value of 1 and current entry date

The table Data_Entry_Hours reflects 1

Subform is re-opened and a new value of 1 is put into the text box

Subform is closed and the table Data _Entry_Hours reflects 2,

and so on and so on.
At this point the text boxes are added to the form from the table so
they are merely an entry point. Do I have to have unbound text boxes
for the time values that will be added to the existing values in the
table ( on the fly calculations) or can I use a Dsum, Runningsum type
of expression.

I am confused as to the proper way to set this up.
This is actualy the last step in what has been a harrowing ordeal, and
any help is greatly appreciated.

Thanks in advance

EMC

Sounds to me that you've gone slightly wrong with your basic design. I
think you need two tables, one for the unique file numbers (if that's what
you are calling them) and one for each entered time. It would look
something like this:

Table 1
=====
unique_file_number

Table 2
=====
unique_file_number
entered_date
hours
minutes
So, Table 2 would have a new record added to it for each new time entry.
You could display it by creating a form in continuous form view and
including it as a subform of the main form. To display a total, put a text
box in the form's footer, and give it a control source something like this
(untested!):

=Sum([hours]) + Cint(Sum([minutes])/60) & ":" & Sum([minutes]) Mod 60