Benjamin Bolduc
Registered User.
- Local time
- Today, 11:07
- Joined
- Jan 4, 2002
- Messages
- 169
Hi Everyone,
I've recently set up a feature that creates a folder on our server for every customer we have in the DB. It is working great, but the problem I'm having is when we need to change the Account Name.
The Account Name is the primary key throughout the entire Customer Service DB. When the Account Name needs to be changed, a set of code asks for the new name and then runs about a dozen update queries to change all the records in all the tables.
The problem is that the folder, which was named after the Account Name, does not change, and I can't seem to find out how to change folder names using VBA, only make and delete. The button that opens the folder from the Customer Service form needs the folder to have exactly the same name as the Account Name, otherwise it just creates a new folder leaving all the files in the old folder.
I hope this is making sense! If anyone could point me towards the code to do this, I would be very much appreciative.
If you need any other information, please just ask.
Thanks!
Ben Bolduc
I've recently set up a feature that creates a folder on our server for every customer we have in the DB. It is working great, but the problem I'm having is when we need to change the Account Name.
The Account Name is the primary key throughout the entire Customer Service DB. When the Account Name needs to be changed, a set of code asks for the new name and then runs about a dozen update queries to change all the records in all the tables.
The problem is that the folder, which was named after the Account Name, does not change, and I can't seem to find out how to change folder names using VBA, only make and delete. The button that opens the folder from the Customer Service form needs the folder to have exactly the same name as the Account Name, otherwise it just creates a new folder leaving all the files in the old folder.
I hope this is making sense! If anyone could point me towards the code to do this, I would be very much appreciative.
If you need any other information, please just ask.
Thanks!
Ben Bolduc