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 strongm 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: *

  • Users: simo
  • Order by date
  1. simo

    Transfering companies

    What is the error message your getting and what OS are you running? david@e-controller.com
  2. simo

    Want to print source code in color - How ??

    Release it, release it, it sounds cool - or tell use how you coded it ;-)
  3. simo

    Exporting Visual Reports

    Thanks very much, I think that Amyuni has exactly the tools that I was looking for. Cheers.
  4. simo

    Fatal Error Exception Code=C0000005

    I sometimes get this error in Visual, when using forms as objects, which are members of other objects, and then showing / hiding them. My documentation says the following: 'Record your recent actions and contact Microsoft Support' I think that this is an internal FoxPro error, and my error...
  5. simo

    Exporting Visual Reports

    Does anybody here know if there is a control available which allows FoxPro reports to be exported to PDF format?
  6. simo

    I have a recurring problem when inserting items into a table using VFo

    That sounds like a good suggestion, I will try it, thanks for your help! Regards Simon
  7. simo

    I have a recurring problem when inserting items into a table using VFo

    I don't think that this is the problem really, because the file is opened at the beginning of my program (and it is shared) and then written to often by my program - so I am not trying to open it, and because it is already open, it cannot be in use by another user exclusively as I would get a...
  8. simo

    I have a recurring problem when inserting items into a table using VFo

    I have a recurring problem when inserting items into a table using VFox 6, using Novell as the Network OS. At seemingly random intervals, the system crashes with a FILE 108(file is in use by another user) error. I am simply using the INSERT INTO command, with a table that is already open, so...
  9. simo

    DDEInitiate and Excel

    Hiya, I am trying to use the DDE functions to program Excel from Fox for Windows 2.6, however, the DDEInitiate command fails and cannot start Excel under Windows 9.x / 2000. I therefore resorted to run /n start excel.exe and then making the connection, which is cool in 9.x , however, under...
  10. simo

    Exporting formatted data to Excel quickly

    No, the system needs to create the table that holds the data to export in the first place.&nbsp;&nbsp;It is this that takes the time.<br><br>The user wishes to extract sales information, selectable by product and customer for a year, starting on any month, and for each month, sales qty's and...
  11. simo

    Exporting formatted data to Excel quickly

    The average data set is about 900 records x 27 fields of 10.2 numeric format.<br><br>This equates to about 12 pages in Excel.<br><br>I don't think that this size is in any way excessive really, it's just that Excel was really slow.<br><br>Simon<br><br>
  12. simo

    Exporting formatted data to Excel quickly

    Jon, I tried the method you suggested and now instead of taking 60 minutes to run, it takes 1 - I think as a percentage, that is quite an impressive speed improvement!<br><br>I was a complete pain to re-do my code to work but is was worth it in the end(and I will know for next time)...
  13. simo

    Exporting formatted data to Excel quickly

    That sounds like a really good idea..<br>I will try it and see if it makes an approvement.<br>Thanks,<br><br>Simon.<br>
  14. simo

    Exporting formatted data to Excel quickly

    What I do is get my report data into a cursor, then in a loop, enter all the fields and records into an Excel Object, e.g.<br><br>FOR colCount_n = 1 to (COLTOTAL_N - 1)<br> excelAutoObject_o.Cells(rowIndex_n,colIndex_n).NumberFormat = &quot;0.00&quot;<br>...
  15. simo

    between forms

    Performance: starting the application and closing down the application I do find is slower than normal, however, once the application has opened I find that because forms are already initialised as objects they pop up on the screen extrememly fast.<br><br>I also open all my tables at the start...
  16. simo

    Exporting formatted data to Excel quickly

    I've had a look at the export command, and yes, it is really, really fast, but unfortunatly it does not allow you to store format information (such as bold, text size, underlining etc)&nbsp;&nbsp;<br><br>You may think that I am asking to much, but one of my customers who used to spend 4 or 5...
  17. simo

    between forms

    I create objects, say for a customer, and then create properties which are form objects.&nbsp;&nbsp;This way, all properties and methods of all form objects belonging to the customer object, say, are accessible to every other object belonging to the customer object(including the customer object...
  18. simo

    Exporting formatted data to Excel quickly

    I need to be able to export data from foxpro into an Excel spreadsheet with formatting.<br><br>I've tried creating an Excel object and setting the cell object properties but this is too slow.&nbsp;&nbsp;<br><br>I was wondering if there was an API or somthing similar for creating Excel workbook...

Part and Inventory Search

Back
Top