Search results for query: *

I received this message when i creating a form or a wizard form

Public Function grade(mark As Variant) As Sting Select Case mark Case Is >= 80 grade = "A" Case Is >= 70 grade = "B" Case Is >= 60 grade = "C" Case Is >= 50 grade = "D" Case Is >= 40 grade = "E" Case Else grage = "F" End Select End Function Private Sub Compute_Click() grading.Caption =...

Good news Prashant, I got it with the help of your persistence to share the best from your side. I just needed to put in the WIN.INI the following lines as your link advised and it worked without having to register them. A million thanks to you. [Mail] MAPI=1 CMC=1 CMCDLLNAME=mapi.dll...

Hi Prashant, The settings in Word by default is as you have described. Still not getting it. Thanks anyway.

Thanks Gavin for your reply. But my problem is in Office. I get the option in Windows but not in Excel or Word. We used to get the SEND TO MAIL RECIPEINT AS ATTACHMENT option while working in Excel without necessarily having to save the file first.

How do I activate the SEND TO built-in menu and its component "MAIL RECIPIENT AS ATTACHMENT" in Office 2002? Some machines have it automatically upon installation while others don't. In Excel for example, I tried customizing the toolbars by adding "MAIL RECIPIENT AS ATTACHMENT" to the File...

MY FIELDS ARE SCODE, SNAME: WHEN I SELECT COMBO BOX OR LIST BOX ALL THE TWO FIELDS WILL DROP TO THE DESIGNATED FIELD

PLEASE HELP

Hi Skip, The pivot table I have normally returns only 1,100 rows. It should not go beyond 1,500. If the result would go beyond 65,000, Excel gives me an error after I transpose fields, not when I am opening or refreshing the pivot. Thanks

I have a pivot that queries a Foxpro database of over 1M records. The query should return a record set of 410,000 items but it stops fetching data after 405,000 and pops up an error message that "Excel cannot cmplete this task with available resources. Choose less data or close other...

Link to QUE Using Visual Foxpro 6 A very good on-line reference (actually the book itself).

Hi Mike, Thanks for the advice. I was able to work things out by uninstalling the entire VFP9. Once I did that, everything went back to normal (VFP8 and VB). I boldly went back to install VFP9 and no glitch whatsoever now. The only difference between the 1st and 2nd installations is the...

I just installed VFP9 and I am always being asked for the file VS_SETUP.MSI whenever I run Intellisense Manager. I insert the installation disk and choose the file but I get this error "ERROR 1706. No valid source could be found for product Microsoft Visual Foxpro 9.0 Professional - English...

Sorry for the confusion. My question should be more like "has VFP9 improved its pivot class to behave like Access/Excel?". I am aware of the pivot and cross-tab classes in the earlier versions but I am not able to do the same thing with those classes as I can with Access. Working on the...

Is there a cross-tab class in VFP9, somewhat like the pivot in Access?

Hi Skip, Problem here is that Order / Sales / Stock / Target are not fields in the source data. They actually fall in one field called CLASS. The source data looks like this: ITEM CLASS QTY 0100031 Order 48 0100031 Sales 300 0100031 Stock 98 0100031...

Tim, that is how I am doing it right now but the users are very much against having to manually add a column and typing in the formula (you can't use a simple point-and-shoot in pivot tables unless you are willing to change all absolute references). Skip, here is a sample data...

Can anybody show me how to create a Calculated Item in a pivot table? I have a field called CLASS with the following values: Stock, Sales, Order and Target. I would want a field that calculates Stock minus Order. As per HELP, we have to ungroup each item and enter the calculation. I have...

Hi Geoff, I know somebody was bound to ask the question why I don't manipulate the external data as a pivot table. You see, in my Excel sheet, I have adjacent columns that require complex calculation i.e.INDEX(MATCH()) combination to determine number of months brackets in Aging of Receivable...

I have an Excel sheet with a user form that requests an entry from the user. The input is then assigned to a cell in the worksheet which serves as a parameter for my external query, which in turn, is the source of my pivot table. Everything is fine except that when I refresh my pivot table...