<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=484281710-02052003><FONT face=Arial color=#0000ff size=2>Thanks
very much</FONT></SPAN></DIV>
<DIV><SPAN class=484281710-02052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484281710-02052003><FONT face=Arial color=#0000ff
size=2>Mark</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>A.D.Tejpal<BR><B>Sent:</B> 02 May 2003 08:39<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Open File Dialog
- multiple selections One MoreSimpleQuestion<BR><BR></FONT></DIV>
<DIV><STRONG>Mark,</STRONG></DIV>
<DIV> </DIV>
<DIV>In Access 2002, you can also try FileDialog Object. The code given below
will display a dialog box for File Selection. Based upon user's choice, the
variable TargetFile will give Full Path of each Selected File.
<DIV> </DIV>
<DIV>-------------</DIV>
<DIV>Code Start</DIV>
<DIV>-------------</DIV>
<DIV>Dim fdg as Object, TargetFile As String</DIV>
<DIV>Dim SLF As Variant</DIV>
<DIV> </DIV>
<DIV>Set fdg = Application.FileDialog(3)<BR>' Arguments -
1(FileOpen), 2(FileSaveAs), 3(FilePicker), 4(FolderPicker)</DIV>
<DIV> </DIV>
<DIV>With fdg<BR> .Title = Space(71) & "Select
Source Files"<BR> .AllowMultiSelect = True</DIV>
<DIV> If .Show <> 0 Then</DIV>
<DIV> For Each SLF In
.selecteditems<BR>
TargetFile = Trim(SLF)</DIV>
<DIV>' Note - Take Suitable Action Here On
TargetFile<BR> Next<BR>
End If ' Show<BR>End
With ' fdg</DIV>
<DIV>-------------</DIV>
<DIV>Code End</DIV>
<DIV>-------------</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>----------------------------</STRONG></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 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=markH@bitgen.co.uk
href="mailto:markH@bitgen.co.uk">MarkH</A> ; <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 02, 2003 04:07</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Open File Dialog
- multiple selections One More SimpleQuestion</DIV>
<DIV><BR></DIV><BR>In the example I gave, was "
OpenFile.lpstrFile = String(257, 0)"<BR>That is large enough for a single
file, you will need to enlarge it <BR>for multiple files.<BR><BR>On 1 May
2003 at 14:59, MarkH wrote:<BR><BR>> Hi again...<BR>> <BR>> I got
the dialog working fine, BUT... If I select more than a handful<BR>> of
files then nothing gets returned.<BR>> <BR>> Is there a limit?<BR>>
<BR>> In some cases I may be looking to select 50 or 60 files at a
time...<BR>> <BR>> Thanks again<BR>> <BR>>
Mark<BR></BLOCKQUOTE><BR>
<P><FONT size=2>---<BR>Incoming mail is certified Virus Free.<BR>Checked by
AVG anti-virus system (http://www.grisoft.com).<BR>Version: 6.0.449 / Virus
Database: 251 - Release Date: 27/01/2003<BR></FONT></P>
<P><FONT face=Arial size=2></FONT></P></BLOCKQUOTE></BODY></HTML>
<BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003<BR>
</FONT> </P>