Count Records in a text File

[JohnLee]

Hi vbaInet,

Thanks for that, that solved the problem, I didn't think about the count variable, but it's one I won't forget now.

Cheers

John

 

[vbaInet]

To be honest, you only need just one variable for the counting.

Glad you've got it sorted.

 

[JohnLee]

hi vbaInet,

I took your advice and removed the "RecordsCount" variable and assigned the "count" variable directly to the "rst!lngRecordCount field".

All is working fine.

Thanks for your help once again

John

 

[vbaInet]

No problemo JohnLee!