Referencing objects using Intellisense
Fri, 5 Dec 2008 08:01:18 -0800
I am trying to set the 'visible' and 'picture' properties of an image control
using the 'on format' event of a report. The control is available to me
using Intellisense, but the properties dont appear to be. This is the syntax
i am using, with 'img1' being the control name:
img1.Visible = False
img1.Pict ...
|
Selecting a report from a drop down box
Fri, 5 Dec 2008 01:42:36 -0800 (PST)
Hi, I'm wanting to consolidate all my reports on to one form. At
present you can set the date range and run the specific report. What
i'm after is the ability to, as well as select the date range to be
able to select which report ro run via a drop down box.
Thanks in advance ...
|
Multiple Calculations based upon a SQL in Report
Thu, 4 Dec 2008 17:05:53 -0800 (PST)
I want to create a report and calculate values based upon multiple SQL
criteria. I know how do this by creating multiple queries doing a
union query and then making the report but, to make it cleaner and
because of the number of queries that would take what I would like to
do calculate the values based upon SQL ...
|
File Labels
Thu, 4 Dec 2008 16:06:04 -0800
Is there a way to easily enter into Access (2003) a specific row and column
when desiring to print just one label from a sheet of partially used file
labels? ...
|
How to Sum Total cost field in report
Thu, 4 Dec 2008 14:12:01 -0800
Hi.
I have 4 fields set up in a table and on the report as shown below
Cost 1 Cost 2 Cost 3 Total Cost
$1.00 $2.00 $3.00 $6.00
$1.00 $2.00 $3.00 $6.00
The Total Cost field is working fine.
What I wish to do is have a field or area at the very end of t ...
|
Report Returned Record Count
Thu, 4 Dec 2008 13:38:00 -0800
How can I display the number of records returned from a report which source
is a query.
For example:
If my report returns 78 records over 4 pages, and each page has 25 records,
I would like page 1 to display "25 record", page 2 display "50 Records", page
3 display "75 Records" and page 4 to display "78 Re ...
|
import/export forms and reports
Thu, 4 Dec 2008 13:06:04 -0800
My database is secured with a password. I can import and export tables
without any problem, but I get a warning that it's impossible to
import/export forms and reports because my database is secured with a
password. Even when I enter my password, the importin/exportin doesn't work.
Can somone help me? ...
|
|
|
Prevent Printing a Report
Thu, 4 Dec 2008 11:50:05 -0800
Can I prevent a report from being printed. It is only for viewing and I
don't want anyone to be able to print it.
Can this be done and if so, can someone show me the proper sytax?
--
Don Rountree ...
|
MAKE BOX AROUND DETAIL IN REPORT - CAN GROW?
Thu, 4 Dec 2008 10:24:01 -0800
Hello,
MS ACCESS 2003 on XP PRO.
I have a report where the detail on a given item can be any height. (CAN
GROW from options.)
But I want to box around the item. (1)If I do borders, they aren't smooth.
(2)If I draw a box, it doesn't grow. (3)If I make the detail sunken, half
the box doesn't print.
...
|
Sorting by Group Totals
Thu, 04 Dec 2008 18:05:44 GMT
I am relatively new to Access and have gotten many answers from reading the
existing threads. I have not seen one problem specifically answered. I am
using Access 97.
I am generating a report of Employees and Errors with a count for each type
of Error. Here is the SQL that I am currently using to generate t ...
|
