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

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

    totalising figures for seperate records

    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...
  17. 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"...
  18. T17Rax

    Finding out the day of the week

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

    Finding out the day of the week

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

    Finding out the day of the week

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

Part and Inventory Search

Back
Top