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!

Recent content by T17Rax

  1. T17Rax

    command buttons not refreshing form

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

    command buttons not refreshing form

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

    command buttons not refreshing form

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

    command buttons not refreshing form

    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...
  5. 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...
  6. T17Rax

    Import From Excel crash

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

    Import From Excel crash

    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...
  8. 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...
  9. T17Rax

    Operator/operand type mismatch

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

    Operator/operand type mismatch

    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()...
  11. 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...
  12. T17Rax

    run a prg file every monday

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

    totalising figures for seperate records

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

    totalising figures for seperate records

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

    totalising figures for seperate records

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

Part and Inventory Search

Back
Top