A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Allen Browns List files recursively



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 12:56 PM posted to microsoft.public.access
StuJol
external usenet poster
 
Posts: 122
Default Allen Browns List files recursively

this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??
  #2  
Old June 1st, 2010, 03:00 PM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Allen Browns List files recursively

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??

  #3  
Old June 1st, 2010, 05:31 PM posted to microsoft.public.access
StuJol
external usenet poster
 
Posts: 122
Default Allen Browns List files recursively

thaks for your comments tom,
there will only be one version of each document so i dont see it an issue,
can you explain how to get multiple columes and change the visibility??

"Tom van Stiphout" wrote:

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??

.

  #4  
Old June 2nd, 2010, 02:45 PM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Allen Browns List files recursively

On Tue, 1 Jun 2010 09:31:01 -0700, StuJol
wrote:

Sure. It's very simple. Since you are looping over a folder tree I am
assuming you're adding rows one at a time. Set the RowSourceType to
"ValueList". Then call AddItem for each row:
myList.AddItem(strFilename, strFilePath)
This would add one filename and one full path.
Then you can hide the Path column by setting the ColumnWidths property
to "1;0"

-Tom.
Microsoft Access MVP


thaks for your comments tom,
there will only be one version of each document so i dont see it an issue,
can you explain how to get multiple columes and change the visibility??

"Tom van Stiphout" wrote:

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??

.

  #5  
Old June 2nd, 2010, 02:46 PM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Allen Browns List files recursively

On Wed, 02 Jun 2010 06:45:30 -0700, Tom van Stiphout
wrote:

Sorry, I meant:
myList.AddItem(strFilename & ";" & strFilePath)

On Tue, 1 Jun 2010 09:31:01 -0700, StuJol
wrote:

Sure. It's very simple. Since you are looping over a folder tree I am
assuming you're adding rows one at a time. Set the RowSourceType to
"ValueList". Then call AddItem for each row:
myList.AddItem(strFilename, strFilePath)
This would add one filename and one full path.
Then you can hide the Path column by setting the ColumnWidths property
to "1;0"

-Tom.
Microsoft Access MVP


thaks for your comments tom,
there will only be one version of each document so i dont see it an issue,
can you explain how to get multiple columes and change the visibility??

"Tom van Stiphout" wrote:

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??
.

  #6  
Old June 3rd, 2010, 08:45 AM posted to microsoft.public.access
StuJol
external usenet poster
 
Posts: 122
Default Allen Browns List files recursively

Tom, thanks for your continued support. i understand what your saying but im
struggling to intergrate in into allen browns code... can you find time to
review allens code (link in orginal question) and help me to intergrate...

"Tom van Stiphout" wrote:

On Wed, 02 Jun 2010 06:45:30 -0700, Tom van Stiphout
wrote:

Sorry, I meant:
myList.AddItem(strFilename & ";" & strFilePath)

On Tue, 1 Jun 2010 09:31:01 -0700, StuJol
wrote:

Sure. It's very simple. Since you are looping over a folder tree I am
assuming you're adding rows one at a time. Set the RowSourceType to
"ValueList". Then call AddItem for each row:
myList.AddItem(strFilename, strFilePath)
This would add one filename and one full path.
Then you can hide the Path column by setting the ColumnWidths property
to "1;0"

-Tom.
Microsoft Access MVP


thaks for your comments tom,
there will only be one version of each document so i dont see it an issue,
can you explain how to get multiple columes and change the visibility??

"Tom van Stiphout" wrote:

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??
.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.