Search results for query: *

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

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

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

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

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

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

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

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

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

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