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!

  • Congratulations Mike Lewis 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. ostrowlaw

    Any way to use/save VFP 9 database/tables to OneDrive or other cloud solution

    Hi, Again, I'm not a programmer, but in my VFP programs, when I am attempting to access any record to make changes, I issue a rlock(), then whatever I'm trying to do, i.e., replace, edit, etc. When I'm done, I issue an unlock(). Most of the major things that VFP does automatically lock the...
  2. ostrowlaw

    Any way to use/save VFP 9 database/tables to OneDrive or other cloud solution

    Interesting discussion above, maybe because my code was from dBaseII and dBaseIII, I never really tried to change the date in any record at the same time. I always placed a rlock() on the record before the edit, and unlock afterwards. Alan
  3. ostrowlaw

    Any way to use/save VFP 9 database/tables to OneDrive or other cloud solution

    Wow! You guys are just awesome. I have a lot to think about and to work through (remember, I'm not a programmer, just a user, in the olden days, there were no dBase programmers, everyone was a user, we learned how to build simple programs to get our work done). I'm going to put some time...
  4. ostrowlaw

    Any way to use/save VFP 9 database/tables to OneDrive or other cloud solution

    I know I'm probably a bit late to this party, but I'm not a programmer, just a user. I run a small law office with just a few users. I started out using dBase II back on a Kaypro II CPM machine in the early ages of dinosaurs (1980s), and I've developed my office database programs over the...
  5. ostrowlaw

    VFP Reports - Changing Names

    Hi again, Sorry to bother you guys but although I've been using Foxpro for many years (since 2.0 and before that dBase II), I've just recently started playing around with reports. The reports are much easier than writing entire programs to do the same thing, but the syntax is arcane. Anyway...
  6. ostrowlaw

    VFP Reports - Changing Names

    Thanks Chris and Mike. I'm going to print this off and keep it for the future. Its too late at this point. These databases (tables!!!) go back to when I originally started using dBaseII (under CPM as the operating system) a million years ago, before we had all these features and functions. In...
  7. ostrowlaw

    VFP Reports - Changing Names

    I was thinking about the theoretical problem, i.e., 2 records have the same name. This is possible (although I haven't had this occur in quite some time - it was a mess!). So, if I Changed Group 1 band to Lastname+Firstname+Accountno do you think this would resolve the problem? The reason I...
  8. ostrowlaw

    VFP Reports - Changing Names

    YES!!! Thank you, I think that did it, I just removed the Group 2 band and changed Group 1 as you suggested, ran a sample bill and it looks exactly the same. I don't have any duplicate names this billing cycle, but I am assuming that this is the fix. Thank you for your kind assistance! It is...
  9. ostrowlaw

    VFP Reports - Changing Names

    Thanks you Mike. I'll try to modify the report and see how it goes. I'll be back. . .https://files.engineering.com/getfile.aspx?folder=c9e132c2-1765-4171-9a0e-4aaecb678abb&file=VFP_Report.doc
  10. ostrowlaw

    VFP Reports - Changing Names

    Thanks Mike and Chris. I do definitely have an index file attached to the database file. Its been so long I can't remember whether it is indexed on lastname only or lastname+firstname. I am attaching what the report looks like and the Print When...
  11. ostrowlaw

    VFP Reports - Changing Names

    Well, I have some clients that use an account number, some use different types of numbers, so I always used lastname + firstname. For some reason, this report only uses the lastname to sort and, as discussed above, it merges different accounts with the same lastname. How would I change this so...
  12. ostrowlaw

    VFP Reports - Changing Names

    I don't know how to describe my problem. I have a report that I use for billing. Simple fields, Lastname, Firstname. So, this past month I had 2 bills with the same last name, let's call them Jane Cruz and John Cruz. My Pageheader is ALLT(LASTNAME)-" "ALLT(FIRSTNAME) and in the Field...
  13. ostrowlaw

    Modifying Visual Foxpro Report

    I have the program that calls the report form do while idler < 100, store 1 to idler, then I run the report, then idler = idler+1. report form bills for idler = clientnum Some idea I think (??) in my old fashioned way. Again, thanks for your help, it was great and now I have more ideas. ...
  14. ostrowlaw

    Modifying Visual Foxpro Report

    Got it, worked great!!! Thanks again for all your help and especially to Mike Lewis for the "heads up" regarding the "print when" in the report. Now I want to go back and look at all my reports to see how to make them run more efficiently. Greatly appreciate all the help I get here. [thumbsup]
  15. ostrowlaw

    Modifying Visual Foxpro Report

    Thanks, you guys are awesome! This particular client has perhaps 30 different entries on an cumlative invoice with the title portion of the report showing the sum total of all of the separate invoices. So, for whatever reason, they don't want each separate entry to have an invoice number. I...
  16. ostrowlaw

    Modifying Visual Foxpro Report

    Well, to tell you the truth, I don't use "stand alone" exe files, I still use VFP the old fashioned way as I've always done. Its a small office and the programs are for our internal use only. So each computer has a version of VFP on it, and the programs are like we always have done - DO...
  17. ostrowlaw

    Modifying Visual Foxpro Report

    Hi, I have a VFP Report that I use to generate bills to my clients, but one of my clients needs a tweak to the report. So, I opened up the MODIFY REPORT command with the name of the report, made the change (it was a slight change, just taking out an invoice number) and then under File, saved...
  18. ostrowlaw

    Foxpro Windows 2.6 Output Fonts &amp; Alternate

    I am using FPW 2.6 with old dBase/Foxpro handwritten programs, so I am just trying to get them to work under FPW 2.6, hoping to move later to VFP. The programs are hand written, using @say gets, etc, and I will need to hand write all of them. First, I increased the size of the text in the...

Part and Inventory Search

Back
Top