single space
how do I get my reports to print single space instead of double space?
Thanks,
Tina
| | 0 | 13 | 11/11/2009 4:41:12 AM |
Return Desired Value in a Text Box
Let me see if I can explain the structure before the question ...
The table named TblLeads uses two fields, LeadsBy & AssignedTo, which are
List Box lookups from the table named T | | 0 | 9 | 11/11/2009 3:38:30 AM |
Missing Information in Query - HELP
I am new to access have had a little training but just can't figure
out what I'm doing wrong here.
My database is built of off basically two tables, one an "Employee
Informat | | 0 | 11 | 11/10/2009 9:20:31 PM |
Error sending report as pdf attachment
I am using Access 2007 and Windows 7. I have a report in print preview and
select email...and select pdf format. I then get a message, Before
attempting to send an e-mail message from Bo | | 0 | 4 | 11/10/2009 7:24:51 PM |
Parameter query / check box..
i have created a small address book in ms access. using parameter
query i'm able to get the required address and able to print..
But i have sometimes 10 or more for that i have created a que | | 0 | 10 | 11/10/2009 5:40:41 PM |
Lookup value in table from value in report query
Hi Informed people,
I have been reading the forums but can't find a solution to make my problem
work.
I have a query with the following code
SELECT Left([Nat_Reg | | 0 | 7 | 11/10/2009 2:50:15 PM |
Seating Chart
Hi,
I want to make a seating chart report for my student's finals testing.
I have an Excel spreadsheet with each student's name, their room number, row
number, seat number. | | 0 | 14 | 11/10/2009 2:16:10 PM |
Multiple Records in One Report
Hi all i have a report that combines multiple areas of my database and puts
them in one report linked by the Product ID. However on some areas such as
Product Maintenance there are more t | | 0 | 7 | 11/10/2009 1:52:22 PM |
Print First Character of 30 Byte Field on Report
We have an Access 2007 Report that current pulls many fields from a database
table.
We need to add one additional field to this report, but we only want to
print the first byte | | 0 | 13 | 11/10/2009 1:48:33 PM |
Testing
Testing
| | 0 | 13 | 11/10/2009 12:42:40 PM |
chart axis labels
My output report is:
WO# Inspection Type Number of Faults
1199 Pre Final 15
1199 Final 23
I need to insert a bar chart,x-a | | 0 | 12 | 11/10/2009 7:43:38 AM |
Page break within one line of text
I have created Invoice reports in Access 2003 that consist of the main report
with report headers and footers and page headers and footers and subreports
within the body of the report. The | | 0 | 12 | 11/10/2009 7:43:35 AM |
Migrating from Word mail merge to Access Reports
Hi folks,
I'm trying to help convert a fairly cumbersome MS Word<>MS Access mail merge
process to an "all Access" solution. The office has several packets for
clients that con | | 4 | 77 | 2/6/2008 7:51:54 PM |
Weird problem with reports !?!
I had a user contact me saying she can no longer print reports in a database
(gets 'open was cancelled' message). All was fine until yesterday. Systems
did something with printers but no-one | | 0 | 81 | 2/6/2008 7:51:02 PM |
Expression error
I'm getting the following error:
This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
| | 0 | 71 | 2/6/2008 7:41:01 PM |
report not align
I use DoCmd.SendObject acSendReport to send out my email by email using rtf
format.
My report looks OK when I open the report at MS Access.
There is one line, always that line, | | 0 | 74 | 2/6/2008 7:34:05 PM |
Suppress print using code, how to get rid of white space?
Hello,
I asked and received the below advice for how to print a set of labels
one-time only, below the page header.
This code does do that. But, it leaves all the white space r | | 0 | 94 | 2/6/2008 7:22:01 PM |
Compare 1st qtr this year to 4th qtr last year
I have created a report that compares production data from one qtr to the
previous qtr.
It is based on a crosstab query that sums the production numbers by qtr. I
have a parameter | | 4 | 64 | 2/6/2008 6:46:03 PM |
How do I get rid of blank pages in a report?
Could anyone tell me how to have my report print only where there is data and
not to print out blank pages?
Thank you.
| | 3 | 91 | 2/6/2008 6:25:32 PM |
Develop report in MSAccess
I have basic knowledge in MSAcess.
I would like to develop a software for report of purchase order. Just
assume the report will be single page or multiple page (depends on the
capaci | | 1 | 64 | 2/6/2008 5:25:01 PM |
Suppress printing of Subreport on the next page of the same group?
I am trying to print a summary page (subreport) followed by details. When it
overflow to the next page, I do not want the summary page to appear again for
the same group. How can I suppress | | 4 | 82 | 2/6/2008 5:19:53 PM |
How do I calculate checked boxes in a report or query?
I have created a table and a form with yes/no checked boxes, now I'd like to
make a report or a query and in this I'd like to calculate how much was done
(according to a checked box) from a | | 7 | 63 | 2/6/2008 5:15:07 PM |
Microsoft Office Document Image Writer
I would like to use this printer driver to save a TIFF file of an Access
report I have in a 2003 application that I am using. However, I do not want
to be prompted for a file name but would | | 4 | 173 | 2/6/2008 5:14:39 PM |
Email a report in Access 2007
I can't email/publish/save_as a report from Access 2007 unless I use .snp. I
downloaded the pdf/xps add-on from MS but when I go to publish or email I get
an error message. It basically says | | 4 | 78 | 2/6/2008 5:13:21 PM |
Resize Reports?
Hello All.
I have some reports that I need to add fields to. Currently, they are one
page wide exactly, and when I want to insert another field it grows to two.
So, I need to manual | | 1 | 72 | 2/6/2008 4:50:17 PM |
Strange equation behavior
Hello
I am calculating overtime hrs on a report but running into a bit of a
snag. On my report i have a text box ( PayPeriodHrs ) which is populated from
a Pay Period Selection f | | 1 | 69 | 2/6/2008 3:16:06 PM |
Page Setup Not Working - Help?!
I have a report that is a legal size document and everytime go to page set up
and set it to "Legal" - the print preview is always letter. When i got back
to page set up it reverts back to le | | 2 | 88 | 2/6/2008 1:23:46 PM |
Access - Subreport totals
I have a report with about 5 or 6 sub reports. In the main report
footer, I am totaling various pieces of data with no problem
EXCEPT...the results that I'm getting, although mathematically | | 1 | 87 | 2/6/2008 12:35:58 PM |
Multiple criteria for "Is visible" property
The following is part of a report page in Access 2000
I have a text box called ?txtgroupcount? with a control source of Count(*)
in Groupheader0
I also have the following in the | | 3 | 57 | 2/5/2008 11:19:08 PM |
How can I make my Headers print on all pages of my report?
Could anyone tell me how I can have the header of my report to print on all
of the pages of the document and not just the first page?
Thank you.
| | 2 | 107 | 2/5/2008 11:07:03 PM |
Running Reports
Hello all,
I've created a report that has the information that I've selected in it and
everything is fine. But there are times I need to print out one persons
statement instead of | | 2 | 65 | 2/5/2008 10:24:28 PM |
Record count based on status
I need to write a query that will yeild a report that counts the number of
projects based on date fields. For example: a project might be in an
upcoming status based on 1. first record dat | | 1 | 74 | 2/5/2008 10:17:14 PM |
Creating a calculation based on a grouping
I have a database used to record invoices (vendor, date, number, service
period beginning and end, amount, etc.). My report shows the records for a
specific time frame. (In the database, t | | 0 | 71 | 2/5/2008 10:16:07 PM |
Conditional Printing of Certain Fields in A Report
i need to have a conditional printing of some fields (SEE BELOW)
VENDOR SHARE $999.99
LESS TAX $999.99
country ENGLAND
tax (%) 20%
AMT DUE $999.99
| | 5 | 76 | 2/5/2008 5:12:31 PM |
error message with DCount function
Hi there
I get the message "the text is too long to be edited" when I enter a DCount
function in the control source of a text box in a report. It only has 2282
characters!!!
What is | | 6 | 115 | 2/5/2008 3:22:01 PM |
Want to create a database and report of purchase order
I want to create a database in msaccess for purchase order. How to do that?
I have basic knowlege of msaccess.
| | 0 | 60 | 2/5/2008 12:14:00 PM |
NZ #Error on report
I don't use Access reports very often, so please excuse the stupid question.
I have several controls that are (or should be) showing numeric values on my
form. However, if the field is null | | 7 | 74 | 2/5/2008 12:11:06 PM |
Snapshot Viewer vs. Word
Hi...
I have a button that, once clicked, opens a report in an email attachement
(I created this through the standard wizard)
Anyway - once clicked you get prompted for the form | | 2 | 65 | 2/5/2008 12:01:54 PM |
calculated fields in Cross tab reports
I have successfully created the calculated fields that I need for my report
to sum the columns but now I need to divide one field by another to get a
percentage in the rows (which I have als | | 2 | 73 | 2/5/2008 2:09:00 AM |
One-time set of text boxes UNDER page header?
Access 2003, XP SP 2
I have a report, grouped by alphabet.
I need one set of instructions BELOW the page header, on the first page
only. Same for end of report.
Like t | | 5 | 66 | 2/4/2008 10:49:04 PM |
Report update txt box on open
Hello
I have a report used to calculate project hours. I also have a form that is
used to set the Payperiod start, payperiod end, and total hrs in the
payperiod. My report has nop t | | 0 | 73 | 2/4/2008 10:11:03 PM |
Passing Qry as part of Rpt DoCmd.OpenReport
If the selected manufacturer = "_All" first value in list, then my query
sQry = "Year = " & ddlYear.Value
else: sQry = "Year = & ddlYear.Value & " and manufacturer = " & ddlManu.Value
.... | | 7 | 60 | 2/4/2008 9:12:01 PM |
Dlookup Help
I am using the following DLOOKUP string.
=DLookUp("TXTFIELD","Query3","Query3.CustomerNumber=" &
"[CustomerNumberFromReport]")
I am try to use the Dlookup to use a value that I | | 5 | 100 | 2/4/2008 8:33:36 PM |
Create multiple reports using macros
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 | | 3 | 76 | 2/4/2008 7:32:01 PM |
Snapshot Viewer
Can you search for text in Snapshot Viewer? I don't see Search listed under
any menu and F doesn't work.
I'd like to convert a number of Access reports from .pdf to .snp files, | | 1 | 81 | 2/4/2008 7:21:05 PM |
Convert Number To Barcode
Hi,
My Project is in MS Access.
I want to generate barcode for Number.
Like when I enter number in textbox and click on button then it will
convert that no to barcode.
is it possib | | 3 | 78 | 2/4/2008 7:08:58 PM |
Running Sum + initial value
Hello everyone,
I have a report that almost works. I am able to create a running sum
easily, but my running sum needs to also include an initial deposit amount,
is there a way to d | | 3 | 108 | 2/4/2008 7:00:02 PM |
Inventory Report
I have been fighting with various methods of reporting an inventory count.
One method I can't seem to figure out is how it is done in the Microsoft
template:
http://office.microsoft.com/ | | 0 | 83 | 2/4/2008 6:51:02 PM |
Totalling records in a date range
I have a report that shows sums of various fields, grouped by date. If i run
my report based on specific dates for example between 1/1/2008 and 1/5/2008,
each date is displayed as a page in | | 1 | 69 | 2/4/2008 6:43:01 PM |
Form Filtering Help
I have a report that is fine and set up the way I want it. Now I need to
create a form to filter or select records in my report. I am struggling to
write that code. What I would like to do i | | 8 | 64 | 2/4/2008 5:31:13 PM |