diane

[diloft]

looked at other threads for assistance. they either confused me or did not help. have 2010access db. what to attach or link PDF sign in sheet to a table when user saves form, also email pdf, all with VBA. can get attachment to work if bound to table and use access controls but not with VBA. form data will save to one table and some of the fields plus attachment will save to another. any advice on how to do it with VBA?

 

[EternalMyrtle]

looked at other threads for assistance. they either confused me or did not help.

Your thread is confusing me!

Perhaps try rephrasing asking one question at a time. Also using a more descriptive title would help (what is "diane" supposed to mean)?

 

[diloft]

Re: attaching file to table using VBA

Sorry for the confusion. was entering the thread on my tablet.

have an access 2010 db that uses forms for data entry. i want the user to fill out a form and attach a sign in sheet to a table. all the data and the attachment will be written to a table when the Save button is clicked. the data will save to one table. some of the data plus the attachment will save to another table. I can follow the Windows Access instructions for using the Attachment data type bound to a form field, but I cannot figure out how to use VBA to save the form data to various tables. ie; you use .value to add textbox data to a table vield. What property do you use with Attachment fields?

Hope this explained my questions better.