Copy a part row of a table.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

My double-entry general ledger needs me to re-enter the line twice, but I
want to automate this.

Copy and paste of the whole line (record) will not work because of ID
conflicts, so it will be necessary to copy/paste just the line fields
without ID fields.

Can someone point me in the right direction on how to do this, that is to
copy/paste just selected fields of a record from a datasheet.

Regards,Frank
 
Frank,
If it's possible to make the ID field an Autonumber, then
you shouldn't have any problems as Access will re-assign
the number itself.
It sounds like you can't have duplicates in the ID field
anyway, so you may want to write a query that appends the
record to the table, but assigns a number one higher than
the ID.
Example
NewID: [ID]+1

or

NewID: [ID] & "A"

It depends on the data type of the field in your table as
to which of these you can use.

Hope this helps.
Dave
 
Back
Top