L
leach613
I have a macro that I use to merge my word document with my timecard word
database. The only reason I have a macro to do the merge is to ask the
person what is the pay period so it can be replaced in each document.
This has been working great so far but now I need to separate the printing
of the timecards by department and shift. I've added these fields to my
database but need a way to query this my database each time I run my macro.
Can anyone tell me how to filter my database using word vba. I had a SELECT
statement but I kept getting an error so I'm not sure if I had the statement
written correctly.
Example of my code:
With ActiveDocument.MailMerge
.DataSource.QueryString = _
"SELECT * FROM H:\Accounting\Timecard.doc WHERE ((Dept = strDept)
AND (Shift = strShift))"
.Destination = wdSendToNewDocument
.Execute
End With
Any help would be appreciated.
Evy
database. The only reason I have a macro to do the merge is to ask the
person what is the pay period so it can be replaced in each document.
This has been working great so far but now I need to separate the printing
of the timecards by department and shift. I've added these fields to my
database but need a way to query this my database each time I run my macro.
Can anyone tell me how to filter my database using word vba. I had a SELECT
statement but I kept getting an error so I'm not sure if I had the statement
written correctly.
Example of my code:
With ActiveDocument.MailMerge
.DataSource.QueryString = _
"SELECT * FROM H:\Accounting\Timecard.doc WHERE ((Dept = strDept)
AND (Shift = strShift))"
.Destination = wdSendToNewDocument
.Execute
End With
Any help would be appreciated.
Evy