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: Judi201
  • Order by date
  1. Judi201

    can't hold format for number

    Jim, I am adding this for anyone who looks at this later. The last problem I had with that column, I could not see ANYTHING in the textbox. I opened a backup copy of that form in the CLASS BROWSER and was scanning for something totally different but noticed that the column that I had 'hassled...
  2. Judi201

    can't hold format for number

    Jim, Thanks for you response. I did the only thing I could think of and started over with that part. I set it up the same way and put an InputMask in the testbox of that column and it works. I sometimes forget the order in which I make changes in attempts to fix a problem and am misled in...
  3. Judi201

    can't hold format for number

    ...llnDiscRate, lnDiscAmt, lnAmtPaid lnAmtDue = amtdue && shows 11136.79 lnDiscRate = discrate && shows 0.0000 lnDiscAmt = ROUND((amtdue * discrate),2) && shows 0.00 lnAmtPaid = ROUND((lnAmtdue - lndiscAmt),2) && shows 11136.79 * REPLACE lvTicket.discamt WITH lnDiscAmt && goes fine...
  4. Judi201

    can't hold format for number

    Hi! Here I am back with a simple issue that I can't track down. I am updating a field in a view that is the difference in two other fields in a different table. All fields are N 10 with 2 decimals. This is done to display in a grid. The amount is shown without decimals even tho the grid shows...
  5. Judi201

    problem with checkbox in grid

    Hi! Just want to close this thread for the benefit on anyone reading it later. (I find so many answers that way that I am always conscious of leaving it hanging) I never could get this to work so, as I am moving forward in learning new ways, I used a parameterized view for the RecordSource and...
  6. Judi201

    best way to update table

    Mike, OK, now I understand what you are telling me. Although I have created confusion by not answering your questions correctly and am actually doing better than it sounds like! So let's just forget any answers above and let me say that I would NEVER (in my right mind) name a field with the...
  7. Judi201

    best way to update table

    Mike, I am afraid you are losing me. I don't use m. ever so I guess I am not strictly using the standard. I only use first char for scope and second for type. And yes, you are right .T. for every row CHECKED which is what I want. I will try to improve. [smile] My code works. Thanks for...
  8. Judi201

    best way to update table

    Mike Y It is a field, but I am confused. The llPaid is only TRUE if the checkbox for that row WAS clicked. This worked to give me only selected rows data. However, I see the point that the field would probably be the best reference. Thanks again. Mike L: I got the point anyway (a looong...
  9. Judi201

    best way to update table

    Mike, Super! Thanks so much. That is exactly what I needed to see. I can take that and go now. I don't know why it takes something like that for me to "get it'. Examples I look at usually have so many other things going on that I am not sure of the bare basics. Yes, it is as you said. The...
  10. Judi201

    best way to update table

    Mike, I was hoping you were around. You tend to make these explanatory comments that are so helpful! However, sadly, I am aware of the concepts you outlined. (Maybe not the Carter admin bit [smile]and the embarrassing thing is that in all other places I am using SCAN and I know that you...
  11. Judi201

    problem with checkbox in grid

    Dave, OK, T tried REPLACEing as you said but with the same result. I have only used GRIDS before to select one row and then act on that. In doing that, I assumed that the values I pulled from the grid would be those on the active row. This always worked when I left the GRID and coded...
  12. Judi201

    problem with checkbox in grid

    Dave, I tried using the same with a REPLACE. This gives an error 'not a field variable' I am sure others do this. Is my approach so far out in left field? How else could it do this? This is the only thing on a very nice screen that I cannot get to work properly. Thanks. Judi
  13. Judi201

    best way to update table

    BIG OOOPS! I posted a section I had started changing and had not finished. Please ignore. I can do better. Judi
  14. Judi201

    problem with checkbox in grid

    I get the same result. I had previously tried putting it in InteractiveChange. I have code to set it back if the checkbox is checked again and that works correctly. Check one time. OK uncheck it OK check same box again OK set back correctly check another box shows the value of the...
  15. Judi201

    problem with checkbox in grid

    Dave, Checkbox is in column 7. On check, I want to copy value from column 3 to column 6. This works fine the first time I click on any row. Say I click on first row checkbox. OK. Value in column 3 copied to column6. If I then click on checkbox in column 7 in the second row in the grid (now...
  16. Judi201

    best way to update table

    ...In my example for now I have a grid with RecordSource of cursor that contains 6 invoices unpaid. I select 3 to pay. So in the SAVE I want to: *** SELECT PayTick * get only paid SELECT * ; FROM PayTick ; WHERE llPaid = .T. ; INTO CURSOR csrPaid NOFILTER ** got just what we want - only...
  17. Judi201

    problem with checkbox in grid

    Hi! Maybe I should start a new thread but I don't know how to describe my problem in a title. In the grid described earlier, I click the checkbox and a value is updated in several places. (The code is in the click of the checkbox) This works fine in the first row that I click whether it is...
  18. Judi201

    best way to update table

    Hi! I am still learning how to use the power of cursors and want to move forward in understanding. (VFP9) I have a grid with RecordSource an updateable cursor. Checkboxes select the rows to update in the table underlying the cursor. The cursor shows info from several tables, but I only need...
  19. Judi201

    problem with checkbox in grid

    Dave, OK, I found the problem. I was actually one column off in setting up my cursor, even tho it appeared to be right. Thanks for the help. Judi
  20. Judi201

    problem with checkbox in grid

    Dave, The RecordSource is set in the Valid of the object immediately before the grid in the tab order. I have used this setup in many forms before as a selection is being made there on what to present in the grid. (All or Selected) This happens to be a checkbox on the form. Judi

Part and Inventory Search

Back
Top