To use addnew to add one or more records

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

Guest

Hi,
I need to design a form. Right now, there is a quarterexpense table and a
master table. The idea is to create a functionality in the form that would
append one or more records (according to choice from check box) from the
quarterexpense to the master table. I was wondering if there is any article,
knowledge base that would give me some idea as to programmatically handle
append method with multiple records. I appreciate any help. Thanks.
 
Jack

From your description, it sounds like you have a data structure that
requires the same data in more than one table. This is redundant, and may
lead to synchronization/data integrity issues.

From the names of your tables ("quarterexpense", "master"), I infer that you
are recording expense data, and wish to "group" it (by quarter, by ???).
You don't need separate tables to do that -- in fact, you'll only make it
harder for Access and yourself if you create separate (but identical) table
structures and embed data facts (i.e., identification of time period - e.g.
"quarter") in the table name.

If you provide more information about your design, the 'group's readers may
be able to offer alternate approaches...
 
Thanks for your insight Jeff. I appreciate it. Actually, I already have the
data structure in place. The Quarter table would be used as a part of the web
application to capture Quarterly financial data and then this need to be
appended to a master table on a quarterly basis. The way I designed the form
is to have a combo box with ALL or one of the selected record. Then the
command button 'TransferRecord' will transfer ALL or the selected record to
the master table ie. issue an append method. I can do it with append query.
However, I was wondering if I could programatically do it with addnew
especially for all the records using a loop. That's where I am looking for
some kb or help. I have not done access programming all to much. Hope I have
clearly stated my plan. Thanks. Regards.
 
Jack

If you've already decided on your data structure as described, you'll have
to work around how Access normally handles your situation. I wasn't telling
you that you HAD to change it, just informing that doing it your way comes
at an additional cost in your time/effort.
 
Back
Top