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

    decimal doesn't show the correct amount

    Griff, Rereading your reply, I went back to check and it does have a cursor at the beginning (that data got copied from a table to) and it is n(10,2). I changed it to 12,2 and that fixed it. Thank you so very much. Have a nice day. SW PS. I searched for all cursors and made sure they are all...
  2. sw1202

    decimal doesn't show the correct amount

    Griff, I went back and set the format to have 3 decimals and it shows -1,918,724.100 [upsidedown]. SW
  3. sw1202

    decimal doesn't show the correct amount

    Thank you for such quick reply. I have been trying everything I could think of. It's linked to a field in a table. And they don't want three decimals on the reports.
  4. sw1202

    decimal doesn't show the correct amount

    Good morning, I have a report displaying the wrong decimal amount when an entry is over a million and voided. The original entry is displayed correctly on the report as $1,918,724.12, but the voided entry shows -1,918,724.10 (it is -1,918,724.12 in all tables). I set decimal to 2. I tried to...
  5. sw1202

    Move to last sheet - Excel Automation in Visual Foxpro

    oExcel= CreaateObject("Excel.Application") oWB = oEcel.Workbook.Open(...) oLastSheet = oWB.Sheets(oWB.Sheets.Count) oNewSheet = oWB.Sheets.Add(,oLastSheet) The above codes works beautifully. Below is how I used it: oExcel = CreateObject("Excel.Application") if vartype(oExcel) != "O"...
  6. sw1202

    Move to last sheet - Excel Automation in Visual Foxpro

    Wow, thank you all very much for your help. I am going to try it again and report back. Happy Friday! SW
  7. sw1202

    Move to last sheet - Excel Automation in Visual Foxpro

    Good afternoon, I open an Excel workbook (which already has several worksheets in it) from Visual Foxpro and insert a new sheet. The new sheet is always inserted before the last sheet and I need that new sheet to be the last one. I tried running macros in Excel to see the codes, but it always...
  8. sw1202

    can not run oracle form on 64 bit window 10 machine

    The program is 32 bit and oracle client is 32 bit too. What I don't understand is that another program (Oracle) works fine on this 64 bit window 10 machine. I have recompiled the forms and menu (path in the Start In and registry, environment...) but it now says "FRM-41810 Can not read menu...
  9. sw1202

    can not run oracle form on 64 bit window 10 machine

    Thank you. I checked that and no space anywhere. Still not working.
  10. sw1202

    can not run oracle form on 64 bit window 10 machine

    Good morning, One of my users just switched to 64 bit window 10 machine and the program we have doesn't work anymore. It keeps saying "can't attach library", I removed the library (just a few alerts) and it stops looking for the library and now it says "FRM-40108: No such form xxx" after user...
  11. sw1202

    memo file (for menu) is missing or invalid

    Thank you all for your help and direction. I usually have lots of backup versions, but somehow for these, I didn't do it :( Hopefully I will be able to get an older version from last month backup and build on from there. By the way, do you know what could cause the memo file of menus to be...
  12. sw1202

    memo file (for menu) is missing or invalid

    I have been using VFP 9.0 all along. Thank you.
  13. sw1202

    memo file (for menu) is missing or invalid

    Hello, I suddenly found myself in trouble when I tried to modify my menu. I got this message "Memo file main_menu.mnt is missing or invalid". I recovered the files from backup, it still would not let me open. I even reinstalled VFP, it's no help. And this is not all, out of four projects...
  14. sw1202

    reports eject extra page at the end

    Mike said: "You could take explicit steps to prevent that, but that's not really the solution to the problem." Would you please point to the direction how these steps could be done? Thanks.
  15. sw1202

    reports eject extra page at the end

    :-) You have quick eyes for debugging. I copied and pasted just part of the codes (there's more below with else...) and manually added the "end if;" in the post while my mind is still in the Oracle programming mode. I am still hoping that someone will be able to shed light on this problem...
  16. sw1202

    reports eject extra page at the end

    Mike, thank you for your reply. It works correctly in Word and other applications, but not in Visual Foxpro. Visual Foxpro printed properly on hp4015 before the windows updates and it is still printing correctly to other printers like hp2430 from the same applications. And here is a sample of...
  17. sw1202

    reports eject extra page at the end

    Thank you for your input. Like you said it's not VFP issue, it's more like a window update, printer driver issue but I tried to twist my code any way to see if there's anything I can do to fix the problem on my end, but no success. How do I check the printer driver updates (how do I know which...
  18. sw1202

    reports eject extra page at the end

    Hi, I have several reports that run and print without any problem for years, then suddenly right after my users restarted their computers after a recent automatic windows update, a blank page follows every report they print. I haven't been able to find what could cause the reports to act like...

Part and Inventory Search

Back
Top