Recent content by mikemck7

Geoff and Mike, I spoke too soon. At first it seemed to work when I added THIS.Increment = 9 to the INIT method. However when you spin down from 10 to 1 and spin up again, the value becomes 11. That's because the INIT method only tests once. I solved the problem by removing that line from...

Geoff and Mike, You're right. I omitted "THIS.Increment = 9" in the INIT method. Thanks again, Mike

Mike, I've already tried something similar to that and it doesn't work because the spinner value is already changed and its the new number displayed by the time the up/downclick methods fire. There ought to be a method that fires before the value and display are updated but I haven't found it...

I'm trying to accomplish something with the spinner control (VFP8) that is making my head spin. I need the control to display increments of 10 but I also want the initial and lowest displayed value to be 1, not 0. In other words the sequence displayed needs to be 1, 10, 20, 30 and so on. So...

Thanks Mike, Luckly, I read your response prior to it being deleted. I know you meant to say "MODIFY FORM ..." rather than "DO FORM ..." as above because you had it right in your original response. I was not aware of the METHOD MethodName argument. That's pretty neat and I've started using...

Forgive me for posting this twice. I'm told I posted the following in the wrong forum. Sorry!: I like to record general comments and reminders as I work on forms while building an application. For this purpose, I've added a method called DevNotes to the property sheet of all my form base...

Nasib, I like your approach also. It seems tighter than mine but I wasn't really concerned about speed in this case since I'm not expecting to use it that often. I ran my code against one of the larger tables and it was over in a flash. You didn't deal with possible trailing codes in yours so...

Tamar, I agree wholeheartedly with the sentiments expressed thus far. Years ago when I started learning Foxpro, it was mainly your Foxpro books that taught me much of what I know. I also remember eagerly anticpating your regular Foxpro Advisor columns. The award is well deserved...

Nasib, Multiple arguments in ALLTRIM() is new in VFP9. Unfortunately, as I mentioned in my original post, I'm using VFP8. SIDEBAR: There is an error in the sample code I posted above to demonstrate the use of my ALLTRIMCR() function. Altough the sample program will run as is, the #DEFINE...

I revisited my ALLTRIMCR() function and came up with the code below. I needed the function to also catch any empty spaces between two CRLFs. I also did not want CRLFs within the "good" part of the string to be touched so I did not use STRTRAN(). To demonstrate, paste entire code in a program...

I'm designing reports in VFP8 using data contained in several large tables. Some of the data has to be parsed and extracted from memo fields. Numerous records contain leading and trailing carriage returns causing MEMLINES() to return misleading results. Others contain nothing but carriage...

The gendbc.prg approach works just fine. Had my new duplicate table built in just a few minutes, indexes relations and all. Thanks. Mike M

Hi, I have a table in a VFP database with numerous fields. The table is well documented with comments. I wish to build a second table that is a duplicate of the first such that only the table name changes. I especially want to preserve the index expressions and field comments. What is the...

This VFP 8 status bar text is displayed is what looks like the Arial font. Is there a command/function that lets you change the font to something else?

Both of these utilities will come in very handy from time to time. To meet my immediate need, I'm creating a simple interface for frmCode so I can easily include/exclude specific forms and/or classes from the output file. Thank you much. Mike M