Hi,

Back in the days of FMP5 I developed a script, that worked with a MAC OS applescript, to open the folderpath contained in a field (creativly entitled) "FolderPath". It would enable a user to quickly recall a archived folder (i.e. their work for a specific day) and then let them select the files of their choice to open etc

Now I'd like to do the same, but in FMP7 and XP. I'm not sure where to start. I would appreciate any suggestions.

with thanks in advance

Giles

The syntax is: cmd.exe /c explorer c:FolderSubfolder

You can also specify a network folder ny using: servernameFolderetc.

or

serverIPaddressFolderetc.

When using the network folder option, the user must have access rights to that folder. If using a local drive folder, the folder must exist, or the user will get an error message that cannot be trapped by FileMaker.

Create a calculation field that creates a text line where you can use another field for the folder path.

The in the script, Use the send message script step then specify your calculation field.

This will open the command prompt window, tell Explorer to open the specified folder, then close. If you check to "bring target application to foreground", the folder should remain open on top of the FileMaker window.

As part of your script, check for the OS:

If [Abs(Status( CurrentPlatform )) = 1]

{run applescript for MAC}

Endif

If [Abs(Status( CurrentPlatform )) = 2]

Send Message [calculation field]

Endif

Thanks for that ... works a treat!!

Best Giles