Auto Create Report from Rpt Template

  • Thread starter Thread starter Hafeez Esmail
  • Start date Start date
H

Hafeez Esmail

I have three Master queries (mstone, msttwo and mstthree)
that contain about 16 fields each (one of which is "Last
Name"). I want an automated process of emailing a report
to each person in the "Last Name" field. However, each of
these reports will only contain data for that person (i.e
Smith's report will have all records contianing "Smith" as
the Last Name).

My current approach is to manually create a report for
each person. Is there a way I can make only one "template
report" and have it create reports for each person?

Thanks
Hafeez Esmail
 
Every report can really be a "Template"
The OpenReport Method has a parameter called WHERE.

When you use OpenReport, pass something like, "LastName = Smith"
You can do this by looping through a recordset.

Save the report as a Snapshot, and email the file.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Hi Steve,

I'm quite new at this and have had no training
(formal/informal) in Access or VB.

I've created the OpenReport Macro and in the Where
Condition, I kept the following code

[Last_Name]=[Table_Name]![Last_Name]

Right now when I run the code, it asks me for a parameter
value ("Smith"). The View condition is set to "Print
Preview" cause the other options are "Print" or "Display".

How do I get it to loop through the names and how do I get
it to save/email a snapshot of the report?

Thanks a million
Hafeez Esmail
 
That's a little beyond the scope of my answering abilities.
I will recommend that you attend a local community college's Access
Programming class.

Hafeez Esmail said:
Hi Steve,

I'm quite new at this and have had no training
(formal/informal) in Access or VB.

I've created the OpenReport Macro and in the Where
Condition, I kept the following code

[Last_Name]=[Table_Name]![Last_Name]

Right now when I run the code, it asks me for a parameter
value ("Smith"). The View condition is set to "Print
Preview" cause the other options are "Print" or "Display".

How do I get it to loop through the names and how do I get
it to save/email a snapshot of the report?

Thanks a million
Hafeez Esmail
-----Original Message-----
Every report can really be a "Template"
The OpenReport Method has a parameter called WHERE.

When you use OpenReport, pass something like, "LastName = Smith"
You can do this by looping through a recordset.

Save the report as a Snapshot, and email the file.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-




.
Click to expand...
Click to expand...
 
Thanks for your help Steve,

I've started a new thread in the "Macro" section in the
hopes that someone there could help me out...

Hafeez Esmail
-----Original Message-----
That's a little beyond the scope of my answering abilities.
I will recommend that you attend a local community college's Access
Programming class.

Hafeez Esmail said:
Hi Steve,

I'm quite new at this and have had no training
(formal/informal) in Access or VB.

I've created the OpenReport Macro and in the Where
Condition, I kept the following code

[Last_Name]=[Table_Name]![Last_Name]

Right now when I run the code, it asks me for a parameter
value ("Smith"). The View condition is set to "Print
Preview" cause the other options are "Print" or "Display".

How do I get it to loop through the names and how do I get
it to save/email a snapshot of the report?

Thanks a million
Hafeez Esmail
-----Original Message-----
Every report can really be a "Template"
The OpenReport Method has a parameter called WHERE.

When you use OpenReport, pass something
Click to expand...
like, "LastName =
Smith"
You can do this by looping through a recordset.

Save the report as a Snapshot, and email the file.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have three Master queries (mstone, msttwo and mstthree)
that contain about 16 fields each (one of which is "Last
Name"). I want an automated process of emailing a report
to each person in the "Last Name" field. However,
Click to expand...
each
of
these reports will only contain data for that person (i.e
Smith's report will have all records
Click to expand...
contianing "Smith"
as
the Last Name).

My current approach is to manually create a report for
each person. Is there a way I can make only one "template
report" and have it create reports for each person?

Thanks
Hafeez Esmail



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top