I have a switchborad that lets you search Hollywood movies by Names,
by Directors, and by Year.  But,  I want to add  Bollywood movies to
this database that will have the same search query; by name, by
directors and by year.    So, I was thinking if I could add something

I use a report that generates all invoices outstanding for an individual
customer.  I select the customer I want to report on from a dropdown list.  I
would like to be able to print the same report for all customers who have
invoices outstanding, not just individual customers ...

I would like to have a little form that filters by selection a particular
record, then have a command button that selects that record in a report and
then prints the record. Or is there a better way? I can get the form and
filter to work, but how do you do the calling of the ...

In my report (which is an invoice) if the Shipname, Shipaddress etc are the
same as the Name, Address etc on the invoice I would like to just show "Same".
Is there an Iif statement that will do this?

I'm trying to show a total count of the records in a report.  In the report
footer I have the function "=Count([pmocid])" where pmocid is a field in the
report detail.  Works fine until there are no records in the report.  Then I
get a "#Error".  I tried =Count("*") instead, but ...

Wonderining if you can help me with this issue. I have a database that I use
to record the quality of service my technical folks deliver to our customers.
Field managers travel with the techs to observe their activities on a typical
service call. Data is entered via a form that ...

I'm exporting a table into text format the problem is the alignment of
decimal points....
Here is an example:
Result should be:

Hiya folks!
In my report, I have a table that shows the following calculated
fields/number for each type of product sold in a restaurant (I
included a sample data):

Thank you in advance for anyone that can point me in the right direction on
this.  I have a query that combines multiple tables and queries.  Some of the
underlying queries have the same tables and use the same field.  In the query
that combines these, it runs fine.  However, ...

Cheers,
let's say we have a report based off a query, which would yield:
id  Part no    service performed  
10  ASDF      CLEAN

I want to select certain records to print at the end of a report.  These are
detail records and depending on an event number I want those to print in the
report footer.  Is there a way to do this, I was thinking that maybe I could
print a different report on the report footer ...

I'm just be aware that I have a problem with my DB.
Especially when convert my report to PDF by using
Mr.Lebans's code.I work with access 2000.
There are at least 4 four blank fields in my PDF report

Hi using Access 2003 is it possible to set a background pattern? That is, to
make fields more apparent is it possible to use patterns as colours are not
necessarily distinctive with black and white printers.
Any ideas or recommendations appreciated :-)

A97
I have a form with a command button to open a label report
The label report is based on a query.  If the result of the query has no data
because the criteria was not met, how can I prevent the label report from

What is the proper method to hide / show either sections or controls within
sections of a reprt through VBA. Some say use twips some say use strings.
What is the proper method and should I use twips or inches. My setup
defaults to inches.