Recent content by jhumphrey79

I will be following this closely as I have the same need to import data into an Access table which data is in a Word doc.

I'm trying to send: -CLientFirst and ClientLast (from Contacts main form), -ChargeDate (from ClientCases subForm), and -CaseNumbers (from subsubForm ClientCharges) to the label template.

THe GENERAL tab is all part of the Forms![Contact Details] (the main form). Click on the CASES tab. That page is a ClientCases subform. Expanding the ClientCases datasheet shows a DynamicSubform. The default view is the ClientCharges subsubform. With the datasheet expanded, if you click...

I love it. Leave it to a lawyer to confuse any issue with words. THank you, Rain. And take the copper pennies over a check anyday.

The Me.RecordsetClone loopes endlessly through the fields on the main form. Until I employed the DynamicSubform, all was well. Thanks for your help and I'll keep digging.

I do. I typed in a long question twice today and each time I tried to post it, it vanished. I have a MainForm, essentially stolen from [Contacts Extended] in the Northwind model, the first page of which holds the clients' contact info. The second page holds SubForm1, which is a datasheet of...

Got a solo law office and find vba more addictive than my clients find crack. Am developing application to ease all manner of client info, document generation and saving, calendaring and syncing with Google calendar. And I have no idea what "polls" (except after an unfavorable jury verdict)...