Search results for query: *

I have been away from VFP too long (11 years). I have a comma separated memo field that contains data like (Baltimore, Boston, Denver). Some records contain only three items, other can contain up to 12. I want to create a table with one record for each location. It should be simple but I'm...

I'm 78 years old and just moved from a machine running Vista to 8.1 and I'm confused. Help is desperately needed!

Assume that I have two name and address tables: mynew and myold. Let's populate both of them with client, zip and phoneno (and other fields). I seek a query that would produce a listing of old clients who are not in the new clients file. Select client, zip, phoneno from myold where client not...

I would like to create a grid similar that performs like a data query in Microsoft Office 2010. Visualize an Office spreadsheet with the following columns: firstname, lastname, city, state. In office, I can set a filter on each individual column. So, for example, I set state="AZ", I will see...

I have a memofield that contains the full names of people which are separated by commas. The number of names in a record can be as few as three or as many as nine. The names were input as firstname, middle name(or initial) lastname. Commas are used only to separate fullnames.I would like to...

I am using VFP9. When I run a form, I am getting a Properties.Desktop screen that overlaps my form. I cannot move this properties window which blocks my txtbuttons and prevents me from exiting the program. I cannot find an option that turns off the properties window when running the program. Is...

I'm using FoxPro9 and trying to display 0,255,255 as the backcolor on one of the three tabs of a pageframe. My color source is 4-Windows colors. All the controls on the tab are transparent. Why am I not getting a blue background? I've gotta get more books for my FoxPro library...

Hi, the Senile Senior is having a problem with a function returning a value. I have a form that contains an editbox that does not have a controlsource tied to a table. The intent of the edit box is to display data compiled by my FetchIt function. The function is called by FetchIt(acno). This...

My table contains a logic field. I want the output to display "True" if the value is "T" or 't' otherwise, the value should be blank. I tried "iif(upper(member)="T", "True"," ") in the When method. It doesn't work...I am baffled. How can I accomplish this simple task. I have been away from...

Imagine a personnel file containing fields empno, fname, m_init, lnane, addr, st, city, zip, etc. A related file (Recognition.dbf) contains empno, award_code, license_code, and year achieved. The codes for licenses and awards are 3 characters and are translated in the Awards.dbf file When the...

I have a table with six memo fields. Two of the memo fields require parsing and translation. Example: When reading a record, I want to display the contents of that field in a text box. The memo field requires translation after being parsed with alines. I have a routine that reads the record into...

Hi, I am a 77 year-old fully retired Foxpro user who was put out to pasture 10 years ago. It has been more than a few years since I last used Foxpro and I am during a project as a volunteer for an organization. Tamor Granor was a major source of my knowledge since I became fairly adept at using...