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 =...

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

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...

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...

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

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...

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...

In my external database, I have a table with this structure: Employee Dept Salary Under the Dept, I will, of course, have different departments like Finance, Logistics, Sales, Marketing, Production, etc. Here are the questions: 1. How do I create a calculated field based on the department...

How do I create a view or a SQL statement that will support a user-supplied parameter? When I run the view or the SQL, it should pop up a window that will ask me to provide the parameter. In MS Query, I can do it this way: Select * from Salesman WHERE Salesman = ? How is this done in SQL Server?

How do I convert a cell with date format to string? In A1, I have the date 25/12/2004. Using the formula +A1&" Xmas", I would like to have the result "25/12/2004 Xmas" instead of "38346 Xmas".

How do I turn off the feature of including special characters in Excel when I import? My colleagues can import properly without those characters (tab, carriage returns, line feed etc.) but I can't. What settings do I have to change? (My settings to Show Control Characters in the Option's...

When writing a macro for a parameter query in Excel pivot table, I can do this: “WHERE field = ?” and I am given a prompt “Parameter 1” before running the pivot. I would like to customize the prompt but have not been successful. I tried “WHERE field = [Give Branch Name]” which works with MS...

I have a pivot table that picks up the quarterly sales from an external file. However, I update that file to include only the months for the respective quarter. E.g. If we are in quarter 2, the file will only contain Apr, May, Jun data. The problem I am facing is that the pivot table...

I have a pivot table with columns represented by Departments (Sales,Finance,Marketing, etc.) I would like to add a calculated field which will be a combination of Sales+Marketing and another calculated field which is Finance+Accounts. How do I do that?

Can someone give me an example of a SQL statement which embeds the CASE condition on WHERE clause? E.g. Select the fields Employee, Gender, Division from the table "Employees" where (if the Gender = "Male" Division = "Sales", if Gender = "Female" Division = "Accounts"). So for Male gender...

Two questions: 1. After writing my own user-defined function in Excel, how do I make it run whenever I call Excel without having to open the file it resides in? Sort of making it like a native Excel function. 2. How do I make Excel show the needed parameters or arguments of my functions...

For some reason or another, my cellpointer (cross symbol) in Excel has changed from the default Transparent to Opaque (with blue-filled interior). I know this is a small issue but I prefer to have it in its default form and I don't remember changing anything in my settings. Can somebody help?