As suggested by 'SA' of 'ACG Soft' in another post under 'Flexible default
y-axis labels in Microsoft Graph', I tried the following code to try to
programmatically control the X-Axis scale of a chart in an MS Access 2003
report.  I get an 'Object doesn't support this property or ...

I have a Parent Report that contains individual information such as name,
director, manager, dept.  It also has 6 Sub Reports in it linked by employee
ID, These different Sub Reports are for Phones, Computers, Pages and such.  I
have it set so if the sub report is null it does ...

I've tried following suggestions in similar posts, but I can't get them to
work; maybe my situation is different.
I want to creat a report that includes data from a drop down box. The only
fields in that table are ID and Department; my form works just fine with

Here is the code I have.. I am looking for a way from a dynamics table
to have dynamics columns
Private Sub Report_Open(Cancel As Integer)
Dim Rst As Recordset, f As Field, i As Integer, x As Control

I have a report that shows all employee data for all employees. What would be
the best way to take that report and create a new report that only shows an
individual employees info. For example, enter your name and/or id and the
report shows all your info but you can't  see anyone ...

I am trying to automate some of my reports. I have a report which will send
via email to a distribution list on the 1st Day of every month. What I need
to do is tell my query that the report is based on to only take data from the
last full month. Here is the criteria I am trying ...

I am creating an report in access and am having difficulty in summing
an expression in a column.
As my report is in columns when I created an expression it sums the
entire row for the fees instead on the entire column. The below is

I am printing a report,  on the On Close event of the report I have.
Forms!frmReportDates.Visible=True
After the report prints the form doesn't appear.
I am not previewing the report before I print...

I have a Main report with 4 subreports.  The four subreports have a master
and child link.  On my main report, I am using VBA code to update four text
boxes on the main report to different values that that want the various
subreport to link.

The following DLookup-function only returns a syntax error message in the
controlsource of a textbox in my report:
=DLookUp("[clientname]","[clientregister]","[clientID]=1")
In the immediate window in VB-code, the function gives the expected result,

Hi.  
I have 3 reports based on the same query which is used to calculate charges.
Each report has its own query to display the charges grouped in different
ways - By Customer, by Customer "Owner" and the 3rd by Customer "Owner" and

Can anyone shed light on why sometime when I print preview a report and
maximise it in code, all the Maximize, Minimize and Close buttons are missing
from the report window?
This really screws up the MDI nature of Access if you have to close each

I am trying to create a report which has Cash Contributors on one side of the
page with In-Kind Contributors on the other side of the page !! (Side by side
each other)
I have all the information i need in the same query.

I have a strange issue where the subreport of a report just does not show up
after my app does a relinking.
What I do is that the app checks a UDL file to see if the name of the server
changed since last it was run and if it did it recreate the links by

I have a table that when I run a GROUP BY query on it, it only groups up to a
certain point, then it returns ungrouped data. This has me completely
bewildered. At
some point I removed the primary key from this table (for unrelated reasons)