REPOST!!! Form/template to pull information from access database

Sorry for repost, but I am needing help. If I am going in the wrong
direction please let me know and I will not waste anymore of my time or your
time asking questions regarding this method.

How do I create a master form/template in excel that will pull the
information from access? This needs to be emailed on to other individuals
who will input certain information. Therefore, some of my fields need to be
locked leaving some open for data entry.

I thought that perhaps a query imported from access to excel and then the
form populated by excel. Once the individual inputs info and emails back,
that info will populate my excel query.

The thought is all I have as I have never attempted anything like this and
have absolutely no idea as how to go about. I may be on the wrong track
also.

Should I create a query or a form to then move to excel?

Thank you in advance.
JR

This is not that difficult but it is also not trivial.

I would suggest that you hire a coder and work with them to define and
develop it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jwr" <[email protected]> wrote in message
news:[email protected]...
> Sorry for repost, but I am needing help. If I am going in the wrong
> direction please let me know and I will not waste anymore of my time or
your
> time asking questions regarding this method.
>
> How do I create a master form/template in excel that will pull the
> information from access? This needs to be emailed on to other individuals
> who will input certain information. Therefore, some of my fields need to
be
> locked leaving some open for data entry.
>
> I thought that perhaps a query imported from access to excel and then the
> form populated by excel. Once the individual inputs info and emails back,
> that info will populate my excel query.
>
> The thought is all I have as I have never attempted anything like this and
> have absolutely no idea as how to go about. I may be on the wrong track
> also.
>
> Should I create a query or a form to then move to excel?
>
> Thank you in advance.
> JR
>
>