Search results for query: *

Hello Experts, Ive Created a small program that scans through my email and automatically converts word docs to pdf and sends email back to sender. However, if there are no emails with subject = Convert2PDF found it results in error and crashes my application. Ive googled around and came...

Hello Experts, I have a timer in form1 that refreshes my grid every x amount of seconds. I have another form2 that I call to update information displayed in grid of form1. I disable the timer when i call this form so the refresh does not interfere with my present form form2. here is how i call...

Hello Experts, is is possible to SUM an entire column, lets say the column is (D) and i want to display the result right underneath I know you can specify in range Example F2:F44 But the problem is i cannot have a set row like for example F45 to display the result, only because tommorow there...

Hello Experts How would I make my excel workbook ReadOnly, I was only able to find "Mark As Final" which is ok, but i cant seem to get it to work please help

Hello Experts I have a problem with the information being displayed on my excel workbook here is a diagram of what is suppose to be displayed Invoice No Description quantity Price 12345 Tires 1 $40 Lights 1 $10...

Hello Experts, I have a combobox in a grid that auto populates as the user types in for example: "Lights" if lights is wildcard the user can finish typing lights or simply select it, the AllowAddNew property is set to .T. of the grid so the user can type something new like say for example...

Hello Experts As some of you might know I am working with VFP Automation Excel. I would like to bring my xlsx file to front once created. How would I go about doing that?

Hello Experts Recently I have been experiencing a problem only with visual fox pro 9 and my keyboard. Every now and then ill be typing in a line of code, review it and sometimes ill have to go back and erase something or press enter to bring a line of code down, but pressing enter is where I...

Hello Experts Im starting to feel like sql select is evil... I used to be able to edit records in my grid by double clicking on the record. In the dblclick event i would have LOCAL oform3 as Form DO FORM frmbookapp NAME oform3 LINKED WITH appointment.appointid, customerid NOSHOW...

Hello Experts when I Use sql Select I lose my Grid Design what I mean by grid design is my header fonts are bolded, my columns are wider in size. but when I run my form everything is plain and ugly. is there a way around this? here's what i have in my load event SELECT a.startdate...

Hello Experts How would I check to see if a FILE is already open?

Hello Experts I am hoping I can get an example of how to calculate an entire column? i Just want to add values

Hello Experts How do I highlight\color a cell or better yet an entire row?

Hello experts, Ive been thinking my hole Time overlap through and I noticed a small problem. If a customer cancels appointment, I wouldnt want the user to have the ability to delete the appointment. Rather then delete i decided to add a status called CANCELLED, but if this appointment is...

Hello Experts How do I sort Alpabetically In my comobox. rowsourcetype must be fields I tried.. SELECT ALLTRIM(customers.firstname)+' '+ALLTRIM(customers.lastname) FROM customers ORDER by firstname INTO CURSOR MyComboCursor

Hello Experts I would like to copy only the records marked "UNPAID" to another table, So far i am able to search for any records marked "UNPAID" by smiply doing this SELECT billing SCAN FOR status = 'unpaid' <do something> EXIT ENDSCAN Please help

Hello Experts How would I tell vfp that once the record is saved enable this.btn? If i am starting a new record it should be disabled.. Please help Thanks Mike

Im trying to give the user the ability to type in the amount of seconds for the grid to Autorefresh. what am i doing wrong? In the Timer Event of the Timer thisform.timer1.interval = 1000 if !empty(thisform.txtrefresh.value) thisform.txtrefresh.value = thisform.timer1.interval *...

Dear Experts I have a checkbox, I would like for the date in my txtbox to move foward 3 months when this checkbox is checked, but i cant seem to get it to work heres my code in the click event of the checkbox IF thisform.check1.Value > 1 thisform.txtdate.Value = GOMONTH(DATE(), 3 ) ELSE ENDIF...

Dear Experts, Because I am working with Appointments i would like for my appointment list to view only appointments of current date. how would i do this?