UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> mail merg with a query    
 
   
cheykristie
post Mar 6 2008, 02:29 PM
Post #1

UtterAccess Addict
Posts: 118



In the past I have had a query mail merged with a word document and it has worked great. Last week I opened it and it would not do it. I went to try to troubleshoot it and find out what is going on. I have a critiera that lets me type the last 3 numbers of a TA number and it filters it so that is the only record i view in my word document. If I take that out, I can do it. However it is important that I have that. I make individual labels using a dymo labler with this technique. Does any one have any suggestions for me?
If there is an easier way to get my selected information in to a word document that would be great. I was thinking of having a command button on my form for that traveler and it opens up the dymo and paste the information, however it does not put it in the lable how I want it. That is why I did the mail merge with work.

Anyways if someone could help me get my mail merge working again that would be great.

Thanks
Chey
Go to the top of the page
 
+
fkegley
post Mar 6 2008, 04:08 PM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi



I'v had that trouble too. I solved it by making the query a Make-Table query and modifying the mail merge to use the table.
Go to the top of the page
 
+
cheykristie
post Mar 6 2008, 04:36 PM
Post #3

UtterAccess Addict
Posts: 118



How do I do that?
I open new query and use a table?
If so, I still have trouble adding the critiera that allows me to type the last 3 of my TA number. Any other suggestions or if I am off, how do I make a table query?

Thanks
Chey
Go to the top of the page
 
+
HiTechCoach
post Mar 6 2008, 10:53 PM
Post #4

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma



I have found that it better to NOT merge with an Access database.

I would urge you to look at this:
Super Easy Word Merge.
You will need to scroll done to find it.
Go to the top of the page
 
+
cheykristie
post Mar 7 2008, 01:06 PM
Post #5

UtterAccess Addict
Posts: 118



When I use the example database it works but when I put it in mine I have a problem when I assign the form name and click okay

this pops up

Public Function ShowProgress()

'
' we have a list....start a progress bar.
Set = New Form_GuiProgress

frmGuiP.Visible = True
DoEvents
End Function

it says that the FrmGui is not defined. I can not find that form. I imported all the other forms.

Any suggestions?

Thanks

Cheyenne
Go to the top of the page
 
+
cheykristie
post Mar 7 2008, 02:57 PM
Post #6

UtterAccess Addict
Posts: 118



I keep trying to play with this I am realizing that it is not bringing up the progress bar to save it to the folder. Can someone please assist me. I am also using a different version than what I downloaded.

Thanks.

Cheyenne
Go to the top of the page
 
+
vtd
post Mar 7 2008, 06:11 PM
Post #7

Retired Moderator
Posts: 19,667



See if:

* Microsoft Knowledge Base article 833064
* Microsoft Knowledge Base article 214183

help ...
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 06:48 PM