Search results

Thanks it worked!!! I passed the query (qry_append_lastRev) Criteria like this: [Forms]![frm_quote]![frm_quote_revs].[Form]![txtRevID] Where [txtRevID] is pulling only the details needed. Then Append it in vba like this: DoCmd.OpenQuery "qry_append_lastRev", acViewNormal, acAdd The new...

I have tried your method, but can’t seem to get it to work, Attached is a 2 sample databases (temp2002-03 and temp2007).zip On the form, there is a button to create a new quote revision. What is the vba way to clone all the detail records into a new revision detail records? The reason is...

Thanks for the info, I will try your method, I've known this forum for years, but i forgot my username and password, it had been too long. It is indeed one of the best for smart access answers... Thanks,

Attached is a picture of what the form looks like. - FormA – The Quote - SubformX (inside FormA) - Quote Revisions Letter - SubformY (inside SubformX) - The details When creating a new record in SubformX (going to a new rev letter) I would like to copy/paste the details of SubformY into the...

Namliam, Thanks for the reply, Your approach is logic, However, attached is the structure of the relationships that I intend to use. I need a command done with in VBA to capture the last recordset and paste it into the new (empty) recordset. In this case, the tbl_type1 contains all the...

I am building a custom quoting system. 1 Quote can have multiple Revisions. 1 Revision can have multiple items. Example: Quote 12345 Rev A Item1 - $1.00 Item2 - $2.00 Item3 - $1.50 then, some changes can (does) occur, new items can be inserted, and price can change, therefore a Rev B is...