Search results for query: *

PaulF - you are a star....works a treat. Thanks for the help. Dont mean to be cheeky but do you knw how to print out the contents of the text box by clicking a button now ? ?

Yes, the ($10) thing was a typo. Soz.... PaulF, ive tried the first suggestion but Ill have a go with the second one and let you know. Thanks for the suggestions..

I am trying to loop through some VBA code in an Access database, build a string as it goes along based on events in the loop then show the string in a text box control. Problem is that the Chr$(10) and CHR$(13) are being displayed as squares in the txt box. example of code ...

Thanks for replying mflancour. I take it null fields are blank (told you I was new at this)? If so I dont want them at all if the data in the other table (same row/field position) is also blank but I dont know how to miss them out. I should have mentioned in orig code that I am comparing 2...

Im a new boy on the block and am looking for a bit of help.... Ive got this bit of code below which I have cobbled together from bits and pieces but I need to make it quicker....that table is about 700,000 rows by 14 columns and I need to reconcile the lot!!! Private Sub Command0_Click() Dim...

Fbomb, if you get this message, pls contact me. I am working on something similar with 700,000 rows and 14 columns of data. I have the basic principle of how to do it using strings, sql and loops but need a way to make it faster.......