Off the wall question, Need input please!

[Stockwell43]

Hello,

I have a bit of an odd question(or atleast for me). I have a form that was
created in Word. I once seen someone place a form similar in the details
section of a report and place the field that are filled in on the access form
on the word form. Example:

If the access form has Name, Ext:, Department, Date, Update Database, New
procedure etc.. these fields would be placed on the form that was copied into
the access detail report section. So when all the fields are filled out on
the Access form, the user clicks a button and access will place the
information directly to the fields in the access report and print it.

It's kind of like a mail merge or similar but I was wondering if it could be
accomplished keeping the data and the form within the database. The database
I seen this done in was at my old job so I don't have access to it but, I
know it was done and I seen how part of it was done but not sure if it was
something that was monkey rigged or if it's part of an access feature?

Thanks!!!

 

[Beetle]

Sorry, but it's difficult to determine what you want from your post.

Are you saying you want to print an Access report that looks similar to
a Word document you have seen in the past?

Or are you saying you want to transfer Access data to an existing Word
document?

 

[Stockwell43]

Hi Beetle,

I want to create an access form to mimick a word document. I want to place
the word document in the details section of an access report. When I click a
button on the access form, I want the completed fields to transfer to the
word oducment in the detail section of the access report. After the button is
click and the information transfers, the information completed on the access
form is automatically deleted so it saves no records, just used to input the
data until it is transferred.

Am I making sense? I seen it done before and am searching the internet and
finding somethings that are close but not quite what I am look for but am
still searching.

Any help would be most appreciated!!!

 

[martinmike2]

Hi Beetle,

I want to create an access form to mimick a word document. I want to place
the word document in the details section of an access report. When I click a
button on the access form, I want the completed fields to transfer to the
word oducment in the detail section of the access report. After the button is
click and the information transfers, the information completed on the access
form is automatically deleted so it saves no records, just used to input the
data until it is transferred.

Am I making sense? I seen it done before and am searching the internet and
finding somethings that are close but not quite what I am look for but am
still searching.

Any help would be most appreciated!!!









- Show quoted text -

It sounds like you want to make an OLE Object in your report and set
it to link to a word document with some sort of default text on it.
Then, when you fill out the form, you want to click a button and
"send" the data from the form to the report to fill in blank spaces on
the word document.

Is this what you are looking for?

If so, my question is, why not just make a report that mimics your
word document? This would cut back a lot on bloating.

 

[Beetle]

I've never heard of a Word document being placed inside an Access
report, so if that can be done it's news to me.

I can't answer your question but I would say that it seems like a lot
of trouble to go through, especially if you're not even saving the data.
Seems
like it would be a lot easier just to create a Word template and have the
users enter info directly into that, or create an Access report that looks
like
the Word document.

Maybe someone else will chime in with some suggestions

Good luck

 

[Stockwell43]

Yeah, that's kind of what I thought but need to hear it from someone else.
Thank you for your help and suggestions, much appreciated!

 

[John Spencer]

You might want to take a look at Albert Kallal's Word Merge Code

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Stockwell43]

Hi John,

Yes, I have that set up on another database. On this one, I was thinking of
a way people could fill out a form in access and have it transfer to a form
similar in a report. Oringinally I told Beetle I did not want to save the
records but actually I do because instead of them printing out the form to
turn in to me, I would just save all the information in the database.

One thing I will need to know is how to print the current record in case
management wants to see a copy. But for now, I am folling with the access
form and then mimick it in the detail section of the report.

Thanks for responding!!