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 derfloh 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. CEMrob

    Passing email addresses to Outlook 2003 from VFP 9

    Mike, Thank you very much. That does the trick, and I have tested sending an email to multiple recipients - that being the object of the exercise. I have little programming experience outside VFP, but I have looked at Microsoft's Outlook 2013 Developer reference, so can incorporate 'CC' and...
  2. CEMrob

    Passing email addresses to Outlook 2003 from VFP 9

    Mike, In Outlook > Options > Mail Format I have tested with 'Use Word etc' both checked and unchecked - same result, ie no addressees listed. Other than that altering setting, I can't see a way to change the default editor simply. I have very briefly looked at Automation, but many years ago I...
  3. CEMrob

    Passing email addresses to Outlook 2003 from VFP 9

    Thanks Mike. Persuading folk to use the default editor might be difficult, especially, as I say, I won't necessarily know which mail client, let alone which text editor, people will be using. Automation might be the only way forward. I will do some testing nonetheless. Rob
  4. CEMrob

    Passing email addresses to Outlook 2003 from VFP 9

    ...text editor, and although a new email document is still opened correctly, the recipient addresses are not put in. Am I missing something obvious? *PREPARE FOR USING SHELLEXECUTE TO CALL EXTERNAL APPLICATIONS DECLARE INTEGER ShellExecute IN shell32.dll ; INTEGER hndWin, ; STRING...
  5. CEMrob

    Excel Insert row then format cell in new row

    Thank you for the suggestion. I had tried doing that, but the problem is that I have little knowledge of VBA and don't know what object methods and properties are available, or what the syntax might be. This means that I do not know how to modify the 'recorded' generated code which uses specific...
  6. CEMrob

    Excel Insert row then format cell in new row

    Excel 2003 / WinXP. I have a list object with 5 columns, A - E, and all cells have a border round them. I need a macro which will: 1. insert a row below the current row (whatever cell happens to be selected when the macro is triggered by the user) 2. then remove the left hand border of the cell...
  7. CEMrob

    remote desktop substitute or VFP code

    @Olaf: I'm not sure newtofoxpro is actually talking about hosting the app on a webserver. I thought the requirement is just to have some way of accessing data held at one terrestrial location from somewhere else (and print it). @newtofoxpro: Ref your 'dream'- As I mentioned above, I have an app...
  8. CEMrob

    remote desktop substitute or VFP code

    Ok, I'm clearer now on the setup. It doesn't sound like a VFP issue to me. PC2 & PC3 access the data on PC1 via remote desktop, so then it will be PC1 'instructing' the local printers to print. It is effectively the same as sitting at PC1 and directing printer output to a printer attached to...
  9. CEMrob

    remote desktop substitute or VFP code

    PC2 is far away from PC1 but works good with remote desktop with static_IP via internet". Sorry, don't quite understand, you seem to be saying that PC2 ... works good ... via internet, then you ask about code to access a DBF via the internet(?). Does your App reside on the server, or on the...
  10. CEMrob

    Select a group of files

    Thanks Olaf. You've confirmed what I suspected, that it is not possible, or at least not possible for someone of my limited abilities. I'll just tell my users that, in the words of the song, "you can't always get what you want". Rob
  11. CEMrob

    Select a group of files

    thread184-456868 VFP 9 SP2. Win 7 (Most Users: XP pro) For some time I've used a method for selecting a group of files using ChrisRChamberlain's approach with _comdlg1 in the above thread, as summarised by Foxegg on 31 Jan 2003 in the same thread. Works great, thanks people. I've now had a...
  12. CEMrob

    Can't open one particular .DBF

    I note from your error messages that as well as the "error 182 while reporting 182" you got an "insufficient memory" message. The problem may be some sort of memory leak or stack issue, rather than a straightforward coding problem. (Though admittedly you have restarted your machine which usually...
  13. CEMrob

    Index on 2 expressions, one ascending, one descending

    Oops, meant to say, STR instead of DTOS seems to work. Thanks once again, the "subtract from some future date" approach is the key. Rob
  14. CEMrob

    Index on 2 expressions, one ascending, one descending

    Thanks Mike for your (ever) speedy reply - don't you have a home to go to?. I get an invalid function count type error. On reflection, DATE(2999,12,31)-visitdate gives a number of days, which DTOS can't handle. Nevertheless, you've woken my brain up and sparked new ideas, which after all is...
  15. CEMrob

    Index on 2 expressions, one ascending, one descending

    ...index on REF + DTOS(VISITDATE) and by default that gives me Alpha order on REF but oldest visit date first, so thats no good. I could SQL SELECT * ... ORDER ON VISITDATE DESC into another table, then index that on REF, but I'd rather just stick to the original table, since the users need to...
  16. CEMrob

    How to hide the Command Window on design time

    Just a quick comment: I discovered the 'fusing' of the four windows some years ago by accident, and wouldn't do without it now. Also,if I happen to have the Properties window say on top at the time I build the application, it automatically switches to the Command window once the build is...
  17. CEMrob

    Page Caption: any way to put in an image?

    Thanks Mike, I should have remembered that some years ago I did a small App for someone and had fun using pageframes with no tabs but using other controls to switch between pages. I think I also mimicked an early 'wizard' type form, where the user stepped through (and back) a sequence of queries...
  18. CEMrob

    Page Caption: any way to put in an image?

    VFP 9.0 You can add a picture to a menu option. Is there a way to add a picture to the caption of a page on a pageframe? I've searched the forum & FAQs & can't see anything, but apologies if this has already been addressed. Thanks.
  19. CEMrob

    Form is blank at runtime

    Well. Now I feel like a complete idiot. LockScreen is indeed set to .T. in the non-working form: resetting it to .f. works a treat, and there I was protesting that all basic form settings in the working and non-working versions were identical. Words like "wood", "trees" and "not seeing" come to...
  20. CEMrob

    Form is blank at runtime

    @Mike Oh yeah....(sigh) Only 8 bits to the pound, and Alan Sugar was still just a horrible dream.

Part and Inventory Search

Back
Top