I am trying to use a word doc in access and am trying to create a database
around this preconfigured form. pleas help
around this preconfigured form. pleas help
-
-
Re: how do I use word doc in access
In message <KmgUb.11543$%9 3.3462531@news4 .srv.hcvlny.cv. net>, ray
<raysbudo@opton line.net> writes[color=blue]
>I am trying to use a word doc in access and am trying to create a database
>around this preconfigured form. pleas help[/color]
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.
-
Re: how do I use word doc in access
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!
Comment
-
Re: how do I use word doc in access
In message <40221ae7$0$703 03$75868355@new s.frii.net>, Ray Ortiz
<raysbudo@opyon line.net> writes[color=blue]
>
>
>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.[/color]
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.
Comment
-
Re: how do I use word doc in access
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: jprma@tin.it.
Bernard Peek <bap@shrdlu.com > wrote in message news:<TWhUJqDAl nIAFwoc@shrdlu. com>...[color=blue]
> In message <40221ae7$0$703 03$75868355@new s.frii.net>, Ray Ortiz
> <raysbudo@opyon line.net> writes[color=green]
> >
> >
> >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.[/color]
>
> 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.)[/color]
Comment
Comment