[AccessD] File list to combo

The Explorer example is quite nice, but you'll need to modify it. The reason
being that the two listboxes use value lists as their rowsource, and it does
not take a great many files to hit the limit. So the code would need to be
changed to store the directory and file names in a temp table and then the
table can be used as the rowsource.

Lambert

> -----Original Message-----
> From:	John Colby [SMTP:jcolby at colbyconsulting.com]
> Sent:	Wednesday, October 15, 2003 12:02 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] File list to combo
> 
> Thanks Mike, I'll take a look.
> 
> John W. Colby
> www.colbyconsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
> Mattys
> Sent: Wednesday, October 15, 2003 11:49 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] File list to combo
> 
> 
> John,
> 
> There is one in here, I believe
> http://www.mvps.org/access/downloads/Explorer.zip
> or go to
> http://www.mvps.org/access/resources/downloads.htm
> 
> Michael R. Mattys
> Try MattysMapLib for MapPoint at
> www.mattysconsulting.com
> 
> 
> 
> ----- Original Message ----- 
> From: "John Colby" <jcolby at colbyconsulting.com>
> To: "AccessD" <AccessD at databaseadvisors.com>
> Sent: Wednesday, October 15, 2003 11:27 AM
> Subject: [AccessD] File list to combo
> 
> 
> > Does anyone have code for getting a list of files in a directory into a
> > combo box - preferably a callback so that there is no 2k string limit.
> > 
> > John W. Colby
> > www.colbyconsulting.com
> > 
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com