|
Password protect an exported report
I would like to save a report as a snapshot and add a password to it. I plan
to email the saved snapshot and I want the receiver to be prompted for a psw
to view it.
Thanks ...
|
7 |
21.09.2006 10:42:09 |
|
|
HOW DO YOU OUTPUT MULTIPLE REPORTS TO ONE SNAPSHOT FILE?
I am trying to output multiple reports to a single snapshot file. Is this
possible and if so how do you do it?...
|
3 |
21.09.2006 10:33:33 |
|
|
Merging Multiple Access Reports
Hello,
Is it possible to merge a number of different reports in Access? All of the
reports have a different format and I'm trying to merge them and then create
a single PDF file.
I have no idea where to start.
Thanks....
|
2 |
21.09.2006 10:16:51 |
|
|
Summing Previous Two Records in a Report
I have a report whithin which I need to create a control in a text box that
would sum the fields of the last to records in a table.
I am reporting product returns and those returns that have not been processed
in 48 hours so I have a table that looks similar to below:
InputDate No.Returns No.NotProcessed
01/09/06 1
0
02/09/06 ...
|
2 |
21.09.2006 10:12:57 |
|
|
Multi column report problem
Background - I have a table detailing different laptops and their
specifications. What I am trying to create is a report that list 3 laptops
per page and their corresponding specs. I would like this to look like a
typical product comparison sheet (matrix style) where there is the
specification labels are listed down the left hand side of the page.
Example
Make Vigl...
|
3 |
21.09.2006 09:34:02 |
|
|
How many report pages for a single record?
I need to produce a contract page based on a single record in a table.
Because the table has a lot of fields and I need to include a lot of
'blurb'in the contract, the report will be about 5-6 pages long.
Access seems to limit the report design to about 3 A4 pages long - what am I
doing wrong?
...
|
4 |
21.09.2006 04:37:34 |
|
|
Visibility again
Hi again Groupies
Yesterday I posted a question regarding making one field invisible based on
the contents of another field. I would like the report to look like this:
Sum of Sum of
OT Hours PT Hours
Occupational Therapy 25
Physical Therapy 40
Unfo...
|
3 |
21.09.2006 04:29:17 |
|
|
Summary by Group in Report Footer
I have a report with a group header (Customer). The detail shows individual
purchases and returns. I want to put a summary of the Customer Purchases and
Returns in the report footer. Can someone point me in the right direction?
The report footer would look like this:
Purchases Returns
Customer A 1,000 100
Cu...
|
2 |
21.09.2006 03:28:29 |
|
|
Set Visible - Prev Record
I have a report to summarize specs for jobs based on General specs, Floor
specs, Room Specs and Product specs. The report is created from a union query
pulling together all specs from 4 tables then grouping by General, Floor,
Room and Product. Some fields match the group above and I would like to set
the visible value to false if it matches the last value in the same named
field in the g...
|
2 |
20.09.2006 23:13:40 |
|
|
Control Souse for Text Box
I have created a report that shows a check box for the records that show up
on the report. I added a text box and want this text box to show me the
total of how many check boxes are checked.
I entered the following but it does not work:
=Sum(Abs([Student]="1"))
I also tried leaving out the Abs but that also does not work. How should I
enter this?
Thanks,
Chad
...
|
3 |
20.09.2006 22:40:29 |
|
|
report values change when printing
Hello
I have a report which displays perfectly when in preview mode. However the
values in two of the textboxes on the report seem to double up when I try to
print it. This happens whether I initiate printing programmatically or open
in preview mode and print from the file menu. Does anyone have any idea why
this is happening? The code is as follows:
Private Sub Detail_Format(Cancel...
|
7 |
20.09.2006 21:19:02 |
|
|
#Error in snapshot copy
I have designed an application in which the user has to export a report to a
snp file to email users of the report. Recently a snap shot showed a #Error
in some of the fields. Two fields were caluculated, one field was data from
the database. When I go back and run the report and export it to a snapshot
it looks fine. The database is split, but is it possible something else was
locking ...
|
2 |
20.09.2006 20:31:03 |
|
|
Command button - transparency
Is it possible to change the level of transparency of a command button? I
would like to set some to about 50% transpasency so that both the button and
whatever is underneath can be seen.
tia
--
Jock Waddington...
|
2 |
20.09.2006 20:23:09 |
|
|
Running Sums shown for multiple group levels
Howdy All!
I have an sales report that shows all my clients, each order that the
client made (within a given time period) and then order details (item
description and item cost). It has three grouping levels, one for each
order, one for each client, and one for all clients. Without totals, it
might look like this:
Client 1
Order 1
Item 1 $1.00
Item 2 $2.00
...
|
10 |
20.09.2006 20:05:31 |
|
|
Almost Identical Reports
Hi Folks - I have two reports. They are almost identical, except that one
report inserts a new section, and a couple of other sections are reduced in
size to accommodate the new section. I'd rather not develop two separate
reports. Does anyone have some good strategies for this situation? Thanks.
Michael
...
|
2 |
20.09.2006 19:59:11 |
|
|
Control source code problem
I'm stumped (again)... but making progress.
I'm trying to sum "retail volume" with a constraint to do so only when a
specific field, "Project Type" is = "A WORD GOES HERE"
I've tried this, but it throws an error when I add the "where" part:
=Sum([Retail Volume]) WHERE [Project Type] = Allied)
Thanks,
Adam...
|
7 |
20.09.2006 19:53:03 |
|
|
Unbound controls
I'm making a report with several different queries and each query needs to
populate data in several different controls after being analysed (which may
change frequently). Perhaps I need to do several SubReports. My problem is
though that I can't from VBA populate data into an unbound control. I can
call a function from the control and get the data back but I can't do it
without a call. I...
|
4 |
20.09.2006 18:45:01 |
|
|
Querying without closing report
Hi,
I created a report using A2K. The user enters a part number at a text box
and clicks on the Run Report button and the report runs based on information
entered on the textbox.
The report runs fine. The problem is that some people like to take the least
steps and they don't close the report before going back to the form and
repeating the process for another part number. This creates...
|
3 |
20.09.2006 18:30:01 |
|
|
Dcount Help. Returns a 0
Hello.
I am trying to count the number of A's in a report
ElementClass is my field contining the letters.
=DCount("[Elementclass]","tbl_ElementClass","[ElementClass] = 'A' ")
It keeps returning a 0 when there are 2 A's n the particular report.
Any help would be appreciated.
Thanks...
|
8 |
20.09.2006 17:57:50 |
|
|
Assigning a Query as Report Record Source
I've almost got the answer to my question by reading previous posts, but
still need a little help. I have learned that the best way to assign a
record source,on the fly, for reports is with the report's Open Event with
code such as below:
me.RecordSource=SQL
However, I'm not sure how to address the query. For example, if the query
name is "MyQuery", how should the 'Me.RecordSourc...
|
2 |
20.09.2006 14:29:08 |
|
|
How do I put a border on an ACCESS report
I am looking at creating a certificate that access can print as a report with
the border already at the printer min settings. ...
|
4 |
20.09.2006 12:04:30 |
|
|
How to create such a specific report?
Hello!
I need to get data from a table with a query like this:
SELECT Sum(R) FROM MyTable WHERE Field1=X and Field2 LIKE Y;
X is a field of another table which has a relation '1 to many' with MyTable.
Y is not a field but it's a value calculated by VBA script (or, in another
case, selected from a list).
It's easy to get data with this query when X and Y are known and just
single. Bu...
|
1 |
20.09.2006 11:06:38 |
|
|
RTF problem with Access 2003
I have seen RTF exporting problems with other versions of Access, and wanted
to know if anyone knows of a fix for Access 2003. I am doing office
automation from a C# project, and exporting a large report to an RTF file.
The results in Word show some truncated fields (set to auto grow), but not
necessarily the largest fields. The automation part doesn't appear to matter
very much, as w...
|
3 |
20.09.2006 08:13:11 |
|
|
SubReport not showing up
I have a report with a subreport that normaly i run on a weekly basis by
date. If i run the report more than a week may report will show up on the
next page but my subreport will not.
Thank you in advance
Please help....
|
1 |
20.09.2006 05:05:01 |
|
|
Does anyone know how to add up multiple subreport's =[RecordCount]
I have a report with three subreports. All three have a have a text box with
the control source of =[RecordCount]. Now I'd like to total those up and
place them in a text box on the Parent report. However, I'm having
difficulty with this....
|
8 |
20.09.2006 02:05:26 |