John,
This gives me a great start. I will work on adapting the code when my normal job gives me time.
I will let you know how it goes.
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Saturday, February 22, 2014 2:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] New Record
Bill-
It's possible, but you'll have to write some code. You would need a "Clone" button which would a) copy the main record to a new record with the dates update, then b) copy the related policy detail record, then c) move the form display to that record for correction.
Remember the code I gave you to "split" the original tables? Your Clone code would be similar - use .AddNew to start a new main record, copy the values but save the Autonumber key right after you "dirty" the record, then use that key to add a new record to the correct detail table. (In the earlier code, you simply updated the detail with the key you created.) Of course, you might need "n" separate detail bits of code, one for each type of policy.
Does that help get you started?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 22, 2014, at 1:38 AM, Bill Singer <Bill.Singer@at-group.net> wrote:
As I am rolling from year to year with my insurance information I would like to create a new record that pulls most of the information from the previous year.
I thought about an append query by I have split tables (one record consists of information on two tables) so I do not think I can do it.
I want to run the update from a form that is viewing the current record, click a button which will add a new record and populate most of the fields.
The data input lady will love me if I can get this done.
Thanks,
Bill
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar