Populating a field from the file names in a foler

N

News

Hi,
New here, if it's the wrong ng. please direct me to the right one.

My problem;
I run a website for a small bridge club and give members access to
historical results (for several reasons).
Currently I have a little over 18 months of results which are accessed from
an HTML Table (it contains dates, as yymmdd, which point to result files on
the server - eg 050530.htm for today. This is now proving messy to maintain
(we have three sessions a week) and, due to competitive pressures, our host
service is offering MySQL for a modest increase in charges. I have tested
the concept of linking the dates (30 May 2005..) with the (hyperlink to the)
files (050530.htm...) and all is OK but is there an easier way to populate
than keying in all the dates and links? I have a local copy of the host
folder and results. Would using XP's DOS prompt to send a folder's
filenames to a file be useful?
Keith
 
D

Douglas J Steele

Are you trying to use Access, the database product that's part of Office
Professional (and the focus of this newsgroup) in the process? If so, you
could use the VBA Dir function to return a list of all of the .htm files in
a given folder.

In any case, it sounds as though you're probably going to need an index page
that lists what results are available so that they can get to the page in
which they're interested.
 
N

News

Yes, I am using MS Office 97 Professional Edition, but my knowledge of VBA,
currently, is minimal - 'tho' I do have a 1993 MS VB Language reference
manual.
Looking at the Dir[$] function, it looks like the filenames should be stored
in array and sorted and the hyperlink (relative because I develop/test on my
PC then upload to the host) generated from the filename
(..../archive/050530.htm).
It seems that the effort required (in Access) searching for current plus
last three months of results and allowing the user to choose is far greater
than my (very crude) current solution, which is build an HTML table and,
month-by-month comment out what I don't want to display - although I also
have to create an annual set of dummy (i.e."no results yet") results files
which are overwritten when the actual results are uploaded.

Keith
 
Top