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 Rhinorhino 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: gryff15
  • Content: Threads
  • Order by date
  1. gryff15

    How to check if excel is already open when using .workbooks.open

    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]"...
  2. gryff15

    How to beautify text merge - endtext in VFP 7

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

    VFP visual bug when dragging objects

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

    How to Add Limit of Multiple File Upload using Common Dialog?

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

    Some columns in a grid is read-only even when set to false and enable is true

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

    Problem (Compatibility?) on excel automation [macro] with MS Office Professional Plus 2021

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

    VFP7 Windows don't show in the screen, only in Taskbar

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

    How to reconnect when SQLEXEC failed?

    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 =...
  9. gryff15

    How to use Windows 10 style of title bar in VFP 7?

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

    My VFP window suddenly become fullscreen, no min, max, close button.

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

    What is the easiest way to change menu color when hovered by editing the mpr?

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

    OLE error code 0x80080005: Server execution failed - This error appears when generating excel file

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

    How to copy cfg file from local folder to the main server without error File is in use?

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

    Mysterious Fatal Error when Saving Excel File

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

    Hover effect on grid row when mouse is pointed over it?

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

Part and Inventory Search

Back
Top