Hi Stephen
Hoping you will read this & be able to comment.
I need to get, at runtime, the absolute location (in screen pixels) of
a control on a form. This is for an online tutorial program, that

I have a situation where I have a similar report layout, but various
criteria.  I want to be able to consolidate my reports so that I have a
'shell' report that can have different recordsources.  
If I have the same report called twice, but with two different

We're trying to build a report in the form of a calendar to put on the front
end of a scheduling tool.  Are there templates to create a calendar view in
Access?  I see templates for Word, Excel and Powerpoint, and am not sure if
any of them could be use in Access as the format ...

Can a report be created in the format of a monthly calendar?  Example:  I
have an event management database containing fields for event Names & event
Dates.  I would like to create a report which prints event names on the
corresponding date block of a monthly calendar.

I am trying create a report that shows monthly sales for last month and for
a year ago.  So if I ran this today it would show April 2005 and April 2004
sales.  If I ran in on June 1st it would show May 2005 and May 2004 sales.  I
have the queries down but I am trying to create ...

Can someone tell me the correct syntax for what I am trying to do below?
=IIf(([C5_1A]=3) Or ([C5_1A]=18) Or ([C5_2A]=3) Or ([C5_2A]=18) Or
([C5_3A]=3) Or ([C5_3A]=18) Or ([C5_4A]=3) Or ([C5_4A]=18) Or ([C5_5A]=3) Or
([C5_5A]=18]) Is Null,"","What are all the prescription drugs, ...

I have a report that has items on it with catalog numbers and vendors. The
catalog numbers and vendors come form a table called ITEMS. In that table I
have alternate catalog numbers and vendors. How can I get my report to let me
select an alternate vendor and cat. number?

I have the following SP that I am trying to use to report with,
CREATE PROCEDURE spCreditCardLog
@UserName varchar(30)
AS

I have an exit interview survey all inputed into Access, and I am wondering
what the best way to report the calculated information would be....

I have this as my ControlSource but can anyone tell me why, when I actually
run my report, it generates #Error in that field:-
=[Address] & ", " & [Village] & ", " & [Town]
TIA :)

I have a few graphs on a report that was originally put in as a sum, but now
I want to change to an average - how can you do this with out having to
recreate the graph?
Thanks

I have a base report which has text controls txt1 - txt10. Code
rerwites the query def.. so that in theory the report will display any
query. After the query def is set, the control sources of each text
control is set based on what the query contains.

I'm printing wire labels that have data on the first page (label) of the
report, but get multiple blank pages (labels) after.  The root cause is a
known problem with the printer driver, but this might take a while to get
fixed.  I need a work around to programmaticly limit the ...

I am trying to show 3 items in a pie chart, but no luck.  Specifically, I
have 3 ranges of info and have included a colunm in my table with numbers
1,2,3.  When I go to create the pie chart, however, I cannot get the pie
chart to show the size of the data in that particular group ...

I have a 1 line subform that returns a Balance Forward on a billing system,
based on a Billing Date parameter for the report.
(BalanceForward as of one month less than parameter [BillingDate])
This works fine when records exist, but there are situations where no