I have about 20 different reports that have to be ran each day.   The reports
require one input parameter from the use, Enter_Date.  The Enter_Date
parameter is the same for all 20 reports.
Can I automate this process allowing the user to enter  the Enter_Date once,

I'm using Access 2003.  I have to draw vertical lines to separate fields in a
report.  I'm using the following code in the detail print event:
Me.Line (10.875 * 1440, 0)-Step(0, 20 * 1440)
The "10.875" represents how far the line begins from the left side of the

How to create msaccess report of purchase order?  Shall I do this form
in form and subform system?  I think then only I will get the report's
purchase
item under form.  Please tell me.

Given these text field inputs:
=[text68] & "       MOM  " & [ba] & " Bath(s)"
Is there a way to have a new sentence start on a new line between text68 and
Mom; and then have a new line to begin the ...[ba]& "Bath(s)"  ...sections?

Access 03/WinXP
I am using a function to generate an SQL statement based on several
user-defined filters from a form.  This SQL statement is used as the record
source in the OnOpen statement of the report property.  I have no problems

Where, under which event, may I dynamically change the font specified for a
report element?
In production, my application needs to print bar codes using the 3 or 9
code.  Under development, however, we want plain language to assure the

I'm running a report on how to split up the fee for a band.
Because all members of the band aren't equal (eg road crew work on a fixed
fee) I have a code allocated to each member.
Members

My Project is in MS Access.
In that I am using one form for Shipping Entry.
In That I put One Check Box.
Now If Shipping Address and Billing Address Are same than I click on

I have a table "TblRates" Im want to make a calculation on my report based on
this table.
Example:
The report total is $35000 I need it to look in the table and bring back

My database has one table, tblPlanData, with Fields: CustID, ProbItemNo,
CallDate, and CallNote (Memo). I would like to run a Report for One CustID
that shows only the most recent CallNote for each ProbItemNo.

I have a database where I keep track of invoices.  Some of the fields are:  
Vendor, Invoice #, Invoice Date, Service Period, Service Period End, and
Amount.  The Service Period is entered as 1/02/2008 (for example).
I have created a report which includes all of this information. ...

each time i run the following code :
   Cond = "OwnerID =" & OwnID & " and " & "ID =" & TransID
   DoCmd.OpenReport stDocName, acPreview, , Cond
it returns all the table records !!!!

There is a report that I would like to run monthly for about 90
individuals and I want each individual to get their own report.
Clearly, I don't want to run the report 90 times.  I assume that I
need a macro to do this, but have no experience writing macros.

I have a database with a table for customers and a related table with their
different addresses.
The addresses have a type field: a number that corresponds with a table
addresstypes:

Is there a way to multiply a count with a dollar figure? I have done a count
on a field with a text box (counting number of tickets). We have a $.75
surcharge per ticket and I would like to get a total dollar figure for this
surcharge. Thanks.