clix.info

hdegroot.blogspot.com

Hans de Groot: A resize grip on a Foxpro form

http://hdegroot.blogspot.com/2006/09/resize-grip-on-foxpro-form.html

Mostly about Visual Foxpro. Sep 29, 2006. A resize grip on a Foxpro form. As a visual clue that a form can be resized, many forms have a 'resize grip' in the lower right corner. Visual Foxpro does not have native support for showing a resize grip on a form. But that won't stop us, we can make our own! You can download a zip file containing a resizer class. It's based on a container class and constructs it's own grip shape (Windows XP style). Just drop the class on a form and add. View my complete profile.

hdegroot.blogspot.com

Hans de Groot: May 2009

http://hdegroot.blogspot.com/2009_05_01_archive.html

Mostly about Visual Foxpro. May 17, 2009. Syntax checking on e-mail addresses. You can use the following code to validate e-mail addresses in your Foxpro applications. LOCAL cDomains, cPiece, cMessage, cNum, lDomain, lemailname. LDomain = .t. LEmailname = .t. Cdomains = '"aero", "asia", "biz", "cat", "com", "coop", ' ;. Edu", "gov", "info", "int", "jobs", "mil", "mobi", "museum", ' ;. Name", "net", "org", "pro", "tel", "travel"'. Some extra checks which are not tackled below. LEmailname = .f. RETURN (lEm...

hdegroot.blogspot.com

Hans de Groot: July 2007

http://hdegroot.blogspot.com/2007_07_01_archive.html

Mostly about Visual Foxpro. Jul 26, 2007. Is MS Office installed on a computer? There are more ways to detect if MS Excel, Outlook or Word is installed on a computer. One way is, to look it up in the Window registry. The following code does exactly that. Code that shows if Outlook, Word and Excel are installed:. Ckey = "Software Microsoft Windows CurrentVersion App Paths outlook.exe". OutlookExists = readregstring(-2147483646, ckey, "path"). WinWordExists = readregstring(-2147483646, ckey, "path"). Retur...

hdegroot.blogspot.com

Hans de Groot: Listgrid - update 3

http://hdegroot.blogspot.com/2006/10/listgrid-update-3.html

Mostly about Visual Foxpro. Oct 1, 2006. Listgrid - update 3. In this third update of the listgrid control, it is possible to change the grid's record source at run time. There is a new 'Open file' button in the example form that shows how. Further, to solve the second issue in the post of july 30th, the width of the rightmost column in the grid is now changed to span the gap that normally appears when the total with of the visible columns are smaller than the grid's width. There is a new method.

hdegroot.blogspot.com

Hans de Groot: Function that returns a part of a comma-separated string

http://hdegroot.blogspot.com/2008/08/function-that-returns-part-of-comma.html

Mostly about Visual Foxpro. Aug 1, 2008. Function that returns a part of a comma-separated string. Whenever you need to to handle comma-separated string, you might want to check the function below, which makes use of VFP's ALINES() function to return a certain value in the string. Parameters: String (character) , which part (numeric), delimiter (character). PARAMETERS cCsv, nPart, pdelimiter. PDelimiter = ",". CCsv = STRTRAN(cCsv, pDelimiter, " " CHR(13) ). ALINES(aCsv, cCsv , .T.).

hdegroot.blogspot.com

Hans de Groot: Images in a VFP grid class

http://hdegroot.blogspot.com/2006/09/images-in-vfp-grid-class.html

Mostly about Visual Foxpro. Sep 2, 2006. Images in a VFP grid class. In the listgrid class in this blog, it is possible to have different images in the cells of the same column in a grid. This is done using the DynamicCurrentControl feature and works great if there are only a few images. When you have a lot of images to show, it seems like a bad idea to add even so much image controls to the grid column. Luckily, there is another way to do the same. I found out about this here. Hey man you save my day!

hdegroot.blogspot.com

Hans de Groot: Importing an Excel spreadsheet in VFP using Excel

http://hdegroot.blogspot.com/2007/06/importing-excel-spreadsheet-in-vfp.html

Mostly about Visual Foxpro. Jun 29, 2007. Importing an Excel spreadsheet in VFP using Excel. De native IMPORT function of Visual Foxpro doesn't allways do a good yob. For example, sometimes it converts numbers to date values (01-01-1900). The code below uses office automation to let Excel itself export the spreadsheet to dBase format. Also, you don't have to know in which version of Excel the spreadsheet is created, like you have to with the IMPORT function. Run the .PRG file like:. IF PCOUNT() = 1.

hdegroot.blogspot.com

Hans de Groot: July 2006

http://hdegroot.blogspot.com/2006_07_01_archive.html

Mostly about Visual Foxpro. Jul 30, 2006. Listgrid - update 2. When using the vertical scroll bar to move through the grid, there where problems with the screen painting. Screen painting issues are also mentioned in VFP's help about the Scrolled event. However, it's now solved by changing some code in the Scrolled event of the grid. I also found two new issues to think about:. An updated download is available here. ZIP compressed file, 44 kb). Jul 17, 2006. The listgrid control stopped responding, when y...

hdegroot.blogspot.com

Hans de Groot: June 2007

http://hdegroot.blogspot.com/2007_06_01_archive.html

Mostly about Visual Foxpro. Jun 29, 2007. Importing an Excel spreadsheet in VFP using Excel. De native IMPORT function of Visual Foxpro doesn't allways do a good yob. For example, sometimes it converts numbers to date values (01-01-1900). The code below uses office automation to let Excel itself export the spreadsheet to dBase format. Also, you don't have to know in which version of Excel the spreadsheet is created, like you have to with the IMPORT function. Run the .PRG file like:. IF PCOUNT() = 1.