Hi,

Question1:
If my MS access data is not secured by a password, I can use this code to open it: Data1.DatabaseName = App.path & "\MyParts.mdb"

Now I set the MyParts.mdb to prompt a password to open it. Of course, that code above cannot open it any more.

Question 2:
I want to highlight whole row (or fileds) of the table where the arrow pointed to the records found.

Question3:
The records found is saved to a text file name Records.txt. I want the program to save or convert the file to .pdf extension so that no one can edit it.

I am a beginner in VB, so any help will be appreciated.

Sincerely,
Mike