Re: Albert D. Kallal -WordMerge20

Thanks so much for the reply!
I must admit, I'm a bit confused. I'm sorry I haven't explained myself
well. Let me explain what I'd really like to do and see if it can be done.

I like the WhatQuery user interface- very user friendly and easy to use for
more than one WordMerge. So I'd like the user to select the query from the
combo box on WhatQuery, then have the appropriate user input open up, the
user enters the date, and then clicks on the "Click here to merge using the
above query", and have the merge run using the query with the user defined
date and the chosen WordMerge template.

So I don't want to use a Report (I think that's what has me confused), and
therefore DateParam (my user input form won't open). Rather what the query is
looking for will pop up as a window that states "Enter Parameter Value" and
shows Forms!DateParam!FindDate (perhaps technically it's all the same thing)
along with a field to enter the date.

I'm wondering if there is a way to modify your WhatQuery form to accept user
input (for the date) and then click on merge to use the query, with the input
date, and the WordMerge template.

Or barring all of that user-friendly stuff, I tried modifying my report:
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "DateParam", , , , , acDialog
If Not IsLoaded("DateParam") Then
' Cancel = True
Exit Sub
End If
MergeAllWord ("Labels by Ken ITA Membership")
End Sub

But received an error message: No data for this merge...make sure sql is
correct.

Thanks for the help- I appreciate your efforts.

"Albert D.Kallal" wrote:

> "Stephanie" <Stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1FCC1D4E-FE93-4E5A-86D6-939DD43BC53B@xxxxxxxxxxxxxxxx
>
> >
> > Is there a way that I could still use the fabulous WordMerge20 example,
> > but
> > modify it to accept user input?
>
> Sure, you can grab the users input for a date, or even build a form with a
> text box for the date, and a "word merge" button.
>
> If you want to modify (build a new) form that "returns" values, then I
> explain how to do this here:
> http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html
>
> In looking at your reprot code sample, it seems you are using the above
> approach anyway (visiable = false to kick out of acDiaogMode).
>
> ok, if you do the above then the query should work.
>
> You code could be:
>
> DoCmd.OpenForm "DateParam", , , , , acDialog
> If Not IsLoaded("DateParam") Then
> exit sub
> End If
>
> MergeAllWord ("nameofquery")
>
> -
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@xxxxxxx
> http://www.members.shaw.ca/AlbertKallal
>
>
>
.