vb.net conection string to C# -- problem
Here is the oledb connection string which works fine in VB.Net
connOle.ConnectionString = _
& "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\;Extended " _
I am having problems with the doublde quotes inside the string
..."Properties = ""...""" part. Here is what I tried that is not
+ "Data Source=C:\\;"
"Extended Propert...Pivot table using different worksheets/same workbook
I need to know if there is a way to create one Pivot Table for multiple
sheets in a workbook. For example, I have separate sheets for each month for
a sales report and would like the Pivot Table to show the totals for the
You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:
> I need to know if there is a way to create one Pivot Table for multiple
> sheets in a workbook. For example, I ...How do I change default file location for Publoisher 2007?
MS Publisher does not seem to have an easy way for changing default file
locations for saving work. If anyone has figured out how to do this, please
share your secrete with the rest of us.
You can create a folder, when you *save as* look for the tools menu on the upper
right, add this folder to *My Places*.
You can use Favorite Links in Vista.
It will be an extra click.
"eephraim" <email@example.com> wrote in message
> MS Publisher do...EditControl Append String
I am using the following code to append a string to the EditControl.
1. CString strBuffer = "";
2. GetWindowText (strBuffer);
3. if (!strBuffer.IsEmpty())
4. strBuffer += "\r\n";
5. strBuffer += str;
7. LineScroll (GetLineCount(), 0);
The code compiles fine but I get an error message when execution reaches
line 6. The Message is :
"An invalid argument was encountered".
Why am I getting this message?
Is there more code involved. That message often comes from a DDX or DDV
statement that is using a control ID that ...Different outcome of adding ribbon via xml instead of in a table
Hi, I am just trying to understand why when I have a table in my database
called Ribbons and run the following code at startup (via autoexec) the
ribbon is gone, which is good
Public Function LoadRibbons()
Dim RS As Recordset
Set RS = CurrentProject.Connection.Execute("SELECT Ribbons.RibbonName,
Ribbons.RibbonXML FROM RIBBONS")
If Not RS.BOF Then
Application.LoadCustomUI RS("RibbonName").Value, RS("RibbonXml").Value
Set RS = Nothing
but if i dont want to store the xml in a table where a clever person might
change it but want it i...Error:A global catalog cannot be located
When I click on the members tab of the a group property with administrative
tool on my PC. I've got error for
"A global catalog cannot be located to retrieve the icons for the member
list. Some icon may not be shown."
Our domain (windows 2000 server) have one DC which holds GC too. I find
after some while, I try the function again. It works. Any hint for the
Is the DC also DNS server and are the clients configured to use only this
on the NIC as DNS server? Please post an uneditd ipconfig /all from the server
and the client with th...String of numbers
I have a problem to make a string of numbers. What I'm trying to do is
The result I want in Cell C1: 450001005975
I'l be wery grateful for some help!
You can start with this
=replace(A1,"-","") & text(B1,"000000")
> I have a problem to make a string of numbers. What I'm trying to do is
> Ex. 1
> Cell A1
> Cell B1
> 5...text-to-speech with different languages
Is there a way to use the integrated text-to-speech feature in excel with
tts engines other than English engines?
I already have some tts engines with different languages (from lernout &
hauspie) installed, but they are not selectable on the text-to-speech tab in
the speech item located in the control panel.
Thanks in advance,
...how to add pages with different orientations
I am making a publication in which I need some pages to be in a portrait
orientation and others in landscape. How can I do this?
On Mon, 20 Feb 2006 01:14:26 +0000, Ebony wrote
(in article <C7935245-3680-4BE4-BAE5-2B714ED5AD1B@microsoft.com>):
> I am making a publication in which I need some pages to be in a portrait
> orientation and others in landscape. How can I do this?
Ah another pathologically lazy fuckwit who cannot be arsed to STFW before
Just by posting this you have proved that you cannot be bothered. This
question has been asked - and answered - a...Cost basis in different currencies
I am using Money 2004 Deluxe and I am using Danish Krone (DKK) as my base currenc
In my investment portfolio I have investments in varios currencies (DKK, USD, EURO, etc.). For all investments in currencies other than DKK I have a problem with the calculation of the cost basis on thereby also the gain. For instance an investment shown in its original currency such as USD with a historical cost of USD 100 will now show a cost basis of USD 103. I suspect it has something to do with exchange rate conversion back and forth with my base currency (DKK) when I update Money(?). However the historical...How I can combine cells of different pages?
I mean how can I add, divide, mutliply, and so on figures of different cells
for example, add a figure of the cell f4 of the page 1 with the cell g5 of
the page 2.
When you say page 1 & page 2 I assume you mean sheet 1 & sheet 2. You can
apply mathematic functions for a cell using different sheets but you have to
name the source i.e. =A1+Sheet2!A1. An easy way to do this is begin your
formula on sheet 1 = A1+ and then go to the cell in the sheet where it
resides, click on the cell and click on your active sheet. Excel will
automatically place the name reference of the cell...Comparing a variant string with char*
I am trying to compare a variant string with a char* constant. The code
compiles on VS2002, but VS2005 gives the following compilation error,
Error 1 error C2678: binary '==' : no operator found which takes a
left-hand operand of type '_variant_t' (or there is no acceptable
conversion) c:\documents and settings\projects\test\test\test.cpp 25
The code is as follows,
static _variant_t _getVARIANTTfromRs();
int _tmain(int argc, _TCHAR* argv)
if(_getVARIANTT() == "Y")
retu...c1041724 restoring on different server
Hello I am trying to restore the exchange server to another box, ive
tried replaying the logs and even eseutil /p /i or just /p but
the same error, i am running exch 2000 enterprise, an upgrade from sbs.
the store wont mount. I have support for chinese and other languages on
both the production server and the restore server. I tried restoring AD
on this machine but exchange complains about not been the schema
master. The ad on this machine has no accounts, i figure after reparing
the database i can map the mailboxes but now luck for a few days. Any
recommendations apreciated. thanks
I got it...tools>options> cannot change file locations
I recently moved to a new computer. I transferred my MS Office settings
from the old computer to the new one. I had set the Autorecover save
location for an excel file on a different partition on the old PC. The
file opens fine on the new computer but under Tools>Options> when I try
clicking on any of the tabs, I get an error message that the partition
cannot be found! So everytime it tries to save an autorecover version,
it cannot and gives an error message, and does not allow me to change
the location! I was wondering if there was another way to change the
location of the ...How can I put two variables with different scales on the same char
Plot both series together in the chart, double click on one series, and on
the Axis tab, choose Secondary.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
"Candace" <Candace@discussions.microsoft.com> wrote in message
...overlay two time series with different data amount in chart
I have the stock quotes of two different companies. Of stock A I have daily
data and of stock B I only have weekly data. I'd like to overlay the two
companies' stock quotes in a diagram.
How do I have to configure excel for that it stretches the quote for the
company for which I only have weekly data?
any help is appreciated?
This might be a little klutzy, but see if it works for you. Make a copy of
each company's data:
For Company A:
Jan 1 200
Jan 2 201
Jan 3 200
Jan 4 199
For Company B:
Jan 1 222
Jan 8 233
Jan 15 232
J...MFC-App on W2K and NT
i have an application running under W2K/XP and NT. while it behaves normally
with W2K and XP the app claims 100% of CPU-usage under NT though no activity
is forced by the user - just after starting the app the CPU-usage increases
...Different footer on same worksheet
Is there a way to create different footers on different
pages of the SAME worksheet, or do you have to put the
information into seperate worksheets and create seperate
footers for each?
You need a macro to do this
Regards Ron de Bruin
"Christina" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Is there a way to create different footers on different
> pages of the SAME worksheet, or do you have to put the
> information into...Message Input with link to different work sheet
What I would like to do, is create a link from a 'hint' (or an error
message) to another worksheet that appears when the user focuses on the
particular cell or gets an error message. How do I create a link (or can I)
through the Message Input dialouge under Data > Validation??
More specifically, I am creating a workbook that contains different hardware
and software that is assigned to different people. I have one worksheet
titled 'Lists' and there, I am adding all the items that will be inventoried
or tracked. So, on the 'Lists' worksheet, there is a c...How to add records to a subform from a listbox on a different form
This is driving me insane.....
Normally one would select products on an orders form from within a subform
that is linked to OrderDetails, this subform being linked via its PK to the
main form based upon Orders (say).
I have way too many products, of too complex a nature to select in this way.
So I have built a search form which shows the results of a search in a
listbox - which includes the products PK. Now, how do i add the selected item
in the listbox to an 'orderDetails' subform? It appears simple - a matter of
referencing a subform - but it's not!
Can a...What's the different for PNPDTest between WLK 1.5 and WLK 1.2
I am working on Windows Para-virtual driver for Xen virtualization platform.
There is a bus driver enumerate child disk and network device. A SCSI
miniport and NDIS miniport driver are used to service these disk and network
There days I use WLK 1.5 to run 'unclassified' signature test for my bus
driver. Find that 'Plug and Play Driver Test' cannot pass in WLK 1.5 which
was passed in WLK 1.2. 'Run Surprise PNPD Test' was failed with error message
'Run Surprise PNPD Test' does not exist. CPK file told me that 'Surprise PNPD
Test' ...help please with creating a Query with different
Hello: I have a database of resources to use with clients with depression,
anxiety, stress etc. I have the symptons (depression anxiety etc) as yes / no
fields. I want to make a query where you can enter the sympton e.g.
depression and the query provides a list of only those resources where the
depression box is yes. I tried putting [enter sympton] in the field of the
query and 'yes' in the criteria but that lists all the resources. Can someone
tell me where I am going wrong. Thank you.
On 27 feb, 07:40, Helping People Ros <Helping People
Ok, we began with (SEE Exchange 2k3 in Child domain - Best Practices) a
parent domain AM.com and childe VA.AM.com. I need to build a Recipient
Policy that makes different default Email addresses. the Parent domain
needs %First.Last%@AM.com and the Child domain's users need to have
%FirstInitial.LastName%@VDA-SYSTEMS.COM but don't necessarily need both.
what do you think??
Can create RP for child domain based on upn suffix (if you don't change the
default for child domain accounts, it should be
Or you could add a new UPN suffix for chi...how do I convert text string into a cell reference
I have a spreadsheet with multiple pages (a summary sheet, plus multiple
single sheets with common format data for different products). In the summary
sheet, I want to keep the cell reference the same, but change the page
reference according to the column that the data is in. That way I can change
a cell at the top of the column to pull up the right data. I can create the
cell reference OK in text form using Concatenate , but cannot see how to
convert the resultant text string to get back to the real data. Any ideas ??
You can use the Indirect function to return a reference. For exampl...CRM 4.0 new deployment datbase file locations ????
When you deploy a new organization it seems that CRM tries to place the
database and log files in the same location as when first installed.
The problem is that we have moved log files to new disks on another drive
and when creating a new organization it tries to create the log file on the
old location even if we have changed the default location paths on the SQL
Does CRM store a path for new databases/logfiles somewhere or how is this
The problem is that the organisations couldn't be created before we made a
directory on the old location and then we had to m...