Alternating Printer trays In Access Reports
Fri, 26 Sep 2008 07:22:00 -0700
I have a report that needs to print a 2 pages each for a mass mailing. These
are similar to invoices for customers and there are close to 20,000 records.
We will be using a Xerox docutech printer so the amount of records is not an
issue.
However page 1 and page 2 (of the invoice for each customer) needs to ...
|
Barcode Scanning
Fri, 26 Sep 2008 07:18:07 -0700
I have a barcode font that needs "*" in front and behind the data to work.
If I have a report that has a Name and control source of "PN", how can I add
these easy?
Thanks, Aaron ...
|
Seeking the associated printer
Fri, 26 Sep 2008 01:46:01 -0700
Access seems to be looking for the associated printer for a report. This is
fine when at work, but it can take 5+ minutes just to rename a report whilst
at home.
Is there a way to disable this 'I must find the printer' behaviour?
Thanks. ...
|
report with two one-to-many relationships
Fri, 26 Sep 2008 07:17:38 +0200
Hello,
I have three tables: persons, telephone_numbers and email_addresses. They
are connected one-to-many:
- one person has many telephone numbers,
- one person has many email addresses.
I want to create report, which will show persons and for each person will
show his telephone numbers and email addresse ...
|
How do you sum based on calendar year that has multiple years?
Thu, 25 Sep 2008 22:04:02 -0700
I have a DB that has dates that I want to sum up by year. I was trying to
use the IIf and DSum command together. Is there another way or how do you
imbed the DSum function in the IIf function? ...
|
I can´t find the grouping and sorting feature
Fri, 26 Sep 2008 03:32:15 GMT
Ok, this may sound a little crazy... but I have written some reports in my
Access application and I now need to group some reports BUT I can´t find and
therefore use the Grouping and Sorting feature... anywhere!?! It doesn´t show
up as an icon, nor is it available in the View menu. I´ve tried creating new
tab ...
|
Send To HTML Mail Fails Sometimes
Thu, 25 Sep 2008 13:38:01 -0700
I have several reports generated off queries. When I use the Send To feature
with the HTML format, some reports correctly embed the report into the
e-mail, some reports embed as .xls attachments. Believe me, I have changed
every format option, etc. that I can think of. Any ideas why some work
correctly an ...
|
|
|
Using Date parameters
Thu, 25 Sep 2008 13:29:01 -0700
I have several tables with date fields in my database. I am trying to get a
summary report which gives totals (count and sum) into one report. How do I
do this where I can have the user only enter the beginning and end date one
time? ...
|
Line feeds not working with a report
Thu, 25 Sep 2008 12:40:31 -0700 (PDT)
I have a field in my table which is a memo field.
The data in that field has embedded Linefeeds.
I created a report (wide enough for my data) and the linefeed
characters show (empty squares) but they are3 not recognized either on
the scree or printed.
If I paste that very same data into ms-word, it shows ...
|
Sum If on Report
Thu, 25 Sep 2008 10:31:01 -0700
I try to create a report where I alredy group my report by reference number.
My querie include three diferents transactions types. At the end of my report
I want three line. Each line to show the sum of every different transaction
type.
This should be the formula in excel: =SUMIF(A1:B9,"TOPS",B1:B9) where b1 ...
|
