display directory folder in listbox

[namliam]

Is there a way to cut the number of characters so that it will fit the maximum number of characters allowable in the listbox?

I think the limit is 32000-something characters, simply doing left(...,32000-something) should limit it

I havent looked at the sample in detail yet, so I wont respond to your questions on that and leave that part to david

 

[DCrake]

Is there a way to cut the number of characters so that it will fit the maximum number of characters allowable in the listbox?

I think this question relates back to when you were using a value list for the row source, which is now redundant.

1. How can I change the Browse button into a save button that saves into the "c:\desktop\" & Me.fldA folder?

If we are at the point where the wizard has gone to the default or specified location and loaded all the files into the list box. Are you now wanting a button that will effectively save one or more selected files in the listbox to a specified local folder (C:\Desktop\)

At present the wizard already has a default search folder (CurrentProject.Path) This can be changed using the browse button. You would need an addtional button to perform the move or copy.

2. How do I have it automatically display the results of what is in the folder?

In the function there is a variable that retains the default search path simply change this to your desired path.

David

 

[smig]

I know it's an old topic, but I realy bang my head in the wall

I'm trying to use the CommonDialog control to browse for files but when I try to put it on a form I get a message saying "you don't have the license required to use this activeX control"
even trying to copy the control from DCrake db gave me the same error, though running it from there works.

I tried to add it to my refernces, but it didn't help.

thanks,
Tal

 

[SOS]

Don't use the common dialog control. You technically can't distribute it unless you own the developers version of Access or VB. And you can get by fine without it just by using some API code found here:

For Files

For Directories