Recent content by CJMK

Chris, Sorry, I am a bit slow with thanksgiving and all. I have tried importfromxlsx and it seems to bring the data over very nicely, but mostly in memo fields, so I am writing a little routine to map those over to appropriately typed regular fields. It requires positional consistency between...

Mike, Thanks. Gets fatal error c0000005 message that refers to errorlog file that does not appear to exist where specified. (yes I have show hidden files on) screenshot attached. Click OK and immediate shutdown. If I just wait, freezes. file was downloaded as csv. So when that didn't work, I...

import from .xls crashed vfp Tried appending from .csv, but yields extra rows by cutting off before end of record though why it should do this after a close paren is beyond me.

Mike, I think I found the answer. I tried an array with no success. The field I was using is integer. On a hunch I switched to character type and all returned to normal. Thanks for your attention - and it did push me in the right direction. Of course I am curious as to why they don't like...

Mike, Thanks for responding so quickly. Both the form and object are fresh out of the box. All settings are default except for control source and row source. adding a combo and screenshot to show, since I think the two issues must be connected somehow. The Combo does get focus, but does not...

Created simple listbox with rowsource and controlsource,one column. It populates from the table of 395 records, but cannot receive focus. Tabbing just skips it. Only three objects on form, others are command buttons included in the class. Combobox with same controlsource (record ID, a 5 digit...

Started this earlier but lost track of it. I did as you suggest already. Nice to know I was on track for once. I attach a screenshot of the result. And yes, am using multiple fields with appropriate print whens to control what shows for whom. The issue is that because of the proportional font...

Making badges for a conference (US Go Congress) I want the person's name on the top with a color background extending all the way across the badge. Ideally with the name centered, but that's hard in a proportional font (Using ariel) If the reporter sees spaces, it stops printing the color. I can...

Hmmmm... I think Go players, particularly organizers, will claim they are at least competitive for title of "most argumentative and stubborn".

All very interesting stuff. Will definitely alter my style.

Thanks all - yes, I really wasn't thinking right for after 26. Getting soft in the head at my age (82) Will check out the resources. You are great.

Feeling a bit sheepish. Should have found that myself. But I didn't think creating the field (with no actual record) would create the variable. Thanks a bunch.

Here is the code PARAMETERS fn,numflds CREATE TABLE (fn) (A c(15)) i = 1 FOR i = 2 TO iif(numflds > 26,25,numflds) thisfld = CHR(i + 65) && B etc. ALTER table (fn) ADD column(thisfld) C(15) ENDFOR IF numflds > 26 FOR i = 27 TO numflds thisfld = CHR(65 + INT(i/65) + char(64 + i)...

Had similar issue on opening table, getting index error, and got around that by reindexing at first open. Now a very short time later, in init, I select it, and it gives me the 107. I am compiling with innosetup. It also is not finding another table and forcing me to locate it (right where it...

Program works fine in VFP9, but causes 114 error (Index does not match the table. Delete the index file and re-create the index.) when compiled into .exe by innosetup. If that had worked, of course I wouldn't be here. Deleted cdx and rebuilt. zapped table and appended from backup didn't work...