Creating new directories when creating a new datasheet in Access

[Biomechanoids]

I have following problem:

I have an Access database and every time when I insert a new datasheet a folder should been created on the harddrive. For example: I insert a new customer or whatever into my database and simultaneous a new directory is created on my harddrive.

My problems are:
1. How can I achive that VBA recognises it when I create a new datasheet. Is there anything like the actionlistener in Java.

2. This program must run all the time. How can I achive it that it starts when I start the database in Access.


I know how to creat a new folder with the API function MKDIR"" and how to set up a connection to the database but nothing else that would help to solve the task.

It would be nice if somebody would give me a hint how to solve the problems.

Greetings
Thomas

 

[mp9]

Re part 2 of your question. Create a macro called AutoExec - this will run whenever you start the database. You the macro to call whatever module/macro/process you come up with to answer part 1 of your question.

http://www22.brinkster.com/accessory/