Search results

The linked master field on the main form is [Ref]. The Linked Child field on the subform [TLinks_subform] is [ARef]. These allow the records to be associated. The actual subform (table) field I am interested in is [Link] as seen above.

Thanks Ranman256. The report is built and works for the parent form. The data is linked in terms of the underlying query and records for the main form. I don't know how to append one of the existing report's fields from the subform recordset. Can I modify my existing code to achieve this...

Hello all, This relates to a previous SOLVED post of mine and the use of a Form to show records based on an Action Table (previous post discussed email attachments). The form (FActions) also has a subform (TLinks_subform) shown which allows Users to record references (record numbers) for...

Nice touch Mark ! May have a play with this. Thanks Flint2048

Thanks very much Minty. Everyday is a school day. Cheers

Solved it !!! Spotted Typo in original code "RecorsetClone" ( I read this lots of times and missed it) Modified code also includes wildcard to attach multiple file types (not just PDF). Code now reads: ' Add attachments for each any every linked file Dim rs As DAO.Recordset Dim strFile...

Hi. I am trying the code above but am getting a runtime error 2465 "Application defined or Object defined error" in the following line... Set rs = [TLinks_subform].Form.RecorsetClone I have also tried... Set rs = Forms![FActions]![TLinks_subform].Form.RecordsetClone Same result.

Of course !! ( I forget how helpful Access is at doing some of the hard work for you). I'll give this a go today and let you know how it goes. Thanks for your time.

Thanks very much for the replies. The suggested VB looks like a great start but there is one modification required I think. Not all the items in the subform / recordset should be attached. Only those where TLinks [ARef] matches the current Action Record on the main form (FActions). (This is...

Many thanks Paul.

Hello, Can anyone help with this at all... I have a Form (FActions) that shows a record from a table (TActions). The form also shows a subform (TLinks_subform) that relates to a "linked files" table (TLinks). The User can associate reports (TReport) with the Action record (one to many) by...

Hi, I'm new to the forum. I've been using Access for a number of years and have several successful systems in use. I am not however a programmer in that I am able to make use of / tweak existing VB code but lack the knowledge and (in many respects) the time to develop writing my own VB...