Updating list every month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of monthly pension contributions by our staff. Each line
consists of the employee's unique number, the month in question (mm/yy) and
the amount.
These amounts do not change from one month to the next normally.
Instead of typing in the same amount every month, I would like to be able to
use the previous month's amount as the default, with the option to change it.
The information is currently displayed in a master form showing the month to
display and a subform showing amounts for that month (linked on the month in
the master form)
ANy assistance with this woudl be appreciated. I am reasonably good with
code, but out of practice, so have forgotten how to do most things.

THanks!
 
Had you considered a separate table consisting of the "regular month
amounts?

You would only require two columns --- the employee number and the regular
monthly amount. This would be a table you could edit with an Access form
bound to this new table.

On a monthly basis, you would then require a program to append the entire
contents of that table to the "main" table simultaneously adding the "mm/yy"
column to the added data. I think this could be performed with an Access
form bound to the "main form" and quite possible performed entirely by SQL
once you have prompted the user for the appropriate date. I'm not "SQL
heavy" but I've seen it able to do lots of stuff.

If an SQL-only approach didn't work, you could simply reference the
secondary table within the VBA code, put out a row at a time, and add a
record to the main table using the data from the secondary table and the
date.

Bob (@Martureo.Org)
 
Excellent Solution, Bob

Bob Howard said:
Had you considered a separate table consisting of the "regular month
amounts?

You would only require two columns --- the employee number and the regular
monthly amount. This would be a table you could edit with an Access form
bound to this new table.

On a monthly basis, you would then require a program to append the entire
contents of that table to the "main" table simultaneously adding the "mm/yy"
column to the added data. I think this could be performed with an Access
form bound to the "main form" and quite possible performed entirely by SQL
once you have prompted the user for the appropriate date. I'm not "SQL
heavy" but I've seen it able to do lots of stuff.

If an SQL-only approach didn't work, you could simply reference the
secondary table within the VBA code, put out a row at a time, and add a
record to the main table using the data from the secondary table and the
date.

Bob (@Martureo.Org)
Click to expand...
 
Back
Top