C
Cody Kiroff
This might not be possible. I have some experience coding (mostly C and
C++). I have been acquiring the basics of access vba through picking off
forums, but I am by no means familiar. I think this might be a challenge,
even to you access gurus.
Background: I work in an environment where people are afraid of anything
that is not a microsoft word setting. Our IT dept has office 2003 suite.
The people using my database have no programming experience and even have
problems manipulating simple tables in word.
The Problem: I have a form that inputs into multiple tables. The form has 3
subforms in a tabular setup. One of the subforms consists of checkboxes that
upon entry prompt the user for more input. One of the subforms is simply a
connection to table. The final subform has two other subforms embedded.
The Solution: I am looking for a way to automate this system. I want the
user to have a button that says print record. This button will then export
the entire form, with said subforms into a report. I want this because the
subforms are dynamically populated and I want them viewed as a datasheet. I
then want this button to simultaneously execute an export of all the data to
their "comfortable" word environment.
Please help. Thank you.
C++). I have been acquiring the basics of access vba through picking off
forums, but I am by no means familiar. I think this might be a challenge,
even to you access gurus.
Background: I work in an environment where people are afraid of anything
that is not a microsoft word setting. Our IT dept has office 2003 suite.
The people using my database have no programming experience and even have
problems manipulating simple tables in word.
The Problem: I have a form that inputs into multiple tables. The form has 3
subforms in a tabular setup. One of the subforms consists of checkboxes that
upon entry prompt the user for more input. One of the subforms is simply a
connection to table. The final subform has two other subforms embedded.
The Solution: I am looking for a way to automate this system. I want the
user to have a button that says print record. This button will then export
the entire form, with said subforms into a report. I want this because the
subforms are dynamically populated and I want them viewed as a datasheet. I
then want this button to simultaneously execute an export of all the data to
their "comfortable" word environment.
Please help. Thank you.