Help

[ttandrew]

New to VBA, been using Access for a while. Sorry for my bad wording.

I have a form, which holds clients details. They each get a Number, but not an auto number, as it currently comes from a manual system, so they do not always follow.

I would like on entering this number a 'dummy' file on my C:\ to be copied and renamed with this number. The file has sub files that need to always be the same. Details are entered there from other points.

Many Thnks
TT:banghead:

 

[darbid]

I will help you if you show me some code as to how far you have got so far.

If you are just starting, then my I suggest (you dont have to use it but) you use

Dim fs As Scripting.FileSystemObject

as the start.
Then look at this link for examples.
http://support.microsoft.com/kb/186118