MS Access database support - printing checks with message intervals

Author

printing checks with message intervals

1800AD

2006-04-07, 3:44 am

Need to create a procedure that will print checks but post a message
after every check.
it has been 7 years since i did ms access. the report would be using 2
parameters, the member id and the check date, from which i will be
reading from a table.

your help will be greatly appreciated. thanks.

Arno R

2006-04-07, 3:44 am

Create a recordset for your checkdate with the MemberID's to print and =
their Email-address
Something like: (aircode)
Dim db as database, rst as recordset
Set db=3DCurrentDb
set rst=3Ddb.OpenRecordset("YourRecordset")
Do untl rst.EOF
DoCmd.OpenReport "YourCheckReport", acViewNormal , , "Where ID =3D " =
& rst!ID
DoCmd.SendObject , , , rst!Email, , , "Automated check-mail", =
"Message text here"
rst.Movenext
Loop

Arno R

"1800AD" <p.n.vasquez@gmail.com> schreef in bericht =
news:1144383993.969417.312390@j33g2000cwa.googlegroups.com...
> Need to create a procedure that will print checks but post a message
> after every check.
> it has been 7 years since i did ms access. the report would be using 2
> parameters, the member id and the check date, from which i will be
> reading from a table.
>=20
> your help will be greatly appreciated. thanks.
>

Sponsored Links