Search results for query: *

I've now been able to get the form working as I'd hoped it to, following the advice and being able to see how it works. As it is usually the case, it was the last bit that was needed finalize it all and finish it off. I must thank you both for your help and advice and I hope that I will be...

Olaf, That is some really good advice there! The parameters was something I have touched upon but as you've mentioned, in general, and I agree, I have much more to learn. Once I called the parameters and saw the data being passed to the called forms, for me I saw it working and that was a good...

While waiting for the response, I had found out how to bind controls to objects from cursors - which was to have a cursor in the datasession to begin with! I don't think I've explained my question very well and I apologise for that. I understand the purpose of controlsource. It can be one...

Reading what Olaf initially had written, I decided to go back to square one and start logically. From basic understanding, binding a textbox to a ControlSource (which would be alias.field) would show an individual record which is highlighted in the table. So, the command button codes are as...

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

I'll work harder on the import command. I've used the append from ... .csv and that works okay but I wanted to be able to see if there was any difference between import and append - import places the field headers on the field row where as append places the field headers inside the table cells -...

Sorry I forgot to say that I had entered the source as "Excel 5.0 and 97", not text file and it had came back as binary as Olaf has said. Just to be sure, I had done it again yet this time, it crashed with this: Jrbbldr - I wouldn't mind giving the code a go, but learning how code works, I...

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 mike, Sorry you haven't put me off posting anything further. I'll take your advice in using the help file and not to research the internet as often for an answer to a particular problem. Many times before the results returned haven't done me any favours at all. I apologise once again for...

I understand that it's a basic error as I have seen it many times before with REPLACE and SET FILTER TO queries and realised it was something to do with the type of data (hence mismatch) but it was trying to get the two types together into a message box, which was the problem. I had tried VAL()...

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

In addition to MikeLewis's initial comment, our former programmer had developed an application which relied on another table that had dates in - this allowed the program to run WITHIN the dates entered in the table. You could write into the table the times which your EXE is supposed to run...

Olaf, Mike, Gotcha! I understand it now. Thanks for all your help and advice with this. As I said, it's just practice and messing about - trying to get used to VFP but it's great to know that the more I learn with the help from you guys, the more I'll know. Thanks once again. I'm sure I'll be...

Olaf, So am I right in thinking that if you give a name to a field by referencing "Select Year(dat) as yr", the numbers just ensure the position of the field? Ha ha I hadn't thought about the order of data. It was something I put together to try and get something going. If this was going live...

Olaf, If you don't mind me asking, how does "Group By 2,3,4,5" fetch the fields and name them into the cursor? As the date fields for year and month come under "Exp_2" and "Exp_3" yet the rest appear to have the orginal names from till table. Thanks, Vibrantseeker. A conclusion is simply...

Hi Guys, Apologies for the delay in response. The principle of the code was to gather a user's transactions and give a total, for a date range. i.e, a month. A live balance is kept in a completely seperate table. It was an idea perhaps that had come into my mind where a user may want to see a...

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

It's all a learning curve Olaf haha. I'll read over the code again, perhaps start from scratch and see what I can do with it. I can understand it may be quite a bit of chaos! Using your knowledge in those commands, I'll have a look at what I can replace, take out, move etc. Hopefully it should...

Olaf, I apologise once again. I was hoping to keep around the problem area without realising the rest of the code may be needed! I see what you mean with returning to the top of the file but i'm sure in my code below I told to move the to top of form again - as read in other posts. I've noted...

Olaf, I have the fields Mon, Tues, wed, thur, Fri. Each field can have either "" or "Y". If any of those fields have "Y", then the user of that day can have a monetary value for that specific day. If its Monday, and mon = "Y", then the user will get (for example) £2. But only for that day...