Search results

No. I know you wasn't, but it did help as it suggested that the processor was in fact too busy to post my variable to the form. I have it sorted now by inserting "DoEvents" as below RecsRead.Value = iRec DoEvents many thanks for your help

Sorry Hui, the text box name is "RecsRead" ? The code pasted is inside a loop. If I put a msgbox (as you suggested earlier) it updates fine. Just doesn't do it otherwise.

Ah. Now that makes a difference in that it also serves to update the field I have on my form. However, I don't want a msgbox popping up all the while. Please allow me to re-state the problem knowing what I now know. I don't believe the filedialog box has anything to do with it. I have a Form...

the problem doesn't seem to be with the filedialog box. I by-passed this by hardcoding the input filename to be used. Still, the field in the form that I update each loop (reacord read) of the code, fails to update until it finishes. I thought I could get the form field to scroll through numbers...

It's OK I have sorted this now. Just examine each character read (sChar) and if single quote encountered, simply add another Chr(39) & sChar Ta

Hello Hui, It does everything OK except close (immediately). After the user selects a file, the code goes on to do a lot of laborious time-consuming processing, during which the selection box stays plumb in the middle of the screen. What I want to do is to display some processing progress...

Hello. I have some embedded (single) quotation marks in my data source that I am reading char by char and stringing together to create a suitable DoCmd such as below. Problem is that these embedded quote's cause a problem with the quote's necessary for the command itself. Is there an escape...

I am using the code below to open up a file dialogue box, to allow user's to locate and select a single file. The VBA code then goes on top perform a fair amout of processing. My issue is that the dialogue box remains on screen. I want to close it immediately. Any idea's Dim fd As FileDialog...

Wicked. I've used PHD in the past to good effect. ALready posted to the forum. Thanks for everything !!

Hello. I have been doing a bit of VBA. Nothing too clever, but I wondered . . . is there a way to run the code without having to go into Excel. OK, I used Excel to enter the VBE and create the code, but it doesn't refer to anything in the spreadsheet. I remember the old days, when having written...