Window Dressing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a bit of help with a list box that I've designed. The list box will
contain a directory of links to files that I have on my computer, all of
different types. In order to distinguish these files, I would like to put an
icon next to each one specifying their file type (similar to how it's done in
the "Open..." dialogue boxes in MS Office programs). Thus, a Word document
would have a small MS Word icon next to it and so on with Excel, Access,
etc... I attempted to use the "faceid" property, but that seems to only work
for Menu Bars.

Any help is much appreciated! Thanks,

Joe
 
Thank you, Douglas. That was helpful, and I know enough about programming to
use code to actually open the files that I select in this dialogue box. I'm
afraid that I will have to limit access to just one or two folders in a
specified location, however, and I do not know how to modify the code you've
given me to do this. Also, when my database is placed on a server, will this
code still hold up when accessed from different workstations?
 
I'm not sure it's possible to place that limitation on the control. You may
be limited to checking what path they've returned, and refusing to open the
file if it's not one of the specific folders.

If you're planning on sharing the database, be aware that the recommended
approach is to split the database into a front-end (containing the queries,
forms, reports, macros and modules) linked to a back-end (containing the
tables). Only the back-end is placed on the server: each user has his/her
own copy of the front-end, preferably on their hard drive. Take a look at
what Tony Toews has at http://www.granite.ab.ca/access/splitapp/index.htm
 
Back
Top