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 derfloh 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: *

  • Users: T17Rax
  • Content: Threads
  • Order by date
  1. T17Rax

    command buttons not refreshing form

    I've a form that's being called via parameters. (I'm wondering if this is the problem). I've two command buttons; forward & backward. The code works - They skip through the records up and down as they should but the form isn't updating the form. Now, is it because I'm missing something silly...
  2. T17Rax

    Import From Excel crash

    While teaching myself more of VFP 9, I wondered how to attain data into a DBF from an XLS. Using the APPEND FROM ... .csv delimited worked but not quite what I was after. - without going into too much programming and coding, I was hoping a simple import query would do the job. Tried it, and...
  3. T17Rax

    Operator/operand type mismatch

    Hi, fulln = fullname spent = Totals(spent) + "fulln: " eMessageText = "fulln: " + spent totals = MESSAGEBOX(eMessageText) The bold line is telling me there's the operand/operator type mismatch. Fullname field is character. Totals field is numeric. (spent) is being called from another PRG...
  4. T17Rax

    totalising figures for seperate records

    Hi again everyone, I'm trying to achieve a way to find the total spend for everyone that's bought things over a month. using the Sum(Am1) expression works by giving me the entire column, however that appears as a grand total for the entire month. What I'm after is a total of say "Mr. Smith"...
  5. T17Rax

    Finding out the day of the week

    Hi all, I have a program that issues a monetary entitlement to people if the day they are entitled to that value is selected. So for example, if they are supposed to receive £2.00 on a Monday, the field "Mon" would have to be "T" or "Y" ("Yes"). However, when the program attempts to scan the...
  6. T17Rax

    Variables

    I'm learning variables which I think I'm getting the aspect of. I've attempted to write a prg which will change records accordingly and so far it's working. However, the issue I'm looking at here is there is a field that has two or three different records. For example, Field Classno contains...
  7. T17Rax

    File Access is denied, but no sign of another table anywhere!

    Morning all. I've just come across an instance of a "file access denied" error. Now, I'm no expert at VFP but I know the basics I would hope and thought I'd post this is here as I've searched through the forums and not been able to find anything, and feel it would prove helpful to other VFP...
  8. T17Rax

    Queries return empty table results.

    Here's a Question: How come when I sometimes run a query or a search by filter expressions, the queries come back with an empty table, rather than the records that I specifically wanted? For example, SET FILTER TO Dat <= {04/09/2014) AND dat =>{05/09/2014} The dates are definitely in the...
  9. T17Rax

    Understanding VFP Functions

    Morning All, I feel a complete idiot when asking on here (because I'm a complete novice!) but I'm wondering if anyone can help me on understanding functions (or rather a particular funtion). I decided to write a program and with some great help, I got a solution out of my error(s) in that...
  10. T17Rax

    Placing a field of records in a messagebox. (VFP 9.0 SP2)

    Hi all, First time posting on here. I'm teaching myself FoxPro and giving myself little tasks to do so I've a better understanding on how VFP works, but unfortunately, I'm stuck on a problem. I've got a DBF which is like a user list. There's a field listed as "Cardno" that contains a pin...

Part and Inventory Search

Back
Top