Multiple Prints

  • Thread starter Thread starter Paul R
  • Start date Start date
P

Paul R

I have sent this post to 3 newsgroup, i do not which would be best.

The problem I have is,

I have a membership database with some 2000+ members, each year I would like
to print a membership card out.

I would like to batch process this ie print all members with the surnames
beginging with A,B,C after that which maybe sometime, then print say D,E,F
and so on.

After the batch has run I would want to update the members record to say
that card has printed and the date.

Does anyone know of a way that this can be achived

Using Office XP

Many Thanks
Paul Raeburn
 
Paul said:
I have sent this post to 3 newsgroup, i do not which would be best.

The problem I have is,

I have a membership database with some 2000+ members, each year I would like
to print a membership card out.

I would like to batch process this ie print all members with the surnames
beginging with A,B,C after that which maybe sometime, then print say D,E,F
and so on.

After the batch has run I would want to update the members record to say
that card has printed and the date.

Does anyone know of a way that this can be achived

Using Office XP

Many Thanks
Paul Raeburn
Click to expand...
Create a 1 record, 1 field table with the last letter to be printer.
Make it a integer.
Get the number, add 1 to it. Look at the ASC and CHR functions.
The create an SQL statement or a where criteria string that will return
all records like some character.
The valid ranges form a character is 65-90 for upper case letters and 61
thru 122 for lower case
letters.

dim intNum as integer
dim txtchar as string
dim strCriteria as string

intNum=NumberFromTable + 1
txtChar CHR(intNum)

SQL
"SELECT Member.LastName FROM Member WHERE Member.LastName Like'" &
txtChar & "*';"

or
strCriteria="LastName likw'" & txtChar & "*'"
DoCmd.OpenReport ReportName , acViewPreview, , StrCriteria

Update the number in the table with iniNum.
Update the member record with a date of when the card was printed.
Look at the update query.

This is air code.
HTH
Ron
 
Back
Top