Re: Albert D. Kallal -WordMerge20

"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


.