right click menu that point to accdb or accde

[Cotik]

I wondered if is there a way starting from the windows file system, to open a accdb or accde application with the right click of a a specific file generated into a specific folder from a third part software, while getting the path's file in order to work with the string name of file and its parent folder to move and rename them at the end of some processes

 

[arnelgp]

you can use a macro recorder program or a vbscript?

 

[Cotik]

I don't know, i'm little poor with code except for basics vba, the file whose path i would get is generated toghether with its parent folder. I would like users, after searched and got the file in usual way into the folder system, can open an accde application (with right click menu or some differents ways) starting from the windows file system and get its complete path for subsequent operations.

 

[Cotik]

I'm sorry, think i was not enough clear, i try to explain:
in dental manifactures process, there's a cad software whereby users, projects and design a sort of prototypes (every tooth is different and need to be machined as single project). At the end of design procedures, this software generates a model file (destinated to be machined in a subsequent cam procedure) and show it into fhe folder system in order to allow users to send it via lan.
This file is named approximately this way: yyyymmdd-[IdCustomer]-[ID Progressive of the day] and it's generated (together with some other files) inside a folder with the same name, in a specific path.
My goal is to copy this folder string into a db table, allow user to add some data in order to manage it in a better way into the workflow. Here's the reason why i need to capture the file string name (or folder) at the moment that the software shows it into the fileSystem, and open ( or get active) my db application at the same time.
Create an association with extenction file is not probably the best solution in this case, this kind of files had associations with proper viewer that i prefer not to modify.
Maybe a solution could be a macro recorded or something like this. Regarding vbScript, i don't know much around its possibility outside access, because of course, the solution i'm searching for, could be only outside Access.
Thank you for any suggestion

 

[CJ_London]

Think you would need to have your CAD software to do that. Alternatively this link may be of help

New file creation event in Windows

Does there any event occur in Windows when a new file is created? I want run a function in my program every time a new file or directory is created.

stackoverflow.com

 

[Cotik]

OK, the new explanation is far more normal a request. Here's a picture of a form I use in an application that imports (actually just stores the location) scanned documents that were downloaded from an FTP server. The mail goes to a third party that handles opening the mail and scanning the documents as well as naming the scanned document images to our standards so we can file them correctly. Similar to your situation. The form shows a source folder and a destination folder. Both have defaults but can be overridden if necessary. The other stuff is irrelevant to your needs. It is used to send an acknowledgement email or letter to the person who mailed in the scanned documents to confirm their receipt.

Thank you Pat, my project actually use the same your way for what concern the fso method that i used even in this project to parse the cad model's output directory in order to convert the strings name of the stored files and folders to our new current standard. What i really wanted to focused, for true, was a sort of shortcut outside my db application, that allow users to get start my db at the moment the cad sw shows the new folder created, into the windows folder manager, carrying along the folder's path just stored in. In this way, users don't need to use the file dialog to get the same folder they had just stored.