ProFox August 2016

profox@leafe.com

49 participants
61 discussions

[ADMIN] Checking the spam filter
by Ed Leafe 30 Aug '16

30 Aug '16

I recently modified the spam filter, and I think I forgot a setting. I just changed it back, and am now testing this. If you see this, it’s working. :) If you sent anything to the list in the last few hours that didn’t show up, please resend it. -- Ed Leafe

2 1

[NF] HP m277dw and Office 2007
by Man-wai Chang 29 Aug '16

29 Aug '16

My sister bought a new HP m277dw printer for her Windows 8 PC. The printer supports both USB and wireless modes. I think it got a RJ45 LAN port, but it's not being used. I installed the latest driver for that printer downloaded from HP website. Word 2007 failed to print to it directly, when all other programs (e.g. Notepad and Chrome) could. Running Word 2007 as administrator fixed the problem, but that's not the best solution. Then I found the HP Universal Driver PCL5. Word 2007 could print to the m277dw via this virtual printer without issues, and without the need to elevate security to administrator. I noticed that the Universal PCL5 driver was printing to the wireless connection of m277dw, not the USB connection. The stock printer driver printed via the USB connection, but Word 2007 kept saying that the printer was offline. Now, what's happening here? I just cannot comprehend it... BTW, my sister installed Office 2013 once. I wonder whether it messed up the security settings of all printers, or did it only affect Office 2007? But that should not have happened... -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

1 0

VFP - Missing Printer Dialog
by Desmond Lloyd 29 Aug '16

29 Aug '16

When printing our reports from our VFP app we usually get a "print dialog" (from preview) with a way to navigate from page to page, and more importanly print! Had a user lose that dialog, am assuming he pressed the escape key. In any event how do we get it back? ....been a long week... TIA, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 8

VFP Call to Google Geocoding API
by Dave Crozier 29 Aug '16

29 Aug '16

Gentlemen, Just started Geocoding all our customers and interfacing the Google maps to our VFP system here and it is going well in that we can now display interactive graphs of customers/prospects for our sales staff and throw the links to the graphs into the reps Google calendars on their phones/tablets/laptops... so far so good. However, I have a question and I guess I am being a little lazy here, as I can't be bothered sifting through all the non-useful so called solutions on the net. The example Google API call for Geocoding given here: https://developers.google.com/maps/documentation/geocoding/start returns back a JSON response and I want to easily catch this from VFP ideally without showing the web interface. Any ideas as to the best approach to initiate this data and capture the response? For the maps I have used the approach whereby VFP generates a HTML Page and embeds a map from a list of lat/long co-ordinates that are embedded into the page which works fine as I don't actually receive any data back, unlike the JSON response. I guess it is going to be a little like the web services that were the rage some time ago .... I stayed away from them. I would prefer 100% VFP but don't mind going the called C# program if I have to. Any ideas? Dave

12 16

Flat file to Excel....but it's got more than 255 columns!
by mbsoftwaresolutions＠mbsoftwaresolutions.com 25 Aug '16

25 Aug '16

VFP9SP2/Win7Pro/SDF fixed width file I've got a flat file that needs to be translated to an Excel file. Traditional program put it into a cursor and then via automation did copy/paste into Excel. Problem is now that there are more than 255 columns (410 to be exact) so using a VFP cursor/table won't work. I was just doing direct string manipulations and insertting right to the Excel cells, but it's a SLOW process. It works, but I'm always looking for a better way. Suggestions for approach? tia!

10 19

Report label caption expression
by Joe Yoder 25 Aug '16

25 Aug '16

I want the header on a report to display the year from a variable along with some text. When I set the value to "str(m.Year) + 'Auto Mileage Report'" that string is displayed rather than "2015 Auto Mileage Report." I think I solved this years ago with the use of a special character or syntax but I can't remember what it was. Thanks in advance for any help, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

RE: Disabled CheckBox Colour
by Kent Belan 25 Aug '16

25 Aug '16

On checkbox controls we use the ReadOnly property instead of the enabled property to control user access and it looks much better HTH, Kent -----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of John Weller Sent: Wednesday, August 24, 2016 3:37 PM To: profox(a)leafe.com Subject: Disabled CheckBox Colour I have a form with several check boxes on it. They are initially disabled but are enabled when the user clicks the Edit button. I have set the Disabled ForeColor to 0,0,0 so the caption is always black but when the box is disabled the tick is a light grey and can hardly be seen. Is there any way I can make the tick be the same colour when disabled as when enabled? TIA John John Weller 01380 723235 07976 393631 [excessive quoting removed by server]

3 2

Disabled CheckBox Colour
by John Weller 24 Aug '16

24 Aug '16

I have a form with several check boxes on it. They are initially disabled but are enabled when the user clicks the Edit button. I have set the Disabled ForeColor to 0,0,0 so the caption is always black but when the box is disabled the tick is a light grey and can hardly be seen. Is there any way I can make the tick be the same colour when disabled as when enabled? TIA John John Weller 01380 723235 07976 393631

1 0

Updating a listbox
by Joe Yoder 23 Aug '16

23 Aug '16

I have a form that displays records from a table in a listbox. A "New" button adds a record to the table and calls a detail form that allows entering data to the blank record. When the detail form closes I want the listbox on the original form to display the new record. Its not working.automatically. A mouse click anywhere on the list box causes it to resize and display the new record. I looked for a way to programatically simulate the physical mouse click but so far haven't found one. Here is the code in the button click event: GOTO bottom APPEND blank thisform.list1.refresh DO FORM PMdetail thisform.list1.refresh thisform.UpdateTot && Update the total and refresh the form thisform.list1.click I know there are better approaches but it seems this should work. Any ideas? TIA - Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Too simple report?
by Joe Yoder 23 Aug '16

23 Aug '16

I have a report that amounts to simply printing each record from a table. There is no subgrouping of the data. All that is needed is a grand total at the bottom. How does one setup the report writer to get and print the total? TIA - Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox August 2016