Can a form in MS Word be imported into Access as an entry form?

[Steville]

I have a form in MS Word and also as a PDF and would like to import this
into MS Access 2003 to be used as form in Access. Is it possible to do this?
If so, how is it done? I am unable to find any way to do this either as an
import or link file for these file types.

I have already created an Access table to receive the data.

 

[Jeff Boyce]

In Access, a "form" is a definition for where data is to appear on the
screen.

I'm not aware of a way to convert an MS Word or PDF "definition" into an
Access definition. Others may have run across this.

Why? As in "why do you want to force data entry to look like Word?"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I have a form in MS Word and also as a PDF and would like to import this
into MS Access 2003 to be used as form in Access. Is it possible to do this?

No. Word forms (and even more so, .pdf documents) are altogether different in
structure, purpose and nature from Access data entry forms. You'll need to
create a new form (which can be made to look like the Word form of course).

 

[Steville]

Jeff -

Thanks for your response. In answer to your question:
(Why? As in "why do you want to force data entry to look like Word?")

It's a form/template provided by a business partner and we would like to use
it as an entry point to an Access table when so that when we fill in the data
on the form it gets stored for future review.

I was hoping to not recreate the document if it could be imported.

Steville

 

[Jeff Boyce]

The potential issue you may face is that forms (Word, PDF) are rarely
"well-normalized", but Access is a relational database.

If you feed it 'sheet data (e.g., from a spreadsheet), you won't get very
easy or good use of Access' relationally-oriented features/functions.

The trick to getting good use of Access is to create the well-normalized
table structure FIRST, then build forms to help with data entry and edit.
Unless your existing forms contain radically un-normal data, you'll probably
be able to reconstruct your Word/PDF form and get it to properly interact
with tables that the users will never see.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John... Visio MVP]

Do you REALLY know what you are talkimg about? A Word form as a backgound?
It would be far easier to recreate the form in Access.

John... Visio MVP