im my report there is a subreport, my subreport shows records, for some
times that my records in subreport are less part of page will be white, i
want to fill up rest of subreport by border, i have used the code like below
but it does not work for subreport and just work for ...

Why would the rpt control =nz([TotalPaid],0) produce #Error on one Access
report, but work correctly in another Access report in the same database,
using the identical table of data?  In fact, the report in which this
expression produces #Error is a copy of the report in which it ...

I've created a small database to manage contact details for a vintage car
club.  It uses only two tables: one for address and contact details and a
second for the cars each member owns.  The tables are called tblMembers and
tblCars.  I also have the forms frmMembers and frmCars ...

I am creating a report which generates all the invoices for a specified
period of time.  I have set each company's invoice to appear in the Page
Header and want to include a field which will show the invoice number.  When
the report is run, I want to be able to enter the last ...

I have a form with a tabbed form.  Each tab has command buttons on it
and also contains a subform.
I call a report from the command buttons.  My problem is when I close
the report, focus is returned to the header of the main form which

I have a report runs off a query and a form for users to enter the criteria
into pull this report - so far everything is working good.  I have 2
textboxes so the users can enter the from date and end date in this format
(mm/dd/yyyy).  but some of the records don't have from date ...

I am a desktop support tech and not an Access expert. A database
administrator I support just submitted a ticket saying that when she prints a
report there are some missing data (parts of a table).
1. The problem shows up in Print Preview as well as on the printout.

Ok I've look and for some reason I cant find.  Maybe because its so simple
it's never been asked... :-)
I have a report that is grouping by "nature" then by "department".  I need
to count the total number of items in the group "departmet".  I've tried

I've looked at a few previous postings for this answer, but I can't seem to
get it to work.  I have this in my control source:
=DateDiff("yyyy",[Hire Date],Date())
Which gives me just the year, but I would like to know years and months.

I just started using the Lebans ReportToPDF (Access 2003) and it's working
fine except I noticed an interesting situation...
When I use the option to have the FileSaveDialog shown, and when the user
enters the file path / name of a PDF that already exists, no warning occurs

I'm trying to create 2 check boxes for Yes and No which I'd like one to be
checked automatically based on the report.  I'd like the check box for yes to
be checked if there are records for the report.  If there are no records, I'd
like the No box to be checked.  

I am trying to use the following code in the Control Source property of a
text box to calculate the sum of entries made between specific dates.  The
dates are fed from a user input form to an update query which puts the two
dates in a table that is read by two text boxes in a ...

I have a table, with a P.K. auto-assigned by Access.
Table is for books on order and there is a field called ISBN.
I have a query built to pull up a record by ISBN.
I have a form built upon this query where again I key or scan in the ISBN of

I'm looking to limit Access Report output to only those columns which
returned a value

-- Hello:
I am having a little problem with ACCESS 2007 and I hope someone can help.  
I’m new with Access 07 so I’m hoping that I just did something wrong that is
easy to remedy.