alex_117058
New member
- Local time
- Yesterday, 23:26
- Joined
- Jan 9, 2012
- Messages
- 5
Hello everyone,
I'm very new to access and computer programming in general, but thanks to sites such as this, I've learned quite a bit. I'm managing a database for a client and for the most part it does exactly what I want it to do. The only issue is that when I export a report in access 2007 to word, I get repeating labels in the word document. I have the "hide duplicates" function on in the report, so the only labels that I see on the report are unique. Therefore, I should not be seeing duplicates in the doc. An example is this:
Access 2007 report
Ch1
Part 1
Part 2
Part 3
Ch2
Part 4
Part 5
Part 6
Ch3
Part 7
Part 8
Part 9
etc.
However, in Word:
Ch1
Part 1
Part 2
Part 3
Ch2
Part 4
Part 5
Part 6
Ch2
Part 7
Part 8
Part 9
etc.
Everything is correct about the report except the underlined header being repeated for every category (each category is different from each other). Right now, I'm thinking it's a word program glitch? I've tried to export in pdf and all the underlined headers come out correct. Unfortunately, I need the report to be exported into word for further manipulation. Thanks for any help!
Also, as a follow up to the post, I'm currently using a macro to export from access to word. I'm aware of the export function in the external data tab on the ribbon, but the client likes to have things as simple and automated as possible, so a button on the report would be much more preferable than having to run an a saved export function each time. Thanks again.
I'm very new to access and computer programming in general, but thanks to sites such as this, I've learned quite a bit. I'm managing a database for a client and for the most part it does exactly what I want it to do. The only issue is that when I export a report in access 2007 to word, I get repeating labels in the word document. I have the "hide duplicates" function on in the report, so the only labels that I see on the report are unique. Therefore, I should not be seeing duplicates in the doc. An example is this:
Access 2007 report
Ch1
Part 1
Part 2
Part 3
Ch2
Part 4
Part 5
Part 6
Ch3
Part 7
Part 8
Part 9
etc.
However, in Word:
Ch1
Part 1
Part 2
Part 3
Ch2
Part 4
Part 5
Part 6
Ch2
Part 7
Part 8
Part 9
etc.
Everything is correct about the report except the underlined header being repeated for every category (each category is different from each other). Right now, I'm thinking it's a word program glitch? I've tried to export in pdf and all the underlined headers come out correct. Unfortunately, I need the report to be exported into word for further manipulation. Thanks for any help!
Also, as a follow up to the post, I'm currently using a macro to export from access to word. I'm aware of the export function in the external data tab on the ribbon, but the client likes to have things as simple and automated as possible, so a button on the report would be much more preferable than having to run an a saved export function each time. Thanks again.
Last edited: