Change Word Document name from Access 1

[ZOR]

I have an Access DB that needs to allows links to Word Documents in different directories. I have created a procedure that collects all the word doc details, ie name, directory, and have them in a table within the database. Is there any way to modify the word document names within Access? Thanks

 

[Remou]

Have a look at Name ... As.

 

[ZOR]

Hi Remou, that was quick. I am trying to rename te word documents name in the table, but I am trying to change the external word documents name with the same name. Can a rename be done in code while in the Access environment. Regards

 

[Remou]

Have a look at Name ... As. You will find it under Name Statement in Microsoft Visual Basic Help (F1 in the code window).

 

[ZOR]

Many thanks Remou. Have a star and good weekend.