How To Modify Explorer.mdb? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Topic

New Reply

See attached demo from The Access Web, Dev Ashish

http://www.mvps.org/access/modules/mdl0013.htm%5B/url%5D

Open frm_AccWeb_Explorer

When I Single Click to view files, how can I sort the files in the right pane in alphabetical sequence?

When I Double click on an item to refesh display, how can I sort the directories in the left pane in alphabetical sequence?

Thanks, John

Reply | Quote

Replies

You’d have to sort the arrays.

(I wouldn’t use this stuff at all, but it’s your choice)

Reply | Quote

Thanks for the info

I got this working
When I Double click on an item to refesh display, how can I sort the directories in the left pane in alphabetical sequence?

What is the code to do This?
When I Single Click to view files, how can I sort the files in the right pane in alphabetical sequence?

Are there limitations? What other alternative would I use?

Thanks, John

Reply | Quote

The answer is the same for both: remove or comment out the call to PDF_accSortStringArray. It messes things up. If you omit it, folders and files are displayed in alphabetic order, since the Dir function does that automatically.

Using list boxes to show drives, folders and files is the Windows 3.1 way to do it (early 1990s). Windows 95 and up have a much nicer file dialog. In Office XP and later, you can use the Application.FileDialog object to display this dialog, but that is not available in Office 2000. You can use the dialog from post 304,810 instead. The user can display and sort the files the way (s)he likes, use the My Places bar etc. It works in any version of Access.

Reply | Quote

Thank you for that

John

Reply | Quote