Creating an offline OLAP cube
HELP! So I try to create an offline OLAP cube using the New Database Query
dialog with its options. When I go to select a data source, it only gives me
the option of ODBC cataloged databases (I am trying to get to DB2).
Interestingly enough, when I just use Import Data it gives the the OLE DB
route. Anyway. So I get the data and I can see it, but when I select the
option to build an OLAP cube it crashes and gives me "Format of the
initialization string does not conform to the OLE DB specification" and
crashes the OLAP building part (well errors) but will return the data. Now, ...How do I create a survey in an e-mail to send to many people?
I would like to survey a select number of our clients with a generic survey
with given answers (strongly agree, agree, etc.) How can i do this using
outlook without using an attachment? (i would like to place the question in
the body of the e-mail so that the client may respond without exiting the
e-mail, and then be able to easily collect the data upon the e-mails return)
Outlook is not a suitable tool for conducting a survey like this. =
Consider using a web page instead.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflo...Creating Visual Excel Cell Alerts
Hi there guys,
I'm relatively new to this but would appreciate your help.
Basically what I am trying to do in excell to create visual alerts in
the same cell that I am inserting values.
For example in the cell I am entering data (for example a weight in
kg) for all entered data in the range of 0 - 200kg I would like the
background in the same cell to show as green (highlighting within
For all data entered between 200kg - 250kg I would like the background
to show yellow (diplaying slightly overweight) and for entered data
between 250kg - 300kg I would like ...Creating Toolbar Buttons in OneNote 2007 11-18-09
I created a toolbar button according to
It works fine, right the way described in Escapa's Blog.
However, my Windows crashes if I deinstall the button.
Sometimes it goes so far that I cannot even restart my PC in a recovery
mode. I also tried it on a different PC ( both PCs have WinXP) with the same
result: Windows crashes if I deinstall the OneNote Button.
If you have a look at the latest user post at
(Wednesday, April 15, 2009 7:29 PM by ...Invoice created from Excel ocr Access and sent via Outlook
I am all new to this and do not know any programming.
I have an excel sheet with Name, Address, e-mail address, amount to pay and
an ID number.
Is it possible to automate this and send an email with invoice to each and
everyone of them?
I would like for Outlook to atleast to put the different information in the
body of the message to make an invoice. If I have to make another solution
with the distribution addresses that is ok with me. I just dont want to copy
and paste all the hondreds of posts into e-mails, because something will
definatly go wrong, and it is very ...VB.Net program to create XML file
I need to create an xml file from a VB program using fields returned from an
sql query. I have a template that was provided for me and need to use
verbatim. Since this is just a text file, I gather that I can just write out
the file with all of the tags, etc., and name it .xml. Assuming that is
correct what I might want to do is create a template so that if this file
changes the names of the elements, all I have to do is change the template
and if more elements get added I can then add them. Is there a tool that can
do this for me? If I have to create one, any suggestions as to what I ..."create mscrm.sql" error on 3rd (re-)install
I have installed CRM 1.2 on SBS2K3 twice as "advetureworks cycle" and "msdn
subscriber" with only 90% success because of conflicts on the web site. I
have removed the conflicts but now CRM installer errors trying to create the
new database as (default) local service.
My login has SQLServer db_creator permissions and I can create a DB, so I'm
totally confused. Can I workaround this somehow ? What login needs to be
given db_creator rights so Install can run te SQL scripts ?
have you deleate the complete the old date from AWC? Have you delete the
...Opening Excel files that were created on a Mac in Windows
The other day I tried to open an excel file that I had created on my
mac on a Windows computer. When I went to do this all of the formatting
I had done on the Mac was lost and everything was set to the Windows
Default. I had the font, sizing, and placement of everything different
and it all went back to the Windows Default format.
Does anyone know how to get around this?? So for when I send an Excel
file I created on my Mac to a Windows computer it LOOKS exactly the
same as far as formatting.
What format are you saving it in on the Mac? It should be "Excel
Workbook"...How to create a View using Jet SQL in Access?
Can any body tell me how to create a View in Access using Jet SQL? And where
to get the detailed specific reference for Jet SQL?
The Access/Jet equivalent to a view is a Select query.
Jet SQL is documented in Microsoft Access help. In recent
English-language versions, display the Help window and look on the
Contents tab for "Microsoft Jet SQL reference".
On Sun, 7 Sep 2003 00:16:39 +0800, "lu_yanfeng" <email@example.com>
>Can any body tell me how to create a View in Access using Jet SQL? And where
>to get the detailed specific reference for Jet SQ...Can I import a new colour into the options for creating charts?
I am creating a series of block charts for a staff survey from data on excel.
The company has a distinctive colour as part of its brand (which is not
matched by any of the colour options already in the excel programme). Is
there any way I can import a new colour into this programme?
I can find the colour I want in word but not excel
To import a color into XL see Tools | Options... | Color tab.
Note that the XL palette is limited to 56 colors. You can replace
existing colors but cannot expand the size of the palette.
Excel, Powe...How do I create Folders/Sub folders from User Form control button
I have a User Form that I would like to take one of the spare control buttons
and have it set up my job folder on the hard drive.
I am not sure how to code it to achive the following results:
These are my text box ID's
User Selects drive: \ CES_No_1 \ CLLI_Code_1\ TEO_No_1
Sub Folders inside Main Folder
Elec Job Folder
Misc Job Documents
If you can dig up a copy of the VBS doc...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...dynamically creating a list of controls
The user needs to be able to create a single object composed of other
various elements. To specify a single element, the user will have to fill
out a series of controls, which looks like this:
Cedit |combobox| cedit ||| cedit
How do you dynamically create a list of these controls?
I was thinking I could create a borderless dialog template that contains the
series of controls, then create a dialog class(or window class?) that allows
me to externally manipulate the control's values.
Whenever an user wants to create a new element I simply create a new
modeless dialog(or window clas...Insert Contact Name and E-mail address into Subject When Creating A Phone Call
I am looking to insert the name of the sender\contact and e-mail
address into the phone call subject line. I have figured out how to get
the name of the sender inserted into the subject line but cannot figure
out how to get the e-mail address in there. The code I used is below.
Can anyone outline what code I need to use to get at the e-mail
address, maybe it's not actually possible?
var lookupItem = new Array();
//Get the lookup for the from attribute on the phone call form, this is
the person calling
lookupItem = crmForm.all.from.DataValue;
//Set the current sub...Create Order functionality
Can someone point me to some references and/or guides on what CRM's "Create
Order" button offers in terms of functionality. What can you do when you
close a Quote and then "Create an Order" from it?
Any help would be greatly appreciated.
...How do I create an introduction for my website using Publisher 20.
I have my website posted, but I want to create a short introduction video,
possibly from Powerpoint, just showing my website name and with maybe some
audio merging into the first page of the website.
Also, is there a way in publisher to keep music going the whole time during
all pages in the website?
Check out http://www.atxbass.com to see what I'm working with
Don't know how, but I know when I visit a site with music that cannot be turned off,
my stay on the site is brief and a one time only.
Might think about making your pages more narrow...
Mary Sauer MS MVP
http://off...Missing Measures in .cub file created in Excel
After using Excel's Offline OLAP features which create a
local cube file (.cub), many of the desired measures
which I included in the wizard setup are not displayed.
I'm looking for a reason for this.
The data populating this cube file is from a virtual
cube, so background calculations take place. I
considered that those measures requiring calculation
would not be included once seperated from the original
virtual cube... but many calculated measures WERE
included so I don't think that's the complete explination.
I've varied the measures included in the .cub file...Templates #10
Is it possible to create a template (that can be shared) that has
place holders for text, images, etc.? The template would also need to
not print the lines around the text boxes, or the placeholders for the
Create, use, or change a template in Publisher
"nejohnso76" <firstname.lastname@example.org> wrote in message
> Is it possible to create a template (that can b...Creating a rule for email by date in OWA?
Is there a way to create a rule using the OWA client to move all email older
than 14 days to another folder and out of the inbox folder?
Don't think so. OWA does not give you the same rich Rule functionality
provided by Outlook client, though whatever's available is better than no
Rule functionality at all.
"Jason" <email@example.com> wrote in message
> Is there a way to create a rule using th...Is there a template for a ticket
I need a template for an event ticket for publisher. Does one exist?
One here for Word, you probably could adapt it for Publisher
Mary Sauer MS MVP
"mortgage guy" <mortgage firstname.lastname@example.org> wrote in message
>I need a template for an event ticket for publisher. Does one exist?
...Invalid object name when I try to create a scaler udf in a stored procedure.
I am trying to create a report that shows a company name, all the advisors in that company, then the company's stats (there should be one row for each company). Each of these come from a different table. The advisors are currently being listed as one per line, which means the company name and the stats are all being repeated unneccesarily.
I want to concatinate the advisors, so that all the ones that belong to the same company show in the same cell.
I wrote this UDF which is located right before my SP:
CREATE FUNCTION [dbo].[ConcatAdvisorNames](@Company as varchar(20))
RETURNS VA...Error 8000ffff when creating 2-way ADC
Lab set up with copies of our Exchange 5.5 and Windows 2000 AD directories,
attempting to test upgrade from 5.5 to 2003.
Error message shows up on screen whenever a two-way Recipient CA of any kind
is created: "An unexpected error occurred. ID no. 8000ffff Microsoft Active
Directory Connector Management". This error prevents the CA from being
You can vary the Containers, the object classes involved (e.g., Groups only,
Contacts only, Users only), account permissions, anything. As long as it's
two-way Recipient, it fails.
This does not happen with a Public Fold...Creating thousands of hyperlinks in Excel
I'm creating a huge directory and I'd like to include internal
hyperlinks. Is there a FAST way to do this? i.e. I need to create 2000
hyperlinks, leading from one cell to a cell on another worksheet.
I'd use the =hyperlink() worksheet function.
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
>...How to create a report based on multiple queries
I am trying to create a report based on 30 queries . These 30 queries
are based on one table. When I use the Report wizard and select more
than one query I get the message " You have chosen fields from record
source which the wizard can't connect. You may have chosen fields from
a table and from a query based on that table. If so try choosing
fields from only tha table or only the query".
I do not know what to do.? Any guidance will help
On Wed, 29 Aug 2007 08:21:02 -0700, email@example.com wrote:
>I am trying to create a rep...Delivery Failure after creating calendar event
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Every time I Create a calendar event, I receive the following email:
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
/O=First Organization/ou=First Administrative
Group/cn=Configuration/cn=Servers/cn=MKPSERVER/cn=Microsoft System Attendant