Home > Archive > MS Access database support > February 2006 > VBA: Reciprocal functionality ?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author VBA: Reciprocal functionality ?
Alan Searle

2006-02-18, 9:23 am

Dear All,

I am putting together a section of code which needs to scan a number of
directory trees. For example ...

c:\abc
c:\abc\def
c:\abc\hij
c:\abc\def\klm

.... and then put these into XML format for navigation with a web browser.

So far I have tried coding it up using VBA using tables (and SQL) or
internal arrays. I have had some success but keep coming up against
problems of blowing the 255 character limit in tables and with
reciprocal coding using arrays (i.e. a particular piece of code needing
to re-visit and re-processing a constantly growing array).

For example, once I have scanned each parent directory, I then need to
scan the child directories but I find that arrays are really unwieldy
when it comes to filtering and sorting. Tables are better but for
portability (later) I would rather do it in internal memory.

Anyway, I can't help thinking that I am probably busy 're-inventing the
wheel' here and there must certainly be blocks of code available to do
this? Maybe even a piece of functionality which directly spits my
structures out to XML?

Any tips or thoughts or pointers to 'HOWTOs' would be most gratefully
received.

Many thanks,
Alan Searle.

PS: remove the xxx to send me an e-mail.
Lyle Fairfield

2006-02-18, 1:24 pm

You have considered and rejected something like:
<form action=folders.htm method=get>
<input id="file" name="file" type=file size="80"/>
</form>
which allows the user to browse his/her files and enter the selection
into a textbox?

trivial example at:
http://ffdba.com/folders.htm

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com