Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Talbess

    .dbf files mysteriously gone missing (or being deleted)

    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...
  2. Talbess

    FAQs - anyone know where they are for VFP

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

    Memo Field

    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...
  4. Talbess

    Memo Field

    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
  5. Talbess

    Memo Field

    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...
  6. Talbess

    shellexecute() printing

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

    shellexecute() printing

    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...
  8. Talbess

    shellexecute() printing

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

    shellexecute() printing

    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...
  10. Talbess

    shellexecute() printing

    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.
  11. Talbess

    shellexecute() printing

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

    shellexecute() printing

    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...
  13. Talbess

    shellexecute() printing

    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...
  14. Talbess

    VFP Program Inactivity Timeout

    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...
  15. Talbess

    VFP Program Inactivity Timeout

    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...
  16. Talbess

    VFP Program Inactivity Timeout

    Mike, I agree with your comments, it just that I couldn't think of a way to trap activity that didn't interfere with the application. It turns out that using on key label mouse affected all of the _locatebutton foundation classes which I use a lot. With on key label mouse loaded, when I type...
  17. Talbess

    VFP Program Inactivity Timeout

    Thanks Mike - I tried adding the timer class to _screen and it seems to do exactly what I want. I only need to shut down after about 2 hours of inactivity so I'm just using on key label mouse to reset the timer - it would be pretty unusual for the mouse to not be clicked for two hours if a user...
  18. Talbess

    VFP Program Inactivity Timeout

    Hi, I have a problem that I think might be insurmountable, but I thought I'd throw it in to see if any of the experts in this forum can give me some ideas. I have a program (in vfp6 sp5) that is used by many concurrent users (on a WAN using Terminal Server/Citrix) and some have a habit of...

Part and Inventory Search

Back
Top