ProFox

profox@leafe.com

2704 discussions

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

Weird Compilation error
by Dave Crozier 23 Aug '16

23 Aug '16

Gentlemen, I have a VCX library which we have developed that uses collections and I keep getting a compilation error: Visual Class Library d:\dev\flexipol\flexispec\classes\traffic_light.vcx has the following errors: Unknown OCOLLECTION_X - Undefined The collection is mainly used in the "myRefresh" event of the component (base class is a container) and is initialised to null on the property sheet, subsequently getting populated in the actual <<container>>.oCollection_Assign method:: * ControlSource_Assign Method Lparameters vNewVal Local oCollection_1 As Collection Local I This.oCollection = Evaluate(vNewVal) This.Control_Source = m.vNewVal oCollection_1 = This.oCollection ... etc. The collection thus assigned is manipulated in the myRefresh method and basically parsed through element by element refreshing a discrete control for every instance in the collection. * myRefresh Method Local oCollection_x as Collection local I local oLight Local lDoTextMerge local cOldAlias cOldAlias = Alias() oCollection_x = This.oCollection I=1 For Each oObj In oCollection_x ... etc etc. All the coding works despite this damned error being thrown at compile time and I have tried all types of External commands thinking that the oCollection not being found could be fixed as you do with external arrays. However there isn't an "External Collection" command... so I am now stuck! Any ideas? Dave

3 4

ProTip: Filer on Win10 64-bit
by Ted Roche 23 Aug '16

23 Aug '16

While trying to test solutions to Sytze's question, I wanted to use Filer to locate some files, and got an error 1733 when trying to run the program: DO form HOME(6)+"filer\filer" When you try to execute the find, it reports that Filer.dll is not registered, and offers to do this for you. It then reports failure, Error 1733, method find, line 42, Class definition FILER.FILEUTIL is not found. Here's the trick: Locate the two VC runtime DLLs MSVCR71.DLL and MSVCP711.DLL Start a command prompt with Administrator access and navigate to the Filer directory Issue: regsvr32 filer.dll and you should get a success message. If it fails or things go funky, try: regsvr32 /r filer.dll to un-register the COM DLL and you can try again. Hat tip to the Fox Wiki at http://fox.wikis.com/wc.dll?Wiki~Filer~WIN_COM_API for the clue! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox