calendar report

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a query that shows names with dates. I want to print this in a
calendar format. Is there a way to use outlook express or calendar creator
just for printing? I thought about saving the data to a text file and then
importing into outlook but this seems cumbersome. What are my options?
 
Duane,
I have finally had a chance to look over the calendar report you made. The
report and subreport is sourced to a table. I need to use a recordset
named rst_weekly_monthly. I have attempted to use the exact method you use
in your calendar report but by sourcing a query in the subform it runs too
slow. Also is giving me trouble on the network. I believe if I could source
a "recordset" instead of a query this would greatly improve the speed and
network functionality. In addition, what if I wanted to use this type of
calendar report in VB??? Wouldn't I need to use a recordset? Any help is
appreciated. Thanks, Jeff.
 
Why a recordset? There is no "subform". I assume you mean subreport. Are you
thinking of using a recordset in the subreport? Do you realize that the Link
Master/Child properties apply a filter to each of the copies of the
subreport?

Use a table or query for the subreport's record source.
 
Well...I have tried to set the subreport's recordsource to my query. My
query is a union of 3 queries. By itself the query takes about 2 seconds to
complete(it returns a full month of data). In the calendar report, I
believe, runs the query for every instance of the subform. The calendar
report takes about 20-30 seconds to complete. Also I had to add two more
days to the calendar for Saturday and Sunday. Although I does look great
and the data is showing perfectly...I have a feeling that my users are going
to complain about the speed. My thoughts are, I could code a recordset
from my query in the detail section of the report. Then I could set the
forms and subforms recordsource to the recordset, thus eliminating the time
consuming task of rerunning the query. What do you think? Thanks for the
reply.

PS There are not many people out there that have worked on calendar type
applications. You are the only one I know of.
 
Use a temporary table that resembles your union query. Use the temporary
table as the record source of the subreport.
 
Ohh..good Idea. I created a temp table called tbl_ReportTable.
What is the process that calls the query? In the detail section of the
report. I have tried:

SELECT * INTO [tbl_ReportTable] FROM qry_Weekly_monthly...this gives me a
syntax error. I know I am close but I just need a little help.

Also I am sure I will get warnings when executing the make table. Adding
records, loosing existing records etc...what are the procedures to avoid
these errors?
 
Create all the tables prior to opening the report. Your code might be:
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from tbl_ReportTable"
DoCmd.OpenQuery "qappYourAppend"
DoCmd.SetWarnings True

--
Duane Hookom
MS Access MVP
--

Jeff said:
Ohh..good Idea. I created a temp table called tbl_ReportTable.
What is the process that calls the query? In the detail section of the
report. I have tried:

SELECT * INTO [tbl_ReportTable] FROM qry_Weekly_monthly...this gives me a
syntax error. I know I am close but I just need a little help.

Also I am sure I will get warnings when executing the make table. Adding
records, loosing existing records etc...what are the procedures to avoid
these errors?



Duane Hookom said:
Use a temporary table that resembles your union query. Use the temporary
table as the record source of the subreport.

--
Duane Hookom
MS Access MVP


seconds
Click to expand...
Click to expand...
 
Got it! Thanks Duane..you have been extremly helpful. I sure am glad there
are people like you out there that have the experience and knowledge so that
you can pass it on to other people like me. Thanks again, Jeff Klein

Duane Hookom said:
Create all the tables prior to opening the report. Your code might be:
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from tbl_ReportTable"
DoCmd.OpenQuery "qappYourAppend"
DoCmd.SetWarnings True

--
Duane Hookom
MS Access MVP
--

Jeff said:
Ohh..good Idea. I created a temp table called tbl_ReportTable.
What is the process that calls the query? In the detail section of the
report. I have tried:

SELECT * INTO [tbl_ReportTable] FROM qry_Weekly_monthly...this gives me a
syntax error. I know I am close but I just need a little help.

Also I am sure I will get warnings when executing the make table. Adding
records, loosing existing records etc...what are the procedures to avoid
these errors?



Duane Hookom said:
Use a temporary table that resembles your union query. Use the temporary
table as the record source of the subreport.

--
Duane Hookom
MS Access MVP


Well...I have tried to set the subreport's recordsource to my query.
My
query is a union of 3 queries. By itself the query takes about 2 seconds
to
complete(it returns a full month of data). In the calendar report, I
believe, runs the query for every instance of the subform. The
calendar
report takes about 20-30 seconds to complete. Also I had to add two more
days to the calendar for Saturday and Sunday. Although I does look great
and the data is showing perfectly...I have a feeling that my users are
going
to complain about the speed. My thoughts are, I could code a
recordset
from my query in the detail section of the report. Then I could set
the
forms and subforms recordsource to the recordset, thus eliminating the
time
consuming task of rerunning the query. What do you think? Thanks
Click to expand...
for
the
reply.

PS There are not many people out there that have worked on calendar type
applications. You are the only one I know of.


Why a recordset? There is no "subform". I assume you mean
Click to expand...
subreport.
Are
you
thinking of using a recordset in the subreport? Do you realize that the
Link
Master/Child properties apply a filter to each of the copies of the
subreport?

Use a table or query for the subreport's record source.

--
Duane Hookom
MS Access MVP
--

Duane,
I have finally had a chance to look over the calendar report you made.
The
report and subreport is sourced to a table. I need to use a
recordset
named rst_weekly_monthly. I have attempted to use the exact method
you
use
in your calendar report but by sourcing a query in the subform it runs
too
slow. Also is giving me trouble on the network. I believe if I
could
source
a "recordset" instead of a query this would greatly improve the speed
and
network functionality. In addition, what if I wanted to use this type
of
calendar report in VB??? Wouldn't I need to use a recordset? Any help
is
appreciated. Thanks, Jeff.


There are some sample Access Calendar Reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP


I have a query that shows names with dates. I want to print
this
in
a
calendar format. Is there a way to use outlook express or
calendar
creator
just for printing? I thought about saving the data to a text file
and
then
importing into outlook but this seems cumbersome. What are my
options?
Click to expand...
Click to expand...
Click to expand...
 
Glad to hear it is working.

Your turn to help out will come...

--
Duane Hookom
MS Access MVP
--

Jeff said:
Got it! Thanks Duane..you have been extremly helpful. I sure am glad
there
are people like you out there that have the experience and knowledge so
that
you can pass it on to other people like me. Thanks again, Jeff Klein

Duane Hookom said:
Create all the tables prior to opening the report. Your code might be:
DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from tbl_ReportTable"
DoCmd.OpenQuery "qappYourAppend"
DoCmd.SetWarnings True

--
Duane Hookom
MS Access MVP
--

Jeff said:
Ohh..good Idea. I created a temp table called tbl_ReportTable.
What is the process that calls the query? In the detail section of
the
report. I have tried:

SELECT * INTO [tbl_ReportTable] FROM qry_Weekly_monthly...this gives me a
syntax error. I know I am close but I just need a little help.

Also I am sure I will get warnings when executing the make table. Adding
records, loosing existing records etc...what are the procedures to
avoid
these errors?



Use a temporary table that resembles your union query. Use the temporary
table as the record source of the subreport.

--
Duane Hookom
MS Access MVP


Well...I have tried to set the subreport's recordsource to my query.
My
query is a union of 3 queries. By itself the query takes about 2
seconds
to
complete(it returns a full month of data). In the calendar report,
I
believe, runs the query for every instance of the subform. The
calendar
report takes about 20-30 seconds to complete. Also I had to add two
more
days to the calendar for Saturday and Sunday. Although I does look
great
and the data is showing perfectly...I have a feeling that my users are
going
to complain about the speed. My thoughts are, I could code a
recordset
from my query in the detail section of the report. Then I could set
the
forms and subforms recordsource to the recordset, thus eliminating the
time
consuming task of rerunning the query. What do you think? Thanks for
the
reply.

PS There are not many people out there that have worked on calendar
type
applications. You are the only one I know of.


Why a recordset? There is no "subform". I assume you mean subreport.
Are
you
thinking of using a recordset in the subreport? Do you realize
that
the
Link
Master/Child properties apply a filter to each of the copies of
the
subreport?

Use a table or query for the subreport's record source.

--
Duane Hookom
MS Access MVP
--

Duane,
I have finally had a chance to look over the calendar report you
made.
The
report and subreport is sourced to a table. I need to use a
recordset
named rst_weekly_monthly. I have attempted to use the exact method
you
use
in your calendar report but by sourcing a query in the subform
it
runs
too
slow. Also is giving me trouble on the network. I believe if I
could
source
a "recordset" instead of a query this would greatly improve the
speed
and
network functionality. In addition, what if I wanted to use
this
type
of
calendar report in VB??? Wouldn't I need to use a recordset?
Any
help
is
appreciated. Thanks, Jeff.


There are some sample Access Calendar Reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP


I have a query that shows names with dates. I want to print
this
in
a
calendar format. Is there a way to use outlook express or
calendar
creator
just for printing? I thought about saving the data to a text
file
and
then
importing into outlook but this seems cumbersome. What are
my
options?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top