Any Access Experts (help required!)

m4cc45 · 1 Aug 2009 at 20:43

Hi,

Basically in my database (personal use) I have some hyperlinks pointing to some documents / exe's, etc.

I wondered if it was possible to put there file size there as well?

It would be useful to see from my point of view.

Thanks,

M.

Dolph · 1 Aug 2009 at 22:39

You can do it using the filesystemobject method in VBA but it gets quite complicated, and could lead to quite an overhead if you have a lot of files.

Sin_Chase · 1 Aug 2009 at 22:59

Dolph - Would not be that bad if you used that VBA method and had it append the file sizes to the database holding the links and ran it on a as and when basis.

Dolph · 1 Aug 2009 at 23:20

Sin_Chase said:
Dolph - Would not be that bad if you used that VBA method and had it append the file sizes to the database holding the links and ran it on a as and when basis.

True, it depends how dynamic the files in question are and whether they need regular or automatic updating or not.

m4cc45 · 2 Aug 2009 at 13:29

Well they are pretty static files and would only need to be queried now and again. I'd ideally like a button on the page (something like get sizes) that queried the links on that page and then reported the sizes back into a text box.

If not then a button which updated the entire database would be nice.

Guess I'll have to look into VB scripting.

M.