View Single Post
  #4   Report Post  
Beth Melton
 
Posts: n/a
Default

I guess I still don't understand why you are trying to utilize Word.
Based on your description you need to be using Access and not Word.

It sounds like you need a report grouped by City and then in either
the group header or footer Properties use the "Force New Page"
property to start each City on a new page. (The section and option you
use for forcing a new page depends on your report layout.)

If it's column/row borders you are after then either add a border
color to the text boxes or, if you use the Report Wizard and group by
the City then you'll see a "Block" style will be available on the
Layout selection.

If you have data in your Word tables then why not import it as an
Access table? For you this you would need to copy/paste it to Excel,
then copy/paste to Access. Here's an article with specific
instructions if you need it:
http://word.mvps.org/FAQs/TblsFldsFms/WordToAccess.htm

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"marc" wrote in message
...
Hi Beth -

Thanx for the quick reply!!!

What I did was copied and pasted a blank (dataless) word table into
an
access report...I then built that report (with data) in access, then
tried to
export it back into word and that's where I've run into this
issue....Like
you mentioned, it's just exporting the access data, nothing else...I
also
recreated one of my word tables in access (built the columns and
rows and
text so it would mirror the word doc), yet still access would only
export the
data into word, not the column/row lines....

It's an educational report that I need to complete soon...There's
about 10
different tables and about 1000 unique fields in each
report...There's a
total of 30 reports that I need to complete, one for each
city...Each report
is formatted the same, only the student data will differ for each
city...

I've been able to export the data (not the formatting) by the
'publish it
with word' command and then copy and paste it into each row of one
of my
original word tables from there...This just seems like a ton of work
and
there must be a quicker solution....I'll also mention that I tried a
mailmerge with no luck....

Thanx in advance if you can help me out,
marc

"Beth Melton" wrote:

I'm not exactly following what you are trying to do. Access Reports
are designed for reporting on data stored in Access. If you
copy/pasted a Word table directly into an Access Report then you
simply placed an embedded Word table in the report and it isn't
bound
to the database.

When you export an Access Report you are not exporting what you see
on
the screen. The data placed in Access controls, such as text boxes
and
labels, is what you are exporting and it doesn't include embedded
objects.

Perhaps if you can expand on what you are attempting to accomplish
we
can provide some suggestions.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"marc" wrote in message
...
I have a report written in word that contains a number of
tables....I
copied
those tables into access reports and got the data to line up
accordingly
using access...I then went to export the tables (with the data)
back
into
word and the only information that was exported was the data from
access....The rest of the page was blank...

Is there anyway to keep the tables formatted and displayed when
exporting
into word???

I've tried a number of different solutions, including recreating
the
tables
and exporting to different file types with no luck....I also
tried
to do a
mail merge, but I've run into limitations due to the number of
columns....It's a substancial report and, of course, it's due by
Friday
(31)....

Any help would be hugely appreciated!!!!!
marc
btw - I can access all of the versions of office, 97, xp, etc...