|
|
Report does not always have Data by
Alan
1 ) I have a table that gets data loaded into it from another program (Data
is there)
2) I have a form which displays this data as well as some extra...
|
|
3 |
57 |
|
|
Deleting Fields From Report Programmatically by
Alan B. Densky
I have an A 2000 database with a unique report. Each time the report is
run, it only displays data from one record in the table. It has dozens of
uniquely...
|
|
2 |
187 |
|
|
copying database changes page setup by
Alan Bornat
Whenever I make a copy of the database (using Windows Explorer drag and
drop) my report page setup changes from landscape to portrait. Is there any
way I can...
|
|
1 |
106 |
|
|
Print failure to HPLJ2300n by
Alan C
Two workstations have HP Laserjet 2300n PCL5 as default printer via tcp
ports. When trying to preview or print a report from a Access dbase nothing
happens,...
|
April 28th, 2005 01:18 PM
by Alan C
|
0 |
88 |
|
|
Trap for #Error by
Alan Fisher
I have a field that adds two other fields. When one or
both of the other two fields are null I get an #Error in
the block as Expected. I would like to trap for...
|
|
6 |
135 |
|
|
Print preview by
Alan T
Hi,
I tried to print a particular repor with one employee only.
It works here with preview:
DoCmd.OpenReport "rptInvoice", acViewPreview, , ". = " &...
|
June 7th, 2007 09:09 AM
by Alan T
|
0 |
53 |
|
|
|
June 7th, 2007 10:44 AM
by James
|
1 |
56 |
|
|
Open a report with parameter by
Alan T
I got a report link to a query:
SELECT * FROM Employee
WHERE EmployeeNum =
How do I open this report from a form using Visual Basic and pass the
parameter...
|
June 7th, 2007 04:19 PM
by fredg
|
2 |
57 |
|
|
Newbie - display query results by
Alan T
I want to display the result of a query:
SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee
What control I should put onto the detail band...
|
|
4 |
96 |
|
|
|
|
1 |
70 |
|
|
Chart Software for Access Reports by
Alan Z. Scharf
Hi,
Are there other chart software papckages that will integrate with Access
2003 .ADP in the same way that MSGraph does, i.e. that can be added in as
an...
|
|
2 |
58 |
|
|
Check if Report being opened as Subreport by
Alan Z. Scharf
I'd like to programmatically check if, when a report is opened, whether it
is being opened as a standalone report or whether it is a subreport, ,
i.e.
whether...
|
|
5 |
67 |
|
|
Saving Page Setup for different machines by
Alan Z. Scharf
1. I have a series of Access 2003 reports saved with
Specific Printer : Adobe PDF
All Margins: 0
Page Width: 8.0
2, However, when I transfer app...
|
|
4 |
108 |
|
|
Count Paragraphs in Text Fields by
Alan Z. Scharf
Hi,
I would like to calculate the number of paragraphs in a field comprised of
text?
The data is in SQLServer and I have both RTF and plain text columns of...
|
|
3 |
92 |
|
|
MSGraph Help File? by
Alan Z. Scharf
Is there an MSGraph help file anywhere in an Office 11 installation?
Thanks.
Alan
|
|
4 |
58 |
|
|
Chart ScaleFormat Doesn't Change by
Alan Z. Scharf
Hi,
I'm having a reporot print in a loofp for different stock symbols.
I need to have the X-axis number on an MSGraph horizontal bar chart, which
is...
|
|
0 |
49 |
|
|
UCase not recognized by
Alan Z. Scharf
Hi,
I have used Ucase in several reports in an Access 2003 ADP with SQLServer.
Example: =UCase()
All reports work fine on my system. However, on clients...
|
|
2 |
94 |
|
|
|
|
0 |
63 |
|
|
MSGraph: Setting X-Axis Major Unit Values by
Alan Z. Scharf
Hi,
1. I have an MSGraph area chart in Access 2003 report with Years as the
X-Axis.
2. I want to set the X-axis scale for the Years column value which is in...
|
|
2 |
115 |
|
|
|
|
6 |
65 |