access database to word

  • Thread starter Thread starter samthrowaway
  • Start date Start date
S

samthrowaway

Hi everyone,
I have a relative who is writing a book. It's an encyclopediac book, so
she's writing it in access. The publisher, however, wants a word file.
As the family computer guy, I've been given the task of getting it
converted.

I know nearly nothing about access, and even less about VBscripting,
but I'll tell you what I know.

The database consists of one form that contains four thousand-some
records. She wants it in a word document. She wants two specific
formats in the word document. Some records, she wants in a short
format, some in a long format. This is specified by a field in the
form.

Where should I start on this? I have no interest in learning to
VBScript, but I guess that I can if absolutely necessary.
Please help!
leo
 
Hi everyone,
I have a relative who is writing a book. It's an encyclopediac book, so
she's writing it in access. The publisher, however, wants a word file.
Click to expand...

Ow.

As much as I love Access, I would NEVER use it for writing a document.
It's not designed for the purpose. I'd very likely use it to store
information for the book but not the book itself!
As the family computer guy, I've been given the task of getting it
converted.

I know nearly nothing about access, and even less about VBscripting,
but I'll tell you what I know.

The database consists of one form that contains four thousand-some
records.
Click to expand...

No. It doesn't.

A Form doesn't "contain" ANY records. It's just a window onto the data
in a Table. You need to create a Report based -not on the Form - but
on the Table upon which the form is based.
She wants it in a word document. She wants two specific
formats in the word document. Some records, she wants in a short
format, some in a long format. This is specified by a field in the
form.
Click to expand...

Two reports, then, using queries selecting these Fields.

You can export a Report to a .rtf (Rich Text Format) file which can be
read using Word, and converted to a .doc (Document) file.
Where should I start on this? I have no interest in learning to
VBScript, but I guess that I can if absolutely necessary.
Click to expand...

Since Access .mdb databases do not use or support VBScript, that's a
non-issue!

John W. Vinson[MVP]
 
John said:
Ow.

As much as I love Access, I would NEVER use it for writing a document.
It's not designed for the purpose. I'd very likely use it to store
information for the book but not the book itself!


No. It doesn't.

A Form doesn't "contain" ANY records. It's just a window onto the data
in a Table. You need to create a Report based -not on the Form - but
on the Table upon which the form is based.


Two reports, then, using queries selecting these Fields.

You can export a Report to a .rtf (Rich Text Format) file which can be
read using Word, and converted to a .doc (Document) file.


Since Access .mdb databases do not use or support VBScript, that's a
non-issue!

John W. Vinson[MVP]
Click to expand...

Thanks very much! As you can see, I know very little about access. I'm
normally a linux user, so I was horrified that she had done it in
access, let alone ask me to do anything with it.

As a side note, if access doesn't support VBScript, then why does the
"Modules" section say something about VBScript?
 
As a side note, if access doesn't support VBScript, then why does the
"Modules" section say something about VBScript?
Click to expand...

Didn't know it did! It supports VBA, Visual Basic for Applications.

John W. Vinson[MVP]
 
Back
Top