I have a database that I run with vb6. My question is twofold.

1. how do you show the recordset scanning in a textbox when you are searching the database. Like you see on virus programs when the show the files being scanned and they are flashing by in a box? My database has just over 3000 files to scan and it would give them something to watch.

2. how do you use a checkbox to save a position in a recordset while useing vb6 so you can shutdown your pc and come back tomorrow and continue on from where you left off....kinda like a bookmark.

Thanks for your help on these two subjects.

hi there..

your question are straigh foward.. if you are going through a recordset and you know which record you are on, simply show it in a textbox too.. and for the second part, when you cancel the process, just save the id of the file you are in and when it restart go on from them.. what are you really asking??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

What I am asking in question 2 is, if I gave you my program and you installed it in your machine as an .exe and started to read the book and decided you read enough for today and wanted to quit, how would you know where you left off in say a day or two. I thought if I put a check mark box on that form that you could check the box and when the program started it would be at the spot in the book that you left off.

In question 1, I asking for a way to show all the records in a textbox from the database as you are waiting for a scan of that database to finish looking for a particular word or phrase that you are searching for. This is on a search form I have in my program.

for question 1: (to make this in order) Take in mind that updating the UI will slow your proccess.. said that, I don't fully understand what your application do, but you can show the current record you are scanning in a textbox, there is no problem with that (I can't see fully where is your problem here, you just print the current record to the textbox).. maybe a progress bar is a better solution?? (usually antivirus software shows the file is scanning because they not always scan the disk in the same way, or a method to tell you where it is so you can cancel it)...

Q 2: Again doesn't know what your APP do, so you can mark a position with a checkbox, but maybe is better if you save the current record (that has to had an ID) when the user select it?? that way the user has nothing to do, and you always open the last used record..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========