|
Print multiple copies of a report with a sequential number of copy
Seeking EASY way to print a label (using report) that will print the same
information on 880 pages but sequentialy number the prints. Using a zebra
lable printer so each report is one label....
|
2 |
01.09.2006 08:35:55 |
|
|
How to update ListBox.RowSource property when printing
In a detail section I have a listbox whose rowsource needs to be updated by a
query string in the OnFormat event. The query selects records based on the
value of a product (the product is printed in the detail section). However I
get a message saying the rowsource cannot be updated when a report is opened
in preview mode or has started printing.
So how does a query dependant listbox wor...
|
2 |
01.09.2006 03:29:16 |
|
|
Access Reports, Multi Page Tif's, and Stephen Leban's Method
I have sql database that stores links to images of invoices in
multipage tiff's in the filesystem. I am using Stephen Leban's
wonderful code to display the multipage tiffs in access 2003
forms/reports.
A user has the ability to select a range of invoices (no pictures) by
multiple different criteria. The result is displayed in a continuous
form. A link from each record line will put up ...
|
6 |
01.09.2006 02:25:51 |
|
|
printing with RTF2 control from Lebans
I have a question regarding the RTF2 control by Stephen Lebans. I am
investigating using it in an Access 2003 report. It seems like a great
control, and it works very well until I try to print the report. During
the Detail_Format event, I set the value of RTFtext in the RTF2 control.
This works fine in print preview, but causes the following error to
pop up when printing or exportin...
|
7 |
01.09.2006 02:22:45 |
|
|
Keeping a section of a group footer together
I have a report with a group footer in it. The footer has several items in
it: a horizontal line, two lines of text boxes, a subreport, and then more
text boxes. Due to its size, this footer is often split over two pages, with
the page break occurring at various places in the footer. I'm trying to
ensure that the page break never occurs between the first two lines of text
boxes.
Can anyone...
|
1 |
31.08.2006 21:00:44 |
|
|
Date Function
I have a report that pulls the date from a table using a short date. I would
like to see only month and year. Can someone help?...
|
8 |
31.08.2006 20:31:02 |
|
|
Image
i captured an image from windows CE and stored in a sql server database, now
i need to displayin an msaccess report, but it will not display. all i get is
a blank box. i gust i need to play with the data something like
Dim myImage As Image
Dim arrayImage() As Byte
arrayImage = CType(Me.DataSet11.Tables(0).Rows(i)("Signature"),
Byte())
Dim m...
|
1 |
31.08.2006 19:49:02 |
|
|
Nz Help
Hello,
I have a main report that needs to add a field from a sub report. I keep
getting #error.
This is what I have on the Main Report to test for errors:
=(NZ([Blank Weekly subreport].Report!SUMOTRA))
This is what I have on the Sub report, which is Blank Weekly Subreport
=Sum(Nz([OT rate]))
I have tried every possible combination I can think of. Please help.
JC
Papi ...
|
2 |
31.08.2006 18:30:12 |
|
|
how to get a list of variables used in a form
I have several different forms which contain different variables from one
table. I need to create reports from each form. Is there an easy way to get
only the variables from a form into a report, or is there a way to get a list
of the variables used in a form....
|
3 |
31.08.2006 17:43:02 |
|
|
Report breaks on dynamic recordsource, but returns correct data
I'm working with a MS Access FE and a SQL Server 2000 BE. I have a
report in MS Access 2003 called rptMeetingsScheduled. After assigning a
variable to the appropriate date I want to display, I open the report
and dynamically assign the report's recordsource in the OnOpen event.
Below is the code that does this:
Dim strSQL As String
If IsNull(strRP1) Or strRP1 = "" Then
...
|
1 |
31.08.2006 17:11:48 |
|
|
Conditional Page Breaks
Hi
I have a report which works as a letter to an individual inviting them to
training. I have a page break at the end of the standard text. Our company
name and contact details sit in a text box in the page footer and a map to
our training location in the report footer.
There is a Report Activate event with a condition that shows the map in the
report footer if the training locat...
|
2 |
31.08.2006 17:05:38 |
|
|
insert access report to word
How to inport Access report in Word document as it is (with all headers,
data, colors, etc.)?...
|
2 |
31.08.2006 16:43:46 |
|
|
Filter property
Hi,
I am trying to run a report with a filter on the data using the property
window. The data is coming from a query named PCI.
The Record Source SQL is: SELECT PCI.FIELD_TEAM, PCI.[Net Merch],
PCI.[PCI/STI] FROM PCI;
The Filter is: ((PCI.PCI/STI)='STI-unroaded')
When I try to run the report, I get a pop-up with PCI.PCI and a text box to
enter a parameter.
I don't understand...
|
2 |
31.08.2006 16:22:52 |
|
|
Filtering report and sending each filtered report by email;records
I have tried over in over to set up a report to filter based on the method
recordset in VB from Access on the event procedure (onopen) of the report. I
am getting no where. I originally had the filter on the query that is the
record source of the report as a prompt for valule. Since I want no manual
intervention and I want the report to select each value automatically I
tried using r...
|
1 |
31.08.2006 15:56:02 |
|
|
filtering subreports
I have a main report and 3 subreports.
What I am trying to do:
I have a form with a dropdown box that lists items from a subreport so that
it will filter the subreport. Based on the item selected, once the user
clicks on a button, the main report should display based on the subreport.
Is there anyway to do this?
Thanks.
Ash...
|
1 |
31.08.2006 15:31:02 |
|
|
year-to-date count for multiple years
Hello. I am hoping someone out there can help me. I track homicide
data and run reports for police administrators when they request it. I
have data from 2005 and 2006. I want to be able to give them the count
of homicides by district to-date. So, today's report would give a
count of 2005 homicides by district from 1/1/05 to 8/28/05 and also of
2006 homicides by district from 1/1/06 to 8/...
|
11 |
31.08.2006 15:28:33 |
|
|
Change font formatting for part of a field in a report
I am trying to turn a letter into an Access report because some of the
records in the query are near-duplicates except for two pieces of data in
each one, which need to print as a list. The only problem is that in the
text of the letter, there is some text (the name of the show) that needs to
be bolded and also a url that should be underlined. How do I get this to
work in Access 2003 a...
|
4 |
31.08.2006 15:23:49 |
|
|
Generating Report in Access 2003
I'm using Microsoft Access Professional 2003 at my business and any time I
try to create a report or open a database that generates a report. It says
"There was a problem generating this form or report". That is the only
message I get and it just doesn't work.
I've completely uninstalled and re-installed office as well as fully updated
it. On our other office machines, access works c...
|
5 |
31.08.2006 15:22:33 |
|
|
asked for parameter
When I go to view my report it prompts me for the parameter value of 'Freq'
which is one of my field names. I have double checked it is pointing the
right place in the queries, tables etc and when the report shows it has the
appropriate information in it. How do I stop it prompting me for that
parameter?
...
|
8 |
31.08.2006 13:05:41 |
|
|
data errors when exporting to Excel
We have just started using Office 2003 and I have encountered a problem with
data being exported to Excel from an Access 2003 generated report. This
problem seems to be restricted to only a few codes.Below are the values in
question.
00A shows up as 0.04166667 in Excel
03A shows up as 0.125
05A shows up as 0.208333333
00P shows up as 0.5
00A shows up as 0
Before you say it, the column ...
|
1 |
31.08.2006 12:47:02 |
|
|
Pop up calendar Form
I have a report that i would like to be able to use the form to pull my report.
The form lets me pick the Expense Starting Date And Ending date. So I need a
way
to be able to pull the report based on the dates i choose in the form
Any help would be great ...
|
1 |
31.08.2006 11:36:01 |
|
|
Page Header to contain name of Sub Report.
Hi
I have a report with several sub report. Each sub report starts on its own
page. In the main report, I have a page heading and footer.
Each sub report deals with a different business section. For the sake of the
example, lets call them Section A, B, C, D and E.
So in rptMain, I'd like the page heading to be 'Section A' when the sub
report is rptSectionA. If the sub report is SectionB...
|
1 |
31.08.2006 11:09:32 |
|
|
"Template files" in Macro
Hi guys
Can somebody explain to me what ths means?
Template File - The path and file name of a file you want to use as a
template for .htm, .html, .htx, or .asp files. The template file is a text
file that includes HTML tags and tokens that are unique to Access."
and provide me with an example?
Thanks
Regards
Greg
...
|
1 |
31.08.2006 10:12:01 |
|
|
count Like in Access
Hi guys,
I have in my Access database a field that shows multiple values per record.
For example, AAAA~BBBB~CCCC~DDDD. In a good database, AAAA, BBBB, CCCC and
DDDD would be placed as different records. However, the data that I got, they
are placed together, as one record separated by "~". In Excel it would be
like several values in one cell. Is it possible to run a count of how many
ti...
|
2 |
31.08.2006 07:29:40 |
|
|
Dlookup in reports
I have Dlookup-function in report which lookups the price of a product based
on customerID and productID. This works fine as far as it consers product
details. But this report is an invoice which should have a total sum also. In
report I can't refer to the name of a calculated field in sum-fuction. What
should I do. Do I have to put my dlookup to the query or...
Thankful for Your help...
|
3 |
31.08.2006 06:51:01 |