Recent content by sw1202

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

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

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.

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

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

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

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

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

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

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

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

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

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

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.

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