The problem is, none of the fields are available for me me to select to
create the report ... it's blank. When I try to create a report using design
view, the pop-up box for parameter I set keeps coming up everytime I try to
move a field onto the report.

I am using Access 2002.
I have a report with a GroupHeader0 with subtotals in it.  I would like to
make this header's Format / Visible property toogle between yes and no, based
on the value in a field SECTION_CODE.  If SECTION_CODE = "01", then Visible =

Access 03, WinXP.
Occasionally we group staff and students into different teams.  The team
names (all colors) remain the same.  We then print out reports (name tags)
where the person's name is in the color of the team name.  Is there a way to

I have a program that automatically opens a report after generating the
information.
The report is opened for preview and works fine at this point.  However the
program is not done yet.  I want to give the user the ability to look at the

In Access 2003, suddenly all of my settings: indent, grid size, margin
width, ruler, everything has changed to metric.
How can I get them to go back to inches?
Thanks

I have a report (rptRepairRequest) that I have command button that
prints it out from a form based on the ID of that form.  This works
fine.  What I would like, and not sure if it is possible, is to have
another form where I can just select the ID from a drop-down and open

Have report containing numerous text boxes, combo boxes, subreports, report
and page headers.  CanGrow and CanShrink properties (for sections, text
boxes, subreports) set to yes.  KeepTogether properties for everything set to
no.  No grouping.  When printing some records, get ...

I am trying to add a summary to sub report to a report when  I place the
report in the Report footer only  3 of the records show there should be 5
records I also tried  making the summary in a report by itself I get the same
results 3 records when there should be 5, anyone know ...

I have an inventory database (in Access 2007) that calculates the Beginning
Inventory, # Cards Sold, # Cards Purchased, and Ending Inventory. I have a
query that pulls the # Cards Sold, # Cards Purchased, and calculates the
Ending Inventory based on the date parameters given to ...

I have created a report where one field the user chooses individual or unit
then a separate field that states number.  Is it possible at the bottom of
the report for me to run a calculation that would say sum all the records in
the number field for those who are individuals?

Anyone any views on the best to draw a horizontal line so that it also
appears in the exported document. To me it appears that it has to be a
series of dashes '-', but thought I would ask here in case I am missing
anything!!

Help please!!
I have a form previously created and I need to increase the height of the
text boxes to give the user more room to enter and view all their data.
The form design view will not allow me to increase the height of the fields

I have a pie chart that is using 1 field (checkbox yes/no field) to show how
many are Yes and how many are No. Every time the legend displays it shows a
-1 or a 0. I edit the legend and in design view the report looks exactly like
i need it BUT when i switch to print preview it ...

I have a query that my main report is based upon and then I have inserted a
graph which runs off of a query.  However, I want the graph to change
based upon the LastName field but it won't allow me to do that.  I keep
getting the following dialog box when I try to link child to ...

My bar chart is working nicely in the report that I created.  However, I
would like a little more detail on the Y axis.  Currently, the labels show a
supplier name but I would like to be able to have both the supplier name and
contract number show for each spot on the Y axis.  My ...