Tabulating document proerties from a folder in Access

2 Jun 2005 10:51 AM

IainMac

I want to list a set of folders and store the properties from each document
in them in an Access table.
Most docs are Word or excel, but there will also be pdf's and images.
Checking through reference documentation is proving long winded, so can
anyone point me the way?

2 Jun 2005 11:32 AM

Stu

> I want to list a set of folders and store the properties from each
document
> in them in an Access table.

What properties? Filename? size? type?

2 Jun 2005 12:47 PM

IainMac

Any property stored that you may be able to access by listing properties by
right clicking in Windows, but especially creation date, author, last update,
document type, size, summary (if poss for office docs but really not that
important)

Show quoteHide quote

"Stu" wrote:

> > I want to list a set of folders and store the properties from each
> document
> > in them in an Access table.
>
> What properties? Filename? size? type?
>
>
>
>

2 Jun 2005 4:01 PM

Stu

> Any property stored that you may be able to access by listing properties
by
> right clicking in Windows, but especially creation date, author, last
update,
> document type, size, summary (if poss for office docs but really not that
> important)

Take a look at DSOFile, filelen, fileDateTime and the dir function

Stu

3 Jun 2005 1:55 PM

IainMac

Thanks!! But...
DSOfile looks the business, but I can't find information on how to use it.
My environment is VB for Access 2003, and while I can now reference it and
select proprties and methods for it in the vb window, I don't know how to
code with it!
I cannot import the examples to study them.
Is there a reference I can use?
Show quoteHide quote

>
> Take a look at DSOFile, filelen, fileDateTime and the dir function
>
> Stu

5 Jun 2005 9:34 AM

IainMac

"IainMac" wrote:

Well, I wil answer that myself and rename the threadt at the same time!!

YES THERE IS GEEZER: GO TO

http://www.microsoft.com/technet/community/columns/scripts/sg0305.mspx

FOR THE LOWDOWN ON DSOFILE. Complete with explanation and example code.
Show quoteHide quote

> Thanks!! But...
> DSOfile looks the business, but I can't find information on how to use it.
> My environment is VB for Access 2003, and while I can now reference it and
> select proprties and methods for it in the vb window, I don't know how to
> code with it!
> I cannot import the examples to study them.
> Is there a reference I can use?
> >
> > Take a look at DSOFile, filelen, fileDateTime and the dir function
> >
> > Stu
>