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. gbcpastor

    Export to Text file

    copy to ERP0605C.txt sdf This is just a simple fixed field text file. If you only want certain fields you can include the "FIELDS ..." switch.
  2. gbcpastor

    Latest VFP Version

    The Service Pack 2 was the final update to VFP 9.0 It repaired several bugs and yes, it is a good thing to download and install. Great question.
  3. gbcpastor

    sorting

    I've had this situation several times years ago. What I got in the habit of doing was using a leading zero in my text fields so I would have values that looked like this: 01 02 03 04 05 06 07 08 09 10 11 12 13... That's if I wished to keep the values as text. Otherwise, just use the val()...
  4. gbcpastor

    selected marking of target

    Perfect Chris, thank you so much for your help.
  5. gbcpastor

    selected marking of target

    I need to mark the first 3 records in a field called TARGET when the field called MAILCODE contains "123ABC" Then repeat the process for each value in the MAILCODE field. Please help!
  6. gbcpastor

    Data type mismatch

    Hey there, I had this problem in the past. What I was doing was creating a "Character Type" variable in the form. I created it so I could enter in a masked value ("999,999.99"). When I tried to set the valued of the field in my table to the value in the table, it errored out. Then I realized I...
  7. gbcpastor

    Export Foxpro 9 DBF to Dbase 5 File

    The only info I could get about dBase 5 files was they were used by spinoffs like "Clipper" and others. Access "DBF" files are also in this configuration. Again, thanks for your help.
  8. gbcpastor

    Export Foxpro 9 DBF to Dbase 5 File

    And there you go. All I had to do is copy it out without memo fields and use type FOXPLUS and it worked great. Thank you Chris and thank all the rest for all the help.
  9. gbcpastor

    Export Foxpro 9 DBF to Dbase 5 File

    This is the result. I must produce this filetype for the software on their machine.
  10. gbcpastor

    Export Foxpro 9 DBF to Dbase 5 File

    This is not the old DOS version of dBase. I think they need files for windows ACCESS and they call the file type dBase 5. I tried 2x and FOXPLUS and neither worked. So, I'm still stuck. I'm trying to talk them into a CSV import on their end but I hate going to the client and tell them "I Can't...
  11. gbcpastor

    Export Foxpro 9 DBF to Dbase 5 File

    I have a client with proprietary software that requires dBase 5 files. I need to export a file in DBF format that is compatible with their system. I don't know what's different about the files but they have to be dBase 5 format.
  12. gbcpastor

    WorkbookXLSX R30

    Thanks to everyone, especially Greg "ggreen61", you have been such a great help and all is working perfectly. God bless;
  13. gbcpastor

    WorkbookXLSX R30

    Greg, thank you so much for all your hard work that I now get to use. This is a great tool for so many that need xlsx reports for clients these days.
  14. gbcpastor

    WorkbookXLSX R30

    Absolutely perfect. Thank you so much. I appreciate all your help.
  15. gbcpastor

    WorkbookXLSX R30

    Sure.
  16. gbcpastor

    WorkbookXLSX R30

    I would have loved to say all fixed. But while it did run correctly, the result was still the same even after the changes you sent. Please let me know if you have any other ideas. (I'm willing to send all I have on this if it would help)
  17. gbcpastor

    WorkbookXLSX R30

    I'm really hoping this will work. Right now, when I run the code, I get an error. I'm not understanding why this is. The class is in the same folder.
  18. gbcpastor

    WorkbookXLSX R30

    In the file I attached, the first field that has leading spaces is A3 so the A1 doesn't work. I'm using version 2013 excel. I'd love to know how to force the single quote formatting without showing the single quote. There has to be a way to do it, I just haven't been able to figure it out. I...
  19. gbcpastor

    WorkbookXLSX R30

    Right Aligned would trim the space to the right causing a new error.
  20. gbcpastor

    WorkbookXLSX R30

    When I look at the spreadsheet, in the cell I'm creating, it has the single quote showing as the first character and it adds 1 to the length of the actual data. Take a look.

Part and Inventory Search

Back
Top