ProFox

profox@leafe.com

2704 discussions

[NF] Chromebook update
by Michael Madigan 04 Nov '16

04 Nov '16

Just a heads-up for Chromebook users, mine was freezing quite a bit, but after I upgraded it to the latest version, it has been much more stable. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

ProFox List Statistics for October 2016
by List Administrator Account 04 Nov '16

04 Nov '16

================================================== ProFox List Statistics October 2016 ================================================== Subscriber Count at End of Month: ProFox: 286 ProFoxTech: 186 ================================================== Total Posts: 187 (Down 26.09% from September 2016) Total [OT] Posts: 0 (Unchanged from September 2016) Total [NF] Posts: 53 (Up 23.26% from September 2016) Daily Message Counts for October 2016 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 5 S 2 - 2 M 3 - 4 T 4 - 1 W 5 - 7 T 6 - 5 F 7 - 1 T 11 - 11 W 12 - 5 T 13 - 3 F 14 - 5 S 15 - 1 M 17 - 8 T 18 - 24 W 19 - 10 T 20 - 21 F 21 - 26 S 22 - 2 S 23 - 4 M 24 - 6 W 26 - 3 F 28 - 29 S 29 - 4 Message Counts By Day of Week for October 2016 ------------------------------------------------ DOW Count --- ----- Sun - 6 Mon - 18 Tue - 36 Wed - 25 Thu - 29 Fri - 61 Sat - 12 Distinct Posters to the List (changes relative to September 2016) ------------------------------------------------ Non-OT messages: 45 (Down 4.26%) OT messages: 0 (Unchanged) NF messages: 18 (Down 10.0%) Total number: 45 (Down 4.26%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 19 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 16 Ted Roche 3. 15 Man-wai Chang 4. 15 Dave Crozier 5. 12 Ken Kixmoeller (ProFox) 6. 10 Alan Bourke 7. 9 Mike Copeland 8. 7 Kurt Wendt 9. 7 Stephen Russell 10. 6 Tracy Pearson 11. 5 Richard Kaye 12. 4 Charles Hart Enzer, M.D. 13. 4 José Enrique Llopis 14. 3 Gene Wirchenko 15. 3 AndyHC 16. 3 Michael Glassman 17. 3 Fernando D. Bozzo 18. 3 Paul Hill 19. 3 Sytze de Boer 20. 2 Darren Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 18 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Ken Kixmoeller (ProFox) 2. 5 Mike Copeland 3. 4 Charles Hart Enzer, M.D. 4. 4 Ted Roche 5. 4 Alan Bourke 6. 3 Man-wai Chang 7. 3 AndyHC 8. 3 Kurt Wendt 9. 3 Stephen Russell 10. 2 <vrfx(a)optonline.net> 11. 2 Paul Hill 12. 2 Gene Wirchenko 13. 1 Chris Davis 14. 1 Garrett Fitzgerald 15. 1 Michael Oke, II 16. 1 Ken McGinnis 17. 1 Dave Crozier 18. 1 Kevin J Cully Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 19 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 16 Ted Roche 3. 15 Man-wai Chang 4. 15 Dave Crozier 5. 12 Ken Kixmoeller (ProFox) 6. 10 Alan Bourke 7. 9 Mike Copeland 8. 7 Kurt Wendt 9. 7 Stephen Russell 10. 6 Tracy Pearson 11. 5 Richard Kaye 12. 4 Charles Hart Enzer, M.D. 13. 4 José Enrique Llopis 14. 3 Gene Wirchenko 15. 3 AndyHC 16. 3 Michael Glassman 17. 3 Fernando D. Bozzo 18. 3 Paul Hill 19. 3 Sytze de Boer 20. 2 Darren Top 18 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 2 Stephen Russell 3. 2 Man-wai Chang 4. 2 Charles Hart Enzer, M.D. 5. 1 List Administrator Account 6. 1 Sytze de Boer 7. 1 Wes Wilson 8. 1 Ken McGinnis 9. 1 Allen Pollard 10. 1 rafael copquin 11. 1 Garrett Fitzgerald 12. 1 Alan Bourke 13. 1 Dave Crozier 14. 1 Ted Roche 15. 1 William Tormey 16. 1 Kurt Wendt 17. 1 Gene Wirchenko 18. 1 Ken Kixmoeller (ProFox) Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 27 Speeding up a Powershell script 2. 26 [NF] Save Video from cable TV 3. 21 Friday Poll (while dl'ing MS Flash Patch) 4. 10 Problem with VFP IDE (VFP9SP2, fully patched) 5. 10 Chilkat SFTP component. 6. 9 Excel errors 7. 7 Taking a screenshot of "yourself" 8. 7 Command button to take a photo 9. 6 sweetpotato 10. 6 Sending HTML email from CDO? 11. 5 [NF] A Commodore 64 has helped run an auto shop for 25 years 12. 5 Connection Strings for SQL SERVER 13. 5 [NF] Low Message Volume or Other Problem? 14. 4 Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden 15. 4 [NF] VMWare Player Not Finding Host Printers 16. 4 [NF] Need SyncBackSE alternative 17. 4 SQLite & Thunderbird - (Was - Friday Poll (while dl'ing MS Flash Patch)) 18. 4 [NF] Job hunting humor 19. 4 Best way to determine file size from VFP9SP2 app using Excel automation 20. 4 [ADMIN] Help me raise money for MS Research Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 27 Speeding up a Powershell script 2. 26 [NF] Save Video from cable TV 3. 21 Friday Poll (while dl'ing MS Flash Patch) 4. 10 Problem with VFP IDE (VFP9SP2, fully patched) 5. 10 Chilkat SFTP component. 6. 9 Excel errors 7. 7 Taking a screenshot of "yourself" 8. 7 Command button to take a photo 9. 6 sweetpotato 10. 6 Sending HTML email from CDO? 11. 5 [NF] A Commodore 64 has helped run an auto shop for 25 years 12. 5 Connection Strings for SQL SERVER 13. 5 [NF] Low Message Volume or Other Problem? 14. 4 Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden 15. 4 [NF] VMWare Player Not Finding Host Printers 16. 4 [NF] Need SyncBackSE alternative 17. 4 SQLite & Thunderbird - (Was - Friday Poll (while dl'ing MS Flash Patch)) 18. 4 [NF] Job hunting humor 19. 4 Best way to determine file size from VFP9SP2 app using Excel automation 20. 4 [ADMIN] Help me raise money for MS Research

10 13

Re: Friday Poll (while dl'ing MS Flash Patch)
by Gene Wirchenko 03 Nov '16

03 Nov '16

At 06:00 2016-10-28, Ted Roche <tedroche(a)gmail.com> wrote: >So, where's your data stored today? > >__ DBFs > >__ MS SQL Server > >__ Azure > >__ Postgres > >__ My/MariaDB > >__ Oracle > >__ Excel > >__ Other (please specify) As possibly the last to answer -- is there a prize? -- let me state DBFs. [snip] Sincerely, Gene Wirchenko

2 1

2 GB memo bloat in DBF used in WebConnection site (was RE: Friday Poll (while dl'ing MS Flash Patch))
by mbsoftwaresolutions＠mbsoftwaresolutions.com 03 Nov '16

03 Nov '16

On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file. I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea? tia, --Mike

2 2

Friday Poll (while dl'ing MS Flash Patch)
by Ted Roche 03 Nov '16

03 Nov '16

So, where's your data stored today? __ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to patch NOW. After answering the poll, of course.) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

16 22

Renaming a project
by mbsoftwaresolutions＠mbsoftwaresolutions.com 03 Nov '16

03 Nov '16

If you wanted to rename a project, would you create a new PJX with the right/desired name, or would you just rename the existing PJX/PJT? Just curious.

3 3

M$ OCX Date Picker Problem!
by Kurt Wendt 03 Nov '16

03 Nov '16

Hello there ProFoxers! 1st of all - Happy TGIF! I'm trying to find out who else may have this particular problem. Here's the URL to an image of the Date Picker being used within a system here at my job: http://imgur.com/a/ZlGZu Initially - the problem with the Date Picker caused the system to Crash. Why you might ask? Because the system was trying to set a default date for the Date picker. This was the specific error that was being thrown: "Ole IDispatch exception code 0 from DTPicker: A date was specified that does not fall within the MinDate and MaxDate properties..." At first I wasn't sure what was causing the problem. Turns out - I went to another screen that had the Date Picker running on it - which is the above screen. When I went into that screen - the dates were set to 9/1 - 9/30/16. This is because this report is generally run on the 1st of the month for the prior month. So - upon trying to set the dates to Oct month range - then the problem is apparent. Notice the grey circle around the 25th of the month - although you probably can't see it in this screen shot. But, the picker no longer allows you to pick ANY Date Beyond the 25th of October! And, trying to set the default date to end of Oct. during the startup of another report screen - That is what caused it to Crash. Needless to say - this is an OCX from M$ - and its fairly standard. So - I figured others may be using it in their systems - which are May NOT be FoxPro systems. If so - you will ALSO have the problem. So - I'm curious - has anyone else here experienced the problem? Thanks! Kurt Wendt Senior Systems Analyst [GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/> One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.com<https://www.globetax.com/> GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---

3 4

Word doc on invoice
by Sytze de Boer 02 Nov '16

02 Nov '16

My client enters invoice details using Word.exe I need to print the word document on a Fox report I know there may be better ways, but this is how it has to run. I can only find 1 way to do this. i.e. Convert the Doc file to a Jpg file. I have this working except for the fact the conversion is screwing the size/font of the original Doc file. Are there other ways? -- Kind regards, Sytze de Boer --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

What is the maximum number of Tags i can have in a CDX file?
by Michael Madigan 02 Nov '16

02 Nov '16

What is the maximum number of Tags i can have in a CDX file? Specifically for a FPW 2.6 database. I can't find this number anywhere. Thanks --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Excel automation - insert picture into a cell
by Peter Cushing 01 Nov '16

01 Nov '16

Hi, Just want to see if anyone has any experience of inserting pictures into Excel using Excel 2010 onwards. Been doing this for years using Excel 2000 (Yeah, I know a bit old but works great) and outputs an .XLS with some example code: cFile = "\somefolder\somefile.jpg" cOutfile "\myfolder\outfile.xls" objexcel = CREATEOBJECT('excel.application') objexcel.Workbooks.Add OBJexcel.Rows("2:2").RowHeight = 77 objexcel.Range("A2").Select objexcel.ActiveSheet.Pictures.Insert(cFile).Select objexcel.Selection.shaperange.height = 77 * add more pics into different cells objexcel.ActiveWorkbook.SaveAs(cOutfile, xlWorkbookNormal) objexcel.ActiveWorkbook.Close objexcel.Quit We usually output a spreadsheet of data and leave the first column blank so we can move through it and insert a picture. Now we need to move to Office 365 to get a bit more up to date and output .XLSX files. :-( I'm using office 2013/VFP 9 and the pictures it inserts are just links so that when you send it to somebody they can't view them. Done lots of searching of the internet and the archives etc and found an extra parameter for the insert: objexcel.ActiveSheet.Pictures.Insert(cFile,.t.).Select but this seems to make no difference set to .t. or .f. There seems to be another way of doing it using shapes. objexcel.application.activesheet.shapes.addpicture("H:\img_0536.jpg",.f.,.t.,1,1,100,100) but I then need to move them to the correct location so still playing with that option. Any help appreciated. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960

2 2

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox