Recent content by bs6600

Thank you all for your suggestions. I have checked and found there was nothing in the grid.recordsource. Filled that in (i just put the alias?) and it blanked all the column.controlsources. Put them back - didn't fix the problem. All columns show identical non default properties apart from...

I have a table with 4 columns and a grid showing the first 3 columns. I specified the control source in columns 1,2, and 3. this has been in use for years. I've added a fifth field to the table and a fourth column in the grid with the control source defined for the new field 5 It now shows 4...

This will shock the purists but I have learned to do things the easy way. Add a column with =if(isblank(a99),0,1) in every cell and sum the column. Just because a function exists doesn't mean you have to use it.

Thank you all. I have made my own importer (fgets and at(chr9),..) but for the record:- APPEND FROM ? type DELIMITED WITH tab &&.tsv X"Y <tab> "A"B APPEND FROM ? type delim && .csv "X"Y <comma> "A"B APPEND FROM ? DELIMITED WITH _ WITH...

Wow! Thanks guys. I'll enjoy reading all above slowly. I wrote my own importer with fgets and unpacking anything up to at(chr(09),...) The data comes from a non technical person who maintains a calendar in Google Sheets (because it's available and shared and our club can't afford to buy a...

Using append from myfile delimited with tab I have found that if a cell contains "X"Y I get two fields filled with "X" then Y this moves all subsequent fields right by one with sad side effects. I don't suppose there's a fix for this and I've written my own unpack so this is just a 'be aware'...

Thanks Chriss, Apart from the last line what you say is a bit over my head at the moment. I only have VFP as my basic tool and invoking some of the things you mention is beyond my knowledge level,. I'll brush up on error handling.

Thanks Scott. Yes I'm getting a lot of dropouts on all my devices and my IP provider is not being helpful so I want to gather some evidence. I planned to run my monitor program for say 24 hours unattended and log the ups and downs.

Is there anything new about this.? I want to monitor my router's performance so want to leave my code running unattended for some time. I just repeatedly get a url = connected (or false or null = not connected) and it mostly works but I get a halt occasionally with 'Still executing last...

Hi Mke, Still a Fifer. No work programming nowadays, just for my own entertainment and to keep the brain from seizing up! Bill Spence, Dunfermline, Scotland

thread184-216111 19 years on and that did just what I wanted - after I fixed the 'deliberate' typo. lnResult = ShellExecute(lnWhnd, 'OPEN', lcLink, '', '', 5) Note double quotes. Bill Spence, Dunfermline, Scotland

I provide html code which is 'plugged into a web site over which I have no control. It shows the results of my code in a "window" or "box" which is centered on the screen and too narrow for my needs. You can see my problem here (Styling :width=130% is giving me a wider right margin - click to...

This was a follow on from https://www.tek-tips.com/viewthread.cfm?qid=1804542 Both have now been resolved. Bill Spence, Dunfermline, Scotland

Feherke, Once again thank you - should have spotted that myself. I have not got a formatting or syntax checking tool for html - I just use Notepad as my editor - do you know of a (free) tool which would have found any unclosed tags? You were quite correct in your expectation - I had intended...

May I ask a second (maybe related) question? I now want to nest an accordion but this happens Accordion A Button A1 text only - OK Button A2 text only - OK Button A3 Opens Accordion B (A4 not visible!!!) Button B1 text only - OK Button B2 text only - OK Button A4 text only - closes Button...