Hi Richard,

I trust you are well.

I've just worked through this seminar and built the sample database. Fab! Most enjoyable. I alse made the Encryption Module (Public function global); made an Asset Register form with a lot more values and encrypted quite a few fields. Had to include an On Error Resume Next 'handler' in  the code and it works just fine. My question as follows: how could I set up a continuous form to display all the de-encrypted data for a report printout and then encrypt all the records in one go. I've tried this and the form only shows one record. I know I'm still a novice' Access student but if this is possible, I'm sure there must be more of us out there that would love to know how to do this.

Yes we would love to see an add on lesson with PASSWORD encryption etc.

The more the better I say.

Cheers for now Richard and kindest regards,

Deon

---

Reply from Richard Rost:

Deon, I'm glad you enjoyed the seminar.

How about an UPDATE QUERY. This might actually work faster (and better) for you. Run the update query with your decryption function, generate your printout, then make sure you run another update query to delete all of the decrypted field data. Three buttons on a form would work perfectly for this.

The only problem is that your data is potentially exposed WHILE you're running the printout (between update queries). If you're THAT concerned about security, you could run a Make Table Query and drop it to a temporary table in your local database (assuming you have split front- and back-ends).

Hope this points you in the right direction.