By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

how do I use word doc in access

P: n/a
ray
I am trying to use a word doc in access and am trying to create a database
around this preconfigured form. pleas help
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
In message <Km*********************@news4.srv.hcvlny.cv.net >, ray
<ra******@optonline.net> writes
I am trying to use a word doc in access and am trying to create a database
around this preconfigured form. pleas help


Can you give a little more detail? Are you trying to move data from Word
to Access or from Access to Word?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #2

P: n/a


Yhank for the help Betnard,

First this is my first database, what I was trying to do was take a form
I spent hours crating in microsoft word and use it as the basic
printable form or report in access. So that I can keep a database of all
the forms that I filled out and allthe names of the people I filled them
out for later use in mailing and corresponence. If you can give me a
few suggestions I would greatly appriecate it.

thank you any help

Ray

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
In message <40***********************@news.frii.net>, Ray Ortiz
<ra******@opyonline.net> writes


Yhank for the help Betnard,

First this is my first database, what I was trying to do was take a form
I spent hours crating in microsoft word and use it as the basic
printable form or report in access. So that I can keep a database of all
the forms that I filled out and allthe names of the people I filled them
out for later use in mailing and corresponence. If you can give me a
few suggestions I would greatly appriecate it.


It would help if you could give a bit more information about the type of
information you are collecting. That is what will drive the design of
the database behind the forms.

I'm not sure how much you know about database design, or whether you
just want information on how to make Access do what you want.

Assuming that you are more or less a beginner then what I suggest you do
is first make a list of all of the fields that are included in the form.
Sort them into groups. If you have information about a person put all of
that information together. If the form includes repeating groups of
information list that group separately.

For instance if the form was a purchase order you would have one group
of fields about the person or organisation doing the purchasing. You
would have a separate group of fields about the line-items (item name,
price, quantity) and which would be repeated for each item on the order.

Information about the person or organisation would go into one table in
the database. Information about line-items would go into a separate
table and appear on a subform in the report.

If you want to look up more detailed instructions on how to divide the
groups of data then look up the term normalisation (or normalization if
you want the American spelling.)

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #4

P: n/a
Do you mean you want to export data from access into a form you have
created in Word? If yes, well I can help you. Just let know since I
have some code that allows you to export data you are typing into
tables (using a form) and paste it into your own built Word forms.
Write to me to my email: jp***@tin.it.
Bernard Peek <ba*@shrdlu.com> wrote in message news:<TW**************@shrdlu.com>...
In message <40***********************@news.frii.net>, Ray Ortiz
<ra******@opyonline.net> writes


Yhank for the help Betnard,

First this is my first database, what I was trying to do was take a form
I spent hours crating in microsoft word and use it as the basic
printable form or report in access. So that I can keep a database of all
the forms that I filled out and allthe names of the people I filled them
out for later use in mailing and corresponence. If you can give me a
few suggestions I would greatly appriecate it.


It would help if you could give a bit more information about the type of
information you are collecting. That is what will drive the design of
the database behind the forms.

I'm not sure how much you know about database design, or whether you
just want information on how to make Access do what you want.

Assuming that you are more or less a beginner then what I suggest you do
is first make a list of all of the fields that are included in the form.
Sort them into groups. If you have information about a person put all of
that information together. If the form includes repeating groups of
information list that group separately.

For instance if the form was a purchase order you would have one group
of fields about the person or organisation doing the purchasing. You
would have a separate group of fields about the line-items (item name,
price, quantity) and which would be repeated for each item on the order.

Information about the person or organisation would go into one table in
the database. Information about line-items would go into a separate
table and appear on a subform in the report.

If you want to look up more detailed instructions on how to divide the
groups of data then look up the term normalisation (or normalization if
you want the American spelling.)

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.