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 SkipVought 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. vgulielmus

    Kyocera FS6525 printer - F245 Error

    Hi, We have four (4) Kyocera FS6525 printers. These are network printers and we use them both as printers and as scanners. One of them already has two PC's added in the address book (for scanning). Now I try to add a new entry, and all goes well, until I try to save it into address book. I...
  2. vgulielmus

    How to get the last transaction record

    In VFP you can do it in threes steps, like this: * first get the record number of each record Sele RECNO() as myId,* from a mytable into cursor mycursor * second get the last record number of each icode SELECT max(myid) as myid,icode from mycursor group by 2 into cursor mycursormax * finally...
  3. vgulielmus

    Need help understanding a piece of code

    The next function can give you some ideas: CLEAR ?[MBT1006],GoodString([MBT1006]) ?[1006MBT],GoodString([1006MBT]) ?[12345],GoodString([12345]) ?[TE],GoodString([TE]) ?[Only alpha but too many (not exactly 2)],[TEA],GoodString([TEA]) ?[Two few alpha], [TE3210],GoodString([TE3210]) ?[Two few...
  4. vgulielmus

    SQL SELECT brain dead

    Mike Lewis, I will try the same prg on another PC. I noticed some strange behavior. Version of VFP is 9.0.7423 The two images: and Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  5. vgulielmus

    SQL SELECT brain dead

    Obviously, the best advise is to output the result otherwise, e.g. using Copy To, but I am intrigued by the behavior of SELECT ... TO I noticed that SET HEADINGS have a significant impact on the output.When SET HEADINGS is OFF, the width starts with 4, and increase with 4 or 5 / character...
  6. vgulielmus

    SQL SELECT brain dead

    I've made a small test. You can see that for 1 to 5 characters, VFP force the length to 21 characters Then for each additional characters, the length is increased sometimes with 4, other times with 5 characters. Don't know how to reduce the size, nor to control it. I tried several commends, like...
  7. vgulielmus

    Animated cursor generator

    I enhanced (in the same FAQ) the function. Now you can specify the order of images (frames) and the delay (speed) of each frame. In the next example five icons are used to create an animation with 8 frames. The last frame stay longer than the other 7. CLEAR RESOURCES CLEAR ALL LOCAL laIcons[5]...
  8. vgulielmus

    Animated cursor generator

    Just posted a new faq184-7922 Not sophisticated, but useful. Maybe I will enhance later. Enjoy Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  9. vgulielmus

    Animated cursor generator

    ico2ani is a function that creates ANI files (animated cursors) from ICO or CUR files Has three parameters: - lcAni (in) string, Name of the resulted (ANI) file - laIcons (in) array passed by reference, array containing fully qualified source files (icons or cursors) - lnDelay (in, optional)...
  10. vgulielmus

    FoxPro Excel Automation

    First of all, I apologize, no offense intended. I'm pretty sure you already know that SysWOW64 is for 32 bit applications under 64 bit OS. Almost certain this is not the cause of your problems. You mentioned that oWorkbook = oExcel.Application.Workbooks.Add() oExcel.Visible = .T. runs with no...
  11. vgulielmus

    FoxPro Excel Automation

    Like Tamar Granor, I also suspect the readonly state. Please read Workbooks.Open Method Pay attention to several parameters, like IgnoreReadOnlyRecommended, Notify or CorruptLoad (but may be other that solves your problem). As a final thought, have you tried to open the workbook in Excel, no...
  12. vgulielmus

    Export DBF to MsOffice

    Version 4 for VFP9 and 2/3 for VFP6 (January 2017). Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/http://files.engineering.com/getfile.aspx?folder=a1b18b7a-d6ef-4918-9a3a-1f82fecf968e&file=DBF2MSOFfice_201701.rar
  13. vgulielmus

    change the font size with Anchor property

    Please try this. Resizer/magnifier class Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  14. vgulielmus

    Import text From Writer

    A simple function that extracts the text contained in a Writer odt document, and creates a txt file with the same name. Download links https://www.dropbox.com/s/neavhs36739zqse/importoowrtext.zip?dl=0 Respectfully, Vilhelm-Ion Praisach Resita, Romania...
  15. vgulielmus

    Import tables from OpenOffice / LibreOffice documents (Calc's ods, Impress' odp or Writer's Odt)

    Description A single unfied function to import data from tables contained in OpenOffice / LibreOffice documents (Calc's ods, Impress' odp and Writer's odt) The signature is the same used for ImportFromOoCalc https://www.foxite.com/archives/import-from-calc-ooffice-0000439109.htm The data are...
  16. vgulielmus

    Export functions and procedures DBF to OpenOffice Writer (odt) and Calc (ods)

    Thank you :-) Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  17. vgulielmus

    Export DBF to Excel 2007+ ( version for VFP6)

    A downgraded version of CopyToXlsx, changed to run under VFP 6. The new function was renamed CopyToXlsx6 Download link Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  18. vgulielmus

    Import From Openoffice Calc into DBF

    Signature similar to the corresponding function fro MSOffice. Import From Openoffice Calc 1.0 Download link Details Respectfully, Vilhelm-Ion Praisach Resita, Romania http://praisachion.blogspot.com/
  19. vgulielmus

    Export functions and procedures DBF to OpenOffice Writer (odt) and Calc (ods)

    Similar in signature, respectively properties, with the corresponding functions and classes created for MsOffice. Function CopyToOds 2.0 Download link Class ExportToOds 1.0 Download link Details FunctionCopyToOdt 3.0 Download link Class ExportToOdt 2.0 Download link Details Respectfully...
  20. vgulielmus

    Take Input in proper without Changing Caps Lock on or off

    Some precaution must be made because you can select a portion of text and replace the entire selection with a dot. PUBLIC ofrm ofrm = CREATEOBJECT("MyForm") oFrm.Show() DEFINE CLASS MyForm as Form ADD OBJECT txt1 as textBox WITH InputMask = REPLICATE("X",200),MaxLength = 200, width = 300...

Part and Inventory Search

Back
Top