Access VBA: Tranfertext Import Progress Bar ActiveX

[coders4hire]

I'm having a terrible time trying to 'mimic' the status bar progress bar when importing a text file. I have a spec, and the code which properly imports the data I need. The status bar in Access progresses nicely with the import. HOWEVER, if I register the Progress Bar Active X Component (Microsoft Common Controls 6), it requires that I know the min, max, and timing of the progress. Using the transfertext methodology, how can I calculate progress?

Thanks,


---
doug@coders4hire.com

http://www.coders4hire.com

http://www.payraisecalculator.com

http://www.cliintel.com

 

[mmsayed]

Have you made any progress on this? I have found a few samples on

http://www.utteraccess.com,

but none of them can calculate how long a process will take. If I find anything I will post it here for you. Please do the same.

Thanks,
Mehdi