Populate Excel form using Access

[BML]

I have a form created in Excel that must be filled out with 200 different
sets of information to create 200 different forms. Is it possible to do this
using an access database I create? I would like it to product the 200 forms
all at once so I do not have to print them individually.

 

[Clif McIrvin]

I have a form created in Excel that must be filled out with 200
different
sets of information to create 200 different forms. Is it possible to
do this
using an access database I create? I would like it to product the 200
forms
all at once so I do not have to print them individually.

Not a lot of information here to work with, but it sounds to me like
your Excel form could be re-cast as an Access report (since you're
thinking of creating an Access db anyway).

Is there some reason this *needs* to be an Excel form? (It is possible
to do calculations on an Access report.)

 

[deb]

this was actually the first reason i got into access

i created a db that fed into an order form

the way i did it was by creating a query that dropped all the data into the
last sheet, then i used vlookup to populate the fields - if you're good with
excel its easy

it was pretty spiffy actually

i know i'm not an expert but personally i loath access reports, i find it
much easier and more user friendly to store all the data in access and use
querys to export to excel

 

[Clif McIrvin]

Deb, I can relate to the general tone of your last post ... I came into
Access with no prior db experience, and Excel with only limited exposure
to spreadsheets. I had considerable programming experience several years
ago, but nothing recently ... so the need to learn both has been
interesting, to say the least.

While I'm still unclear as to what precisely you are asking I'm going to
guess that what you find particularly loathsome about Access reports is
the fact that you are in effect drawing on a real piece of paper and you
do not have the magic zoom capability that Excel gives you.

I found that once I realized that particular detail designing Access
reports became much easier. My technique, if I'm designing a report
layout of much complexity at all, is to create a mockup-up in Excel ...
when I have a printed copy that I'm happy with I get a ruler to get the
locations of everything and build the Access report *to exact scale*.
It took some getting used to, but once I figured that out generating
pre-populated printed forms became much easier.

If I'm interpreting your posts correctly, I think this is the answer to
your question.

Aside: "Form" in Access (MS Office itself, for that matter) is a
technical term that does not necessarily correlate to what you and I
normally think of when we are thinking of a printed form --- keeping
that in mind when posting to an Access forum / newsgroup will likely
save a lot of confusion.

 

[deb]

i assumed that BML is creating forms to print (as opposed to forms to input
data) in excel and thats what i do.

i love access forms and i use them all the time, but when i need to get a
report i switch to excel - access reports reminds me of the old "crystal
reports" system and its just way too fiddly. To get totally off the subject,
its like comparing MS Publisher and Adobe In Design, once you've used ID you
would never use Publisher again - when i want to create really good looking
reports i export from Access to In Design waaaaay easier than trying to
create reports in Access, but the big problem is that you then need to know
how to use ID too - phew too many programs!

i think its something MS really needs to work on

 

[Clif McIrvin]

My bad ... I missed that I wasn't replying to the OP. Sorry.

In former times I had a brief encounter with Crystal Reports .. and I
agree ... that's exactly what the Access Report designer makes me think
of.

Your assumption about the OP's question is the only way I can make sense
out of it, too.

We've had an interesting exchange; maybe it's even helped BML.