Recent content by wjs2

Mr. Mike, Thank you very much. That looks like exactly what I need. Your help is much appreciated. Mr. Bill

Is there a way to programatically find the workgroup(s) of the user ID obtained from the sys(0) return values? This should not be tied to the name of the computer used to sign on the system. Thanks

In case anyone is still interested in this one... Had some programs that were responding in 8 as described (buttons appeared grey in version 6 & 7, white in v 8). But only some of the buttons. Did some checking in the programs and found some inconsistencies in the use of 'Forecolor' and...

The beginning of the last paragraph should have read; 'before the first 'if' statement.' This paused the system right after the 'for' clause and prior to the first 'if' being executed. This had to be the command giving the problem since the executable worked once this 'inkey' command was...

I have a program in VFP 6.0 that allows the user to change a table sturcture. The fields are displayed for the user in a list box. In the validation routines I check for duplicate field names. The routine looks like this: For ThisForm.lstResults.listindex = 1 to ThisForm.lstResults.listcount...

Hi bon011, In my particular case, the grid was dumped on the form at design time with no table structure in back of it. At run time I assigned the table structure and then turned the grid 'lose', so to speak, to do whatever it did to construct for the table that was assigned at run time. This...

Hi Ramani, Thank you very much for that one! I have stayed away from grids in some instances where they would do the job better but couldn't find a way to manipulate them the way I wanted. This is just what I like. Sneaky. Super sneaky if you have the table structure available that is used...

Hi, Thanks you for this discussion. I have stayed away from much screen maniplation for the sake of visual impact simply because of the problem discussed here. The little 'Inkey' trick works great. Absolutely, Thank you. WJS

Hi, Thanks to both of you for your responses. Unless I missed something very elementary, this particular case is 'You can't get there from here.' I've tried everything I can think of anyway. Since I used the form designer to drop the grid on a form, and, it is not bound to a table at design...

Hi All, I'm not sure if I am asking the right question so bear with me. I have a form created in form designer. The form has a grid dropped on it using the form control tool bar. One of the forms command buttons has the following code to get the information into the grid columns: * Select...

Thanks Chet. I'm going to go for it. What's the worst that can happen? My toenails fall off? WJS

Thanks again for all the input. Because of the nature of the system, I suppose an argument could be made to simply supply a copy of Visual Fox on the user's machine and turn them loose. These users, however, are not technically oriented in any sense of the word. The goal of the system is to...

Thank you for your quick responses. Since you both seem to agree, there may in fact be no reason for the work around. When I think of databases I think of multiple tables with relationships and associated overhead. One of my primary concerns is speed. These tables can be huge. Right at the...

Hello all, I am building an application that allows useres to define their own tables, load those tables with data from any number of types of sources and begin working with them. Some of the fields within the table structure seem to be off limits unless the table is part of a database...

Shangrilla, Assuming you are trying to do this either or thing on the fly, you need a method of choosing one or the other. That leaves you with several options for the selection. A check box, radio button, whatever. Then an If, do case, what ever or macro substitution, which ever suits your...