Search results for query: *

I have a program that gets an excel file to get its data and do some processing. The system hangs when using oExcel.WorkBooks.Open(SampleExcel) when the excel being uploaded is already open. The error goes "This action cannot be completed because the other program is busy.. [Switch to][Retry]"...

Using Tools > Beautify does not indent the TEXT TO xvariable TEXTMERGE even when there are multiple indentions, it sticks to the leftmost edge.. - gryff15 -

I can't seem to understand the cause of the visual bug of vfp 7 when dragging or selecting objects. It affects my designing experience. I tried reconnecting and or removing the external monitor but the bug still appears. I already closed opened the vfp but it's still there. - gryff15...

I found this code but I found out that it only gets up to 35 filenames. Selecting more than that results to only one record with a corrupted square character. I need to be able to select at least 1000 files. WITH THISFORM._COMDLG1 .ClearFilters() && Clear filters in case in loop...

I have two cursors, a parent and child. Parent has textboxes while child has grid. The problem is some columns in the grid of the child are read-only and I can't make it editable except for a numeric field and datefield. Thisform.container1.grid1.ReadOnly = .F...

Some users encounter problems with excel output using Office 2021. Sometimes, the system hang, then a window pops up: This action cannot be completed because the other program is busy. Choose 'Switch To' to activate the busy program and correct the problem. [Switch To...][Retry] What could be...

My VFP7 window does not open up, it is just hidden in the taskbar. I tried closing all apps and even signed out but still, VFP is just stuck in the taskbar. I disconnected the external monitor, still can't access vfp. - gryff15...

My system processes a large number of records which takes hours to complete. Due to this, the connection sometimes gets cut in the middle. How do I code such that there will be a chance to reconnect it and resume the process? It should not also cause a hang in the server. Connhandle_A =...

I noticed that VFP forms use a 3D design like in Windows 7. I cannot find in the properties where I can change it to fit the Windows 10 flat design. - webrider -

How can I get back to the normal window of VFP 7. I can only close it by alt f4. I checked all the toolbars but still no title bar. I pressed F11, F12, I end tasked it, still didn't work. Opening a new window only shows Standard toolbar. - webrider -

I have found a tutorial by Mike Lewis Consultants Ltd at http://www.ml-consult.co.uk/foxst-43.htm and I was able to test it to a few items on the menu. The thing is I don't want to copy paste COLOR ,,,,,RGB(255,255,255,57,173,73) at every DEFINE BAR because there are too many items. There's a...

This error "OLE error code 0x80080005: Server execution failed" appears only on one user. But other users don't encounter the problem. I tried to run on mine, I don't encounter the problem. It's frustrating. I checked the ODBC, it was all good. I made sure no excel ran in the background before...

Upon login, I copy the CFG file from the main server at F: drive to my local C: drive. Copy File "F:\sys\billing.cfg" To Sys(2003)+"\billing.cfg" In my form, I use the cfg file for my grid table. At Load event: USE SYS(2003)+'\billing.cfg' ALIAS bill Shared Then I modify my data through the grid...

I have a form that saves an excel file. Mysterious because the fatal error that the users encountered does not appear in my computer nor to my co-programmers'. It appears right after the putfile code where a window browser pops up and when you click save, the fatal error occurs but the program...

I just newly learned how to put hover effects on a textbox or a shape using MouseEnter and MouseLeave of the object. I change the bordercolor and backcolor of the object when I hover the mouse pointer over it. I'm thinking about doing the same with a grid where data from a created table cursor...