Copy data

C

Cobra

I have a form with a control to go to data sheet view to
enter specific amounts under specific dates. There is a
field for standard amount to be paid with a corresponding
id number with the column headings as dates. I want to be
able to copy the standard amounts to the next specific
date each time weekly entries are made, to save on
repetitive data entry, and only make changes as needed
for that specific date. I can do it using copy and
paste, but this is a bit "spreadsheet--ish's". Can i do
a macro or some other command?

Thanks for any help
 
M

Mike Painter

Cobra said:
I have a form with a control to go to data sheet view to
enter specific amounts under specific dates. There is a
field for standard amount to be paid with a corresponding
id number with the column headings as dates. I want to be
able to copy the standard amounts to the next specific
date each time weekly entries are made, to save on
repetitive data entry, and only make changes as needed
for that specific date. I can do it using copy and
paste, but this is a bit "spreadsheet--ish's". Can i do
a macro or some other command?

Thanks for any help
Click to expand...

It does sound like you are trying to use a database as a spreadsheet.
If you have more than one date and amount field per record your tables are
not properly designed.
What you want to do is easy if the tables are normalized and will require a
good bit of code if they are not.
These design problems will carry over into everything you do.
There is a *lot* of information in help about what a relational database is
and how it works.
 
Top