Recent content by billyng

craigsboyd, your code works great. Thanks!

Good point, I always mix up () with []. Thanks!

Hey, it works. Thanks! By the way, how come I don't nned to use EXTERNAL ARRAY in a function or procedure for passing array? The compiler only complains it when it is in a form's method.

Hi folks, I am trying to pass an array to a user define method with the following code In the command button's click event SELECT firstname, lastname ; FROM users ; WHERE id=123 ; INTO ARRAY aUser THISFORM.runautofill(@aUser) In the form's runautofile method LPARAMETERS...

I guess I need to try the 3rd party lib. Thanks folks!

Hi folks, I am using VFP 8. I notice there is a "Save As HTML" option in the File menu. I look at some other people posted the related questions here. Most of the suggestions were using frx2word. Is it impossible to programmically save the report to HTML with this built-in festure? If it...

Thank you all your good tips!

Hi folks, I have a ListBox that list all the items in different categores. Since there are too many, I want the items to be color coded base on their categories. Is it possible? Thanks! Billy

good point, thanks!

Very cool, thanks!

Cool, I should have looked at the pageframe properties. Thanks!

Thankss guys. It looks so much better now.

Hi folks, Is there an easy way to find out a page in the pageframe is selected? Thanks! Billy

Hi folks, I run a query and store the result into an array for the list box. If there is no result from the query, the list list box will show a line with .F.. How can I display an empty list instead of one line of .F. when the result is empty? Thanks! Billy

Good point, I should use FOUND() to see if I can LOCATE. Thanks! By the way, does it mean RLOCK() will be released after I close the table? Thanks! Billy Ng