Recent content by baileybelle

How would you use the BROWSE command to search a table between two dates and meeting another criteria? For example using an SQL statement I might use something light this.. SELECT * FROM tablename WHERE date between date1 and date2 AND companyname = 'ABC' How could this be accomplished with...

I was wondering if it was posible to have a control array in VFP similar to the way it can be done in VB. For example, I would like to loop through certain text boxes and populate table field values doing something like this: With ThisForm For i = 1 to Recount() .textbox(i).value =...

What is the proper way to release an object from memory in foxpro? For example, if I created an instance of an Excel application using the following: objExcel = CREATEOBJECT("Excel.Application")

Is it possible to use Ramani's collection loop FOR EACH m.oThis IN ThisForm.Controls WAIT WINDOW m.Othis.Caption ENDFOR to just include certain form objects? For example print just the .caption for all labels. thanks

I would like to clear the contents of each text box on a form using the 'For Each' command. what would the proper syntax be to accomplish this? Thanks in advance.

In the KeyPress event of a text box I would like to force capitalization. I am using the following w/out success: nKeyCode=asc(upper(chr(nKeyCode))) What would the proper syntax be to accomplish this? Also. does anyone know how to highlight the contents of a text box when it recieves focus...

That seems to be just what i need but, for some reason the file contents are not going to the printer. they are being displayed on my form. I am using the command you suggested above: TYPE myTextFile.txt TO PRINTER PROMPT any idea what i am doing wrong? thanks again for you help bailey

thanks ramani!! will this work if i want to print a .txt file also? if not, how could that be accomplished. bailey

I am new to VFP and would like to be able to send a file to a local printer from an application. Could someone please point me in the right direction to accomplish this? Thanks in advance for any response. bailey

I am new to foxpro and was wondering of people could recommend good teaching websites and/or books that explain the syntacs and functions. Thanks alot