Recent content by Talbess

Hi Vince, I have seen this happen when the connection between client PC and server gets interrupted while VFP is updating tables. If you look in the folder containing the data files you will probably find a file with a strange name created recently - this is the temporary file used by VFP when...

On my phone, I don't have any of the boxes (including FAQ) that you show.

Hi Mike, You're right (as usual) - there are lots of ways of getting text into memo fields and the separator could be CR, CRLF, LFCR or LF, and I have found instances of every one of these in data that I have on hand. So to do it properly the strtran has to look at three possibilities, just CR...

I did some more checking on this and Excel uses just LF whereas FoxPro uses CRLF so I now include something like: strtran(memo_text,Chr(13),'') as memo_text in the query to strip out the CR's. Only trap is that Excel still displays boxes for the LF characters until I turn Word Wrap on for the column

I've used this construct many times and it works well (if the memo fields are short), BUT, memo fields use CR-LF (0D0A) at the end of each line. This displays as two black boxes in Excel cells. If you type into a cell using Alt-Enter for each new line, there are no little black boxes and the...

Spot the bug..... Open("Mlink") should be Open(Mlink)

Thanks Dave, this is a bit more eloquent than always using internet explorer but I have to be able to print anything (pdf's, gifs, bmps, excel etc Those MS application objects are all different but its worth using for Word and Excel as these are the most common My code is now looking like this...

I found the answer with some googling... loBrowser.ExecWB(6,-1) prints without the print dialog. Regards

That couple of days turned into a couple of months..... but I'm back on it now. Mike's Code: loBrowser=CREATEOBJECT("internetexplorer.application") loBrowser.Navigate2("http://www.somewebsite/mydoc.doc") loBrowser.ExecWB(6,1) works (of course) BUT the IE print function brings up the print...

You're a legend Mike, those four lines are the bit that would have taken me a week. I'm bogged down with some urgent work for a few days but I'll be back on it when I get a bit of spare time.

Thanks Cricket, but there is no problem opening a document, the problem is background printing the document.

Hi Mike, thanks for your reply. I can't reach the documents by physical location as they are located on a document server and direct access to files is not supported, so I have to use a URL. I'd like to try your suggestion to instantiate an instance of the browser control as a COM object...

Hi, I am trying to use shellexecute() in VFP6 to print MSWord documents stored on a web server. If a document is stored on a local drive, shellexecute() will happily open or print the document, but if it is stored on a web server shellexecute() will open the document without problems but if I...

Olaf, Jim, Tamar thanks all for your help. I'll pick up Olaf's suggestion re using the Tab key to reset the timer - Tab is used a lot and this will provide more security against missed activity. I'm using VFP6 SP5 so messagebox() does not have a timeout. I had read some other posts re using...

Thanks again for your time Mike, this is one of those things that started off simple but just gets harder. Where I am at now is I am using the refresh event of a navigation bar that sits at the bottom of every form to reset the timer. The navigation bar has the usual navigation buttons plus...