Hello,
I am new to VBA programming - thank you for your help. I am using a form in Access 2007 to update my database. I use a submit button on the form to send all the values into Access. I want that button to do two additional things, open a pre-defined word document, import a few values into that word document in specific places. These values were entered into the Access form.
This is a for a school and we use Access to track teachers who are borrowing laptops and what equipment received with the laptop. The form uses 5 boolean yes/no checkboxes to identify sundry equipment but often times the teacher does not get all 5 pieces - it is therefore important to track exactly what the teacher did get as they are made financially responsible for missing items.
thanks!
I am new to VBA programming - thank you for your help. I am using a form in Access 2007 to update my database. I use a submit button on the form to send all the values into Access. I want that button to do two additional things, open a pre-defined word document, import a few values into that word document in specific places. These values were entered into the Access form.
This is a for a school and we use Access to track teachers who are borrowing laptops and what equipment received with the laptop. The form uses 5 boolean yes/no checkboxes to identify sundry equipment but often times the teacher does not get all 5 pieces - it is therefore important to track exactly what the teacher did get as they are made financially responsible for missing items.
thanks!