S
Senad
Hi All,
I am trying to create a VBA code which will run the SQL query and create a
word document.
I managed to dynamicly create SQL query, but the problem comes when I try to
outpud data from query to the word file.
What I did is I created report in MsAcces first and tried to export this to
the Word, but why I got is disaster.
I have a table with several fields namely: Country; Agency; Date; Story.
Country - memo field
Agency - memo field
Date - Date/Time
Story - memo field
The problem is that when I publich report to Ms Word it creates whole lot of
the empy lines, empty pages and adds a paragraph mark on the end of each
line.
I home someone will be able to help me export data from query to Ms Word
proprly.
The data should be grouped by country.
Next line should be Agency and Date
followed by a data from memo field, hopefully without paragpraph marks.
The report should be saved on a certain location on the HDD wih in a format
e.a. "Regianl Report covering period from `date` to `date`"
Thanks
Senad
I am trying to create a VBA code which will run the SQL query and create a
word document.
I managed to dynamicly create SQL query, but the problem comes when I try to
outpud data from query to the word file.
What I did is I created report in MsAcces first and tried to export this to
the Word, but why I got is disaster.
I have a table with several fields namely: Country; Agency; Date; Story.
Country - memo field
Agency - memo field
Date - Date/Time
Story - memo field
The problem is that when I publich report to Ms Word it creates whole lot of
the empy lines, empty pages and adds a paragraph mark on the end of each
line.
I home someone will be able to help me export data from query to Ms Word
proprly.
The data should be grouped by country.
Next line should be Agency and Date
followed by a data from memo field, hopefully without paragpraph marks.
The report should be saved on a certain location on the HDD wih in a format
e.a. "Regianl Report covering period from `date` to `date`"
Thanks
Senad