Hi group,
I have a report in Access that is giving me fits on several fronts. So, I have a question.
The report is made up of 3 subreports and 1 main report.
There are a total of 4 tables at work here link with parent/child links on the subreports. Combined, they provide all the correct information. However, as usual, when you email them or send to Word in an .rtf using Docmd.sendreport or docmd.outputto, things just look screwed up and not pretty. Boss says "Fix it!".
Is there any way to take this information directly to Word without using Docmd?
I have used vba to open word docs, insert small information at bookmarks, and other things. I can not for the life of me even come close to figuring out how to take data gathered in the reports and insert the into a Word document correctly.
Can someone give me an idea of what kind of code I am looking for? or tell me where there might be some articles that could explain this?
I am very lost. Nathan
Senior Test Lead
I have a report in Access that is giving me fits on several fronts. So, I have a question.
The report is made up of 3 subreports and 1 main report.
There are a total of 4 tables at work here link with parent/child links on the subreports. Combined, they provide all the correct information. However, as usual, when you email them or send to Word in an .rtf using Docmd.sendreport or docmd.outputto, things just look screwed up and not pretty. Boss says "Fix it!".
Is there any way to take this information directly to Word without using Docmd?
I have used vba to open word docs, insert small information at bookmarks, and other things. I can not for the life of me even come close to figuring out how to take data gathered in the reports and insert the into a Word document correctly.
Can someone give me an idea of what kind of code I am looking for? or tell me where there might be some articles that could explain this?
I am very lost. Nathan
Senior Test Lead