<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>That sounds great - the idea of the
narrow and wide is perfect. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Thanks Stuart</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=stuart@lexacorp.com.pg href="mailto:stuart@lexacorp.com.pg">Stuart
McLachlan</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=SDSSoftware@optusnet.com.au
href="mailto:SDSSoftware@optusnet.com.au">Software Design & Solutions Pty
Ltd.</A> ; <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, April 03, 2003 11:02
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Any brilliant
ideas - pictures in 'flexible' positions</DIV>
<DIV><BR></DIV>On 3 Apr 2003 at 9:39, Software Design & Solutions P
wrote:<BR><BR>> Hi everybody.. I am working on a system for a group of
travel agents<BR>> and today's task is to generate their quotes /
itineraries. eg. Day 1,<BR>> Rio, description of city, etc, Day 2 Manaus,
description of tour etc. <BR>> <BR>> I have created the screen which
will alow them for each day to select<BR>> a city, one or more 'items' (eg.
tour, hotel, flight details), and<BR>> these will slot into the report when
it is printed. <BR>> <BR>> They want the ability to drop photos in to
the itineraries. When they<BR>> select a particular item (city description)
then the itinerary will<BR>> always dislpay a photo. The users can select
from a list of photo<BR>> names held outside the database. <BR>>
<BR>> But I am looking for some brilliant tips on how to place the
photos<BR>> into the report....when they nominate that a particular item
should<BR>> also include a photo, then the text should appear next to the
photo,<BR>> and when they only select text, the text should wrap to the
whole<BR>> page. <BR>> <BR>> I have a few ideas and will start but if
anyone has does anything like<BR>> this, I'd love to hear from you.
<BR>> <BR><BR>Three controls in the detail sectiop of the
report:<BR><BR>txtItemWide, txtItemNarrow - both with the item text as
the source <BR>imgPhoto <BR><BR>Private Sub Detail_Format(Cancel As Integer,
FormatCount As Integer)<BR>If Nz(ItemPhoto, "") > " "
Then<BR> imgPhoto.Picture = PhotoFile<BR>
imgPhoto.visible = true<BR> txtNarrow.visible =
true<BR> txtWide.visible =
false<BR>Else<BR> imgPhoto.visible =
false<BR> txtNarrow.visible = false<BR>
txtWide.visible = true<BR>End If<BR><BR>End Sub<BR><BR>-- <BR>Stuart
McLachlan<BR>Lexacorp Ltd<BR>Application Development, IT
Consultancy<BR><A
href="http://www.lexacorp.com.pg">http://www.lexacorp.com.pg</A><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>