Hopefully this post doesn't get too long but I want to give all the info I
can. :-)
BACKGROUND:  I have an DB with 1 table that keeps track of 1/2 call
increments showing calls taken, # coming in, % that go to voice mail, etc.  I

I have a report based on a parameter query  [Start Unit], [End Unit] are the
parameters
I want to make the report header not visible based on the value of  one of
the parameters.

I've got code which creates Snap (.snp) files from Access data via the
OutputTo command using the acFormatSNP format option.  I want to print the
result from file later (e.g., "c:\My Documents\report.snp") rather than
executing the Access report again.  What command(s) would I ...

Is there any way to preview a report without having a printer installed?  We
have an MDE that our employees use to look up what time off is still
available, but they will be losing their printing abilities very soon and I
need to see if there is a work-around.

I have a simple form that calculates elapsed time for a work day. The
expression that calculates the hours worked for the Total_Time field is:
=HoursAndMinutes([End_Time]-[Start_Time])
and that works perfectly.

Need some help here. I'm trying to meke a "Where" statement in which the
first 3 months of the current year are selected. This is what I thought of
myself, but it's wrong and won't work.
"... Between (#01-01-# + Year() + #00:00:00#) and (#31-03-# + Year() +

Hi Folks, I have two ways I print a report to Snapshot:
1. Send - where the Report options can be made between HTML, Excel, Dos txt,
Rich Text or Snapshot.
Problem: 'Send' adds the Report to an email, in Snapshot format, as an

I have a report containing a memo field. I need to bold certain records in
the report, which I handle in the Detail_Print event by setting each field's
FontBold property. For certain records, this results in the last line of the
Memo field being "cut off" somehow. This only ...

I currently run reports and use bmp in the report.  The reports print fine
and the the images are displyaed appropriately.  When I convert to Word, the
images are not displayed.
Can someone please assist me with this problems?

Hi to all,
I would like to know how to pass a report value to a Dlookup function that
value is a date and every time I get an #Error as a result
here is my syntax:

Group:
I need help with the VBA code to retrieve the caption (name) of a report
that is currently open.
Any help will be greatly appreciated.

For me I like using the following....
=Sum(Abs([d3]="Monday"))
D3 is a field that has 7 possible responses....the days of the week.
BUT when all is said and done.....I get my say....23 people saying Sunday.

I have a total figure in a group footer.  If I print directly to the default
printer, the amount is correct.  If I use a custom dialog to allow the user
to select a printer, the amount is correct.
However, if I use the preview option and the user selects the printer using

Is there a way to modify the "Print Dialog Box" to include a "Print Current
Page" of the report that Access generates?  Or can you create a Menu Button
or Command Button with code that prints the page that is currently displayed?
Thanks in advance for your help!

I have the following issue:
On a report footer based on a query, grouped by [Type](Type being "in" and
"out"), with totals by [Type] in group footer and report footer, I want to
add a calculated field that show the difference between the totals of "In"