Using Hyperlink data type and textbox to get path

[Trigon]

Hi

Im trying create a new form to add our current database that will password protect excel, word and if possible pdf documents when they are dragged onto it.

For now I only have 2 boxes 1 containing the password to be applied and the other to drag the file onto.

I have it all working so once its dragged on it works out if its a word doc, opens a hidden instance of word which then resaves it with a coded password.

The problem comes when change it so the user enters the password to protect it, when they enter a password or click on the drag box it doesn't allow the drag. it seems once they have entered the record the drag option is not available anymore.

Is there anyway around this?

Thanks

Chris

 

[liddlem]

Hey Trigon
I'm keen to implement the drag and drop thing on a project that I'm working on, so keen to see how you have done it.
As for a solution....
What if you get the user to drag the file first and then update the password. Just move the code to the 'afterUpdate' event on the password fields. (or link it to a button)
Will that work?