I'm still pretty new to Access and I'm building my first database that will be used by multiple users. I've got normalized tables and all the forms for the end users to input/edit data but now I need to extract that data in meaningful ways and am having some trouble.
I need to get records from a parameterized query into MS word in a specific format. I also need to get data from one record to fill out a company template form. In general, what is the best way for moving data from Access to MS Word? By best I mean least prone to error (user or otherwise) and able to produce consistent results.
What I've tried:
1. Exporting a report. The issue here is that the formatting looks nothing like it does in Access. Is there some trick here for getting a report to appear in Word the way it does in Access?
2. Mail Merge. Clunky and seems to be error prone. Also can't run with a parameterized query.
I have a *little* vba experience (~50 hours experience from 5 years ago in Excel) and I'm not against hunkering down and learning the VBA necessary to make this happen but if there is something simple that I am missing I'd like to know.
Thanks!