S
Stephanie
Albert,
Thanks for making your WordMerge20 sample db available- it's very slick! I
have a question about chosing a query. All of the queries that I'd like to
use for my WordMerge require user input- they are renewal notices with an "as
of date" pop-up box (so that the user can run the merges, say, as of the end
of next month).
Is there a way that I could still use the fabulous WordMerge20 example, but
modify it to accept user input?
This is my sql subquery for user input:
(SELECT Max(DuesLineItem.DateCreated) AS MaxOfCreateDate FROM DuesLineItem
GROUP BY DuesLineItem.ContactID HAVING
(((DateDiff("d",Max([DuesLineItem].[DateCreated]),[forms]![DateParam]![FindDate],True))>334)
In my report, here's the vba:
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "DateParam", , , , , acDialog
If Not IsLoaded("DateParam") Then
Cancel = True
End If
In your WhatQuery code you have:
Private Sub Command2_Click()
MergeAllWord Me.Combo0
End Sub
I tried to add code to your code to open my user input form- it didn't like
the Is Loaded bit, but seemed to accept DoCmd.OpenForm "DateParam", , , , ,
acDialog
then my input box opened, I entered the date, and hit the preview button
(which of course has nothing to do with WordMerge, but I'm not sure what to
do about it- how to use an input box...)
Private Sub Preview_Click()
Me.Visible = False
End Sub
and then got an error message: no data for this merge.
Can the WordMerge work with user input parameters?
Thanks for making your WordMerge20 sample db available- it's very slick! I
have a question about chosing a query. All of the queries that I'd like to
use for my WordMerge require user input- they are renewal notices with an "as
of date" pop-up box (so that the user can run the merges, say, as of the end
of next month).
Is there a way that I could still use the fabulous WordMerge20 example, but
modify it to accept user input?
This is my sql subquery for user input:
(SELECT Max(DuesLineItem.DateCreated) AS MaxOfCreateDate FROM DuesLineItem
GROUP BY DuesLineItem.ContactID HAVING
(((DateDiff("d",Max([DuesLineItem].[DateCreated]),[forms]![DateParam]![FindDate],True))>334)
In my report, here's the vba:
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "DateParam", , , , , acDialog
If Not IsLoaded("DateParam") Then
Cancel = True
End If
In your WhatQuery code you have:
Private Sub Command2_Click()
MergeAllWord Me.Combo0
End Sub
I tried to add code to your code to open my user input form- it didn't like
the Is Loaded bit, but seemed to accept DoCmd.OpenForm "DateParam", , , , ,
acDialog
then my input box opened, I entered the date, and hit the preview button
(which of course has nothing to do with WordMerge, but I'm not sure what to
do about it- how to use an input box...)
Private Sub Preview_Click()
Me.Visible = False
End Sub
and then got an error message: no data for this merge.
Can the WordMerge work with user input parameters?