ACCESS FEED: [MS_AccessPros] Re: merge utility

Rabu, 21 Desember 2011

[MS_AccessPros] Re: merge utility

Bill,

with all the posting and answering going on in this forum you can't assume that anyone will know from one post to another what version of Access or Word or anything else you are using. Assume with each post that people are going to be reading your post, and trying to help you, that have never seen any of your previous posts and even if they *have* read your previous post there is not a snowball's chance that they will be easily able to remember what versions you are using, or *were* using last time you posted.

100% friendlywise :-)

AS you compare Clives code snippet to chinese I'm now 99% convinced you must be manually creating the merged documents (hitting Menu options, and this in Word.)

--- In MS_Access_Professionals@yahoogroups.com, "WS Cook" <wscook@...> wrote:
>
> Clive
> In prior postings I indicated that it was 2007 Access and Word.
> Your below solution appears brief enough, but may as well be written in
> Chinese for my skill level. Additionally
> I create mutiple documents using the Access tables when differing responses
> are needed. Comparably, I want to make two bean soup and the Access
> cookbook mandates that you can only use one bean to make two bean soup.
> Bill Cook
> ----- Original Message -----
> From: "Clive" <zctek@...>
> To: <MS_Access_Professionals@yahoogroups.com>
> Sent: Wednesday, December 21, 2011 8:23 AM
> Subject: [MS_AccessPros] Re: merge utility
>
>
> Hi Bill,
>
> You have still not told us what version of Access
> you are using.
>
> For Access2003 SP3 and later you can save a document
> using the TransferText command.
> To get the Access Help for it click Help, type
> TransferText, and press F1.
>
> Your VBA code would be something like:
>
> DoCmd.SetWarnings False
> DoCmd.TransferText acExportDelim, _
> "ExportSpecName", _
> "TableName or QueryName", _
> CurrentProject.Path & "\FileName.txt", _
> True
> DoCmd.SetWarnings True
> MsgBox "Output Saved in '" & _
> CurrentProject.Path & "\FileName.txt'."
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "acravenrohm" <yahoo@>
> wrote:
> >
> > With all due deference to Crystal, there are good reasons to want to save
> > the electronic copies of documents as printed.
> >
> > Next year I will ant to see the document in original, not the document as
> > it would now look like. The person might have married and have a
> > different Family name. The Bank account details might have changed, the
> > account balance should have changed.
> >
> > You can maintains a history of the chanegd data in order to recreate the
> > past but it's usually easier to keep a copy of the things you actually
> > send out.
> >
> > Here, I suspect that the solution to Bill's Problem will become clearer
> > once he describes exactly how he's saving the Document in/from Word. (I
> > sounds like he's using ExportAsFixedFormat with ExportFormat set to
> > wdExportFormatXPS but "sounds like" is just a guess.)
> >
> > Bill, sounds like you're doing this by hand?
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal
> > <strive4peace2008@> wrote:
> > >
> > > Hi Bill,
> > >
> > > I have never tried to save a merged document
> > >
> > > why save the documents in electronic format?ï¿½ You can always create
> > > them again.ï¿½ I keep track of which records have been merged into
> > > Access through structure.ï¿½ For instance, make a table for documents
> > > and document templates.ï¿½ Assume you already have a contacts table.ï¿½
> > > Then simply make a table cross-referencing the 2 -- you can reprint any
> > > merged document anytime.ï¿½
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > ï¿½*
> > > ï¿½ï¿½ (: have an awesome day :)
> > > ï¿½*
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: WS Cook
> > >
> > > Crystal and Clive
> > > I create a table in Access that list insurance company, address, claim
> > > number, drivers name, ETC.
> > > I then bootup MS Word to create letters to send to the insurance company
> > > and
> > > merge my fields from the Access tables. Then I save the document in MS
> > > Word
> > > since I am in MS Word.ï¿½ Later when I revist the saved document, it has
> > > an
> > > extension of "XPS" and Word responds that it can not open the document.
> > > Effectivly I do not have a saved document for my records or additional
> > > work.
> > > In researching I read in Matthew MacDonald's "The Missing Manual" for
> > > Access
> > > 2007 that there was an add on patch from MS that would allow saving in a
> > > format that would allow a change of the file extension to make it
> > > readable
> > > in MS Word 2007.ï¿½ I tried to make that happen and ended up with an
> > > unworkable mess.ï¿½ It seems that MS had a concern for infringment to
> > > Adobe so
> > > it decided a PDF file with such a process as I described was not
> > > necessary
> > > and just left it out.ï¿½ It is logical that such a super programs, that
> > > Access
> > > and Word are, would be able to let a neophite user complete such an
> > > unsophisticated procees.
> > > Merging Access with Word is not my issue as that is straight forward and
> > > doable.ï¿½ How to save the merged document is a stumbling block for me.
> > > I look
> > > at the complex issues that are queried and the learned response
> > > solutions to
> > > the complex issues in the forum and my problem seems like "Ned and the
> > > First
> > > Reader" See spot run.
> > > I realize that I am in an Access Forum seeking advice for a Word issue
> > > but
> > > it directly relates to Access merge.
> > > Thanks for your time and any advices
> > > Bill Cook
> > > PS
> > > my outlook spell checker does not work if any errors
> > >
> > > ----- Original Message -----
> > > From: "Crystal" <strive4peace>
> > >
> > >
> > > hi Bill,
> > >
> > > what kind of a merge are you doing? Using Access to supply fields for a
> > > Word
> > > merge? Using code to substitute bookmarks or something? Please give more
> > > information and what is the problem? what version?
> > >
> > > warm regards,
> > > Crystal
> > >
> > > * have an awesome day :)
> > >
> > >
> > >
> > > ________________________________
> > > From: WS Cook
> > >
> > > Crystal
> > > In looking at Mr. Toews blog I searched for any info on " Access merge
> > > to
> > > word" and found the below entry. However I could not locate the utility.
> > > My prior postings and queries on this subject were treated similar to if
> > > I
> > > had asked the group "How do I make a table" so the query went
> > > unanswered.
> > > I hope someone in the forum can direct me to a solution for an
> > > apparantly
> > > infrequent shared "Access to Word" merge problem.
> > > Bill Cook
> > > *************
> > > Access to Word Merge utility
> > > I was reminded by a newsgroup posting of fellow Access MVP Albert
> > > Kallal's
> > > excellent Access to Word Merge utility. Keep that one book marked as it
> > > is
> > > easy to use and works well.
> > >
> > > Published Fri, Oct 17 2008 15:57 by Tony
> > > Filed under: Access, Tips
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>