Fwd: RE: [AccessD] Pictures in reports

Dale Kalsow dkalsow at yahoo.com
Wed Apr 23 16:31:21 CDT 2003


How do I move the text box to the correct location?

David McAfee <DMcAfee at haascnc.com> wrote:From: David McAfee 
To: "'accessd at databaseadvisors.com'" 
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 14:28:01 -0700

IIRC, Me.Image0.Height = 10 DOES work (for me at least) in A97, but I had to move up any text box that was under it and move them back down if the picture exists (as well as making the picture box 5" tall again:  Me.Image0.Height = (5 * 1440)). I believe I had to do this in the Detail_Format not Detail_Print-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Wednesday, April 23, 2003 1:43 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Pictures in reports

I tried that by setting it in the Detail_Print section.  I get the error 'Can not set the Height Property in print preview or after printing has started.'
Should I be setting it some other place?
David McAfee <DMcAfee at haascnc.com> wrote:From: David McAfee 
To: "'accessd at databaseadvisors.com'" 
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 13:46:46 -0700

What about setting the picturebox height and width to zero (or .001") if picture is not available? David McAfee
 -----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow
Sent: Wednesday, April 23, 2003 1:28 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Pictures in reports

An Image box in reports does not have this property.

"Wortz, Charles" <CWortz at tea.state.tx.us> wrote:The field where you want to show a picture if there is one needs to have
its Can Shrink property set to True and the section that contains that
field also needs its Can Shrink property set to True.


Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Dale Kalsow [mailto:dkalsow at yahoo.com] 
Sent: Wednesday 2003 Apr 23 14:41
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Pictures in reports


If there is not picture I want the next record to be tight under the
previous record and if there is a picture then the picture should show
up between the records. Some records will have pictures and some will
not. The user can choose to tie a picture to his record if they want.

"Wortz, Ch! ! arles" wrote: 
Subject: RE: [AccessD] Pictures in reports
Date: Wed, 23 Apr 2003 14:17:19 -0500
From: "Wortz, Charles" 
To: 


What do you want to do with the space the picture would have taken up?
Do you want to have two different layouts for your report, one for
records with pictures and one for records without pictures? If you do
want two different layouts, the easiest way is to have two different
reports. If that is not acceptable, then one report with two different
subreports and code to determine which subreport is appropriate to
populate and show.

If the above does not meet your needs, then please give more details of
what you want.

Charles Wortz 
-----Original Message-----
From: Dale Kalsow [mailto:dkalsow at yahoo.com] 
Sent: Wednesday 2003 Apr 23 13:58
To: accessd at databaseadvisors.com
Subject: [AccessD] Pictures in reports


I have a report that has multiple recor! ds! and each record may or may not
have a picture assocated with it. If I do not have a picture for that
record I do not want to use the space that that picture would take up.
Does anyone know how to do this?

Thanks!

Dale
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo._______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo._______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030423/671105ed/attachment-0001.html>


More information about the AccessD mailing list