Recent content by gryff15

Hi Griff and Chris Miller, Thank you for your answers even though they are a little to much for me to absorb already. I really appreciate them and have tried researching on those automations. Still, I failed, but I think I got the idea regarding the error. When I end-task the VFP when it...

Hi Griff, I don't quite get what you meant by renaming it? How am I able to get the same file with a different name? - gryff15 -

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

Hi Mike and Chris, Thank you very much for your detailed and generous help. For now I'd just stick with manually indenting the TEXT/ENDTEXT every time I beautify. It just really bugs me sometimes when the codes have many chunks of it. I personally prefer using the traditional x = "value" in...

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

It is a class from C:\Program Files (x86)\Microsoft Visual FoxPro 7\Ffc\_system.vcx The code ran through it when I set stepped on. _comdlg1 is also the default name of the object when I created a common dialog from component gallery. - gryff15 -

I'm afraid I can't find the MaxFileSize property. In _comdlg dialoghandler though, there is: lStructSize = IIF(VAL(OS(3)) > 4, 22, 19) * 4 also, nArraySize = 1 Not really sure where to find MaxFileSize, no result on find. - gryff15 -

I need to select more files because I use the filenames to get the excel files and regenerated the excel files with additional columns and data, instead of editing each excel files. I expect for the cursor to have more than 35 filenames but it doesn't. - select many files - append to cursor, add...

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

Thank you. The removal of alltrim made it editable. One more thing, I can't find a way to insert a new record in the grid. I have an Add button: Go bottom Apppend blank ....grid.column.text1.setfocus() , does not go to new line. Only focuses to first record. - gryff15 -

Hi Chris, I created cursor: Create Cursor parent (; CODE C(10) Not Null,; NAME C(50),; BIRTHDATE D Not Null,; AGE N(3) Not Null)) Create Cursor child (; CODE C(10) Not Null,; NAME C(50),; BIRTHDATE D Not Null,; AGE N(3) Not Null)) Then SQLConnect to tmpcursors scatter memvar, insert into...

The grid readonly is set to False by default. I also hardcoded in Init to set it false but it doesn't work. Thank you for the tip on Columns property though. - gryff15 -

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

Hi, this is pretty much the skeleton version of my code after deleting a bunch of formatting. I put wait windows to see where it starts to hang. It hangs on: Wait Window 'Creating object excel file...' Nowait Wait Window 'Print size setup...' Nowait Wait Window 'Column width setup...' Nowait...