Create Record when new file is created

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

m stroup - 29 Nov 2007 18:32 GMT

tblDocuments
Doc# (autonumber PK)
DocName
DocCreator
DocLocation
DocStatus

Currently, I am using this table to track document status.

Is there a way to automatically save the above information to the table
whenever I create/save a new file (be it access/word/etc)? I would also to
create a hyperlink field in the table and have that stored at the same time.

I have been doing some programming in access, but this would be done at a
higher level. Any help/references would be appreciated.

If it is not doable, that would be good info too :)

Signature

Teach me to fish! Thanks for the help.
Pax, M

Reply to this Message

John W. Vinson - 29 Nov 2007 21:57 GMT

>Is there a way to automatically save the above information to the table
>whenever I create/save a new file (be it access/word/etc)? I would also to
>create a hyperlink field in the table and have that stored at the same time.

Only if you put code in ALL applications which will create files for you; this
code would need to open the database and add a record to the table. It's going
to be monstrous complicated.

You might want to consider instead having code in your database which can use
the Dir() function to poll through the folder/folders containing the files you
want to track. This program could update your table (e.g. do you want to
delete records from the table when a file is deleted or renamed?)

John W. Vinson [MVP]

Reply to this Message

m stroup - 30 Nov 2007 03:08 GMT

Thanks, John. That sounds like a better approach. It would allow me to
locate files created by our team as well.

Signature

Teach me to fish! Thanks for the help.
Pax, M

> tblDocuments
> Doc# (autonumber PK)
[quoted text clipped - 13 lines]
>
> If it is not doable, that would be good info too :)

Reply to this Message