Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OldtTimerDon

    Parsing a memo field

    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...
  2. OldtTimerDon

    How to add VFP9 to Windows 8.1 machine

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

    SQL help

    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...
  4. OldtTimerDon

    How to Create a search filter grid?

    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...
  5. OldtTimerDon

    Parsing a memo field

    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...
  6. OldtTimerDon

    Problem: running form

    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...
  7. OldtTimerDon

    Display backcolot on page frame

    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...
  8. OldtTimerDon

    Function to return a value

    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...
  9. OldtTimerDon

    Displaying output of logic field

    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...
  10. OldtTimerDon

    Problem with calling function

    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...
  11. OldtTimerDon

    displaying memo field contents

    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...
  12. OldtTimerDon

    Modi form problem

    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...

Part and Inventory Search

Back
Top