|
Labels
Is there a way to specify a row number and column number on a label to be
printed?...
|
2 |
10/14/2008 11:21:02 PM |
|
|
Printer Dialog
I currently use an icon on the form to print the report directly to the
default printer. But because there are so many printers, not all users want
to use their default printer. I want to automatically bring the printer
dialog (the standard one that we see in Office) and let the user choose which
one, instead of sending it to the printer directly using the following code:
DoCmd.OpenR...
|
5 |
10/14/2008 9:43:01 PM |
|
|
"Dynamic" XY Scatter Plot
Hello,
I'm working on creating an xy scatter plot using 2 combo box selections
representing X and Y coordinates.
In this one form, I have two combo boxes representing, X and Y, that contain
a number of variables: density, elastic moduli, strength, etc. I want the
user to be able to pick two different variables and plot them. For instance,
the user can pick Density for the X vari...
|
1 |
10/14/2008 9:22:01 PM |
|
|
memo field getting truncated
Hi All
I have a weird one here.
I have a database project that is spit. The presentation layer is using
Linked Tables to the data layer.
In one of my tables I have Memo field that typically holds a rather large
amount of text per record. Then I have a report that is powered by two
queries. A query of a query actually. For some reason when I run the report
as well as the query (if ...
|
5 |
10/14/2008 5:40:27 PM |
|
|
Decimal places in a calculated Text Box
Hey guys,
It's been some time since I have had to come to the Community because
of a problem but I have run into a bit of a puzzler.
I am trying to get the Average Width and Length to print out on an
Access Report desplaying four decimal places. The user Form saves the
width/length to the table just fine, (four decimal places). My Query displays
the Cells as four decimal plac...
|
10 |
10/14/2008 4:48:01 PM |
|
|
How can I put page breaks into an Access Report based on header?
I have created a database for scheduling 8 different facilities. I would
like to create a "reservation book" report in which each of the 8 facilities
will print on 2 pages (4 on each page) face to face like a book and have the
report page break weekly, so that each week will display the 8 facilities.
Is this even possible?...
|
2 |
10/14/2008 3:37:01 PM |
|
|
Error opening report
Using Access 2003, SP3. I have this code when a button is clicked:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
When this line tries to execute, I get the error "You canceled the
previous operation".
I've tried compacting/repairing to no avail. Also, this access
database runs on 25 other computers and has no problems with this line
of code. Something on thi...
|
5 |
10/14/2008 3:04:04 PM |
|
|
data not showing correctly on labels
Hi, I have a problem with making labels on access 2003. I've created a
customized label size for my label, and after I run through the label wizard,
the data is not showing up correctly on the print preview. it is displaying
records on every 3 labels, instead of label after label. can someone help me
solve this issue. Thanks! :)...
|
2 |
10/14/2008 2:54:00 PM |
|
|
Can you produce a report using a calendar format?
I am looking to take multiple dates from many records and produce a report
that looks like a calendar that will show the date, day of week as well as
information from 4 different tables that define a date in a mm/dd/yyyy
format. Is this possible?...
|
2 |
10/14/2008 2:52:05 PM |
|
|
Report Header Not Printing
I have Access 2003. On a single task, up to 5 reports will be previewed.
When sent to a particular color printer (HP 4700 N), some of the report
headers are not printing. They are pretty much identical reports to one that
does print the header. In my printer/faxes console, it says the driver is
for a HP 460 PCL6. Would this cause the problem? If I print the reports
directly rather ...
|
2 |
10/14/2008 2:49:32 AM |
|
|
Prnting problems
I set up a report to print tickets that are 3.66667" high (3 to a page) and
I need to to print them with Epson DFX--9000. The first page prints fine but
the next pages are off because the printer add the margin to the top and
bottom. I cannot zero out the margins, is this an Epson driver problem or
design. Can anyone help me to put zero margins on the report and zero margins
on the printer? ...
|
3 |
10/14/2008 2:11:35 AM |
|
|
Text being clipped in reports
One of my text fields in the report (control source 'memo' field) gets
clipped. I tied using 'Can grow=Yes' but that didn't help either. Can
this be rectified?
Thanks in advance for any help.
ST...
|
5 |
10/13/2008 11:38:34 PM |
|
|
ReportToPDF from www.lebans.com Wrong Fonts at one site only.
Hi All,
I am using Stephen Lebans great utility to convert snapshots to PDF in
access 2000.
This has been working fine at a number of places, but at one branch using
exactly the same access ADE as everywhere else, the PDF files they create
there contain HELVETICA fonts which are much bigger than the original
reports so the fields are being cut off in the PDF report.
I also checked the c...
|
1 |
10/13/2008 11:08:17 PM |
|
|
detail formatting
how can i change the fill color for the detail line every other line - from
no color to gray?
tia,
mcnewsxp
...
|
2 |
10/13/2008 9:47:48 PM |
|
|
How do I make columns on a report?
I have a fairly long list of dates that take up a great deal of space. If I
can display them in columns, it will make me very happy because I won't be
killing trees. How do I do it?
--
Thanks for your time!...
|
7 |
10/13/2008 7:59:37 PM |
|
|
Slow Access Report over Citrix
We have an Access file, used solely for reporting purposes, that is linked to
our SQL Server db. The end users get to the Access file over Citrix with the
file itself located on a network share. I also have a copy of the Access
file on my "home" network location. I'm running into a problem where when
some of the reports are run via the Citrix path, they appear to hang but when
I run t...
|
1 |
10/13/2008 7:22:08 PM |
|
|
Replace grey background behind Access Report with colour
I am currently using Stephen Leban's SetMDIBackground to make the colour of
the Access window the same as the detail section of my forms (a pale blue).
However, the background of a previewed report remains grey.
Is there any means to get at the window in which the report preview is
displayed, to reset its background to something other than grey?...
|
1 |
10/13/2008 11:24:00 AM |
|
|
Omega Constellation Ladies Watch 1277.10
Omega Constellation Ladies Watch 1277.10
Discount Watches Site : http://www.watchespage.net/
Omega Constellation Ladies Watch 1277.10 View Full :
http://www.watchespage.net/Omega-Constellation-Ladies-Watch-1277.10.html
Omega Constellation Ladies Watch 1277.10 AdditionalInfo :
Brand : Omega Watches ( http://www.watchespage.net/Omega-Watches.html
)
Gender : Ladies
Co...
|
1 |
10/13/2008 8:33:56 AM |
|
|
Right Function in a Report
I need to format a report to show only the last four digits
of a social security number. The field is "SocialSecurityNumber" and the
format is
xxx-xx-. I run invoice reports at my job and for specific companies i need to
only show last four numbers of ssn. I tried the following code in Private Sub
Detail_Format.
if me.billingid = "10016" then
Me.SocialSecurityNumber = "xxx-xx-" + R...
|
2 |
10/13/2008 2:54:44 AM |
|
|
Parameters Expression In A CrossTab Query
I am trying to restrict dates [TransDate] in a crosstab query. I have tried
the following expression suggested by a community member but it ignores the
parameters -
PARAMETERS [Start Date:] DateTime, [End Date:] DateTime;
TRANSFORM Sum([PLINV&EXPPart2].Amt) AS SumOfAmt
SELECT [PLINV&EXPPart2].TransDate
FROM [PLINV&EXPPart2]
GROUP BY [PLINV&EXPPart2].TransDate
PIVOT [PLINV&EXPPart2].Deb...
|
5 |
10/12/2008 11:02:01 PM |
|
|
Email Rprt (or records) from Access 07 to individuals via Outlook
I currently have a query that pulls records for accounts with missing
information. The fields are account rep, account #, client, address, phone,
fax, account rep email. Each account rep is listed multiple times since one
rep can handle multiple accounts. I want to be able to send each account rep
his own list of accounts that are missing information. For example, Rep #1
would receiv...
|
5 |
10/12/2008 8:50:43 PM |
|
|
LINKING 2 UNCONNECTED SUB-REPORTS
i have a monthly sales report and a monthly expenses report - both totally
unconnected.
In order to show them side-by-side, I have created an unbound report with 2
sub-reports which display only the Date Footer and Report Footer from each
report so in effect it looks like this -
EXPENSES SALES
October 100 .00 October 200.00
November 10...
|
7 |
10/12/2008 7:36:00 PM |
|
|
Outputting to Word
Hi everybody, here is my dilemma. I have a form with a command button to
output a report, my goal is to output this report to Word. Is there a way to
modify my code to automatically set my report to output as a word doc? I
have it formatting as RTF, but if there wa a way it could just go right to a
word doc and skip the rtf step that would really make my life easier. Not
that an easy...
|
2 |
10/12/2008 12:40:01 PM |
|
|
Publish It with Microsoft Word
I have created a database where I would like the end user to be able to
"Publish It with Microsoft Word" where they can cut and paste a portion or
all of the report but I am not sure how to do this. I can preview but I can
not cut from a preview. Any suggestions? Thank you all in advance....
|
1 |
10/12/2008 12:23:01 AM |
|
|
Reducing line spacing in subreport
I have created a report with several subreports. The subreports print with
too much space between each data line (appears double spaced). I need to
macke this single spacing to allow room for all data to print in my 2 page
limit. How do you adjust line spacing in a subreport?
...
|
5 |
10/11/2008 11:49:26 PM |