Error Message when connecting pivot table to Access DB queryHi,
I am getting an error message when attempting to connect a pivot table in
Excel 2007 to an Access 2003 query. I have set up several pivot tables in my
excel file that connect to this access database (and other databases as well)
and refresh properly. However, I can no longer set up any more pivot tables
to any access db. The error I get is "Test Connect Fialed because of an
error in initializing provider. Unspecified error". Nobody is in these
access databases and I can open up a blank excel file and successfully set up
pivot tables to these databases. Is any...
y-error bars on data points within a seriesI am using excel 2000. I am some fellow grad students
all have a question regarding an easier method to place
indivual y error bars for data point within a series. For
example. I have germination data for 10 sites. The data
I want on the chart is actually an average for each site,
so I would like to put the standard deviation on each
data point individually. But, all of the data points
will have the same error bars unless I list each data
point as its own series. This takes a long time and is
quite a hassle. Is there anyway to do this without
having to do each data point as it&...
Conversion from Access 97 to 2003 & get a "Conversion Errors" tablIn Access2003, I'm selecting "Tools/Database Utilities/Convert Database/to
Access 2002 - 2003 File Format". I select a Access 97 file and hit the
convert button. After creating the new file name and hitting the save button
I get a message that Access encountered errors and I should check the
"Conversion Errors" table.
The Converted tables have the correct number of records, Forms and Report
look good and the Queries seen to run correctly.
When I open the "Conversion Errors" table I see 2 records with 3 fields.
Their fields are "Object Type&q...
How do i add a trendline to a graph with more than 1 data series?I am almost finished a graph which contains 7 data series. I would like to a
a trend line that takes into consideration all the data series, therefore
showing the general trend of all the data.
I dont have the knowledge or experience with Excel to work out a solution.
Any help would be appreciated greatly.
Libby
To use all data in calculating the trendline, you must have all the data
in one series. If they are in multiple series as an artifact of data
arrangement on you worksheet, then use a helper column to combine them.
If they are in multiple series to enable each series to have...
opening ms access 2000 file questionI share MS Access 2000 over a windows 2003 server.If a MS Access db is opened up by another user the only way I can openit at the same time is by opening the MS acesss program then use the File > Open option.It will let me double click the db file in windows explorer on a network drive but it does nothing. Thanks!"Ricky" <rfidler2004@earthlink.net> wrote in message news:%23qYXCkKcHHA.3648@TK2MSFTNGP02.phx.gbl...>I share MS Access 2000 over a windows 2003 server.> If a MS Access db is opened up by another user the only way I can open> it at the same time is by openi...
Outlook Web Access loin page (ASP)Hello,
Can someone give some information about creating a personalised logon page
to microsoft exchange 2003 through OWA.
I have searched the Internet and found information about it but no howto or
something like that.
Thx for the help !!!
This should help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;830827
"Strontje" <Strontje@pandora.be> wrote in message
news:Gz6md.6$C%6.5708959@hebe.telenet-ops.be...
> Hello,
>
> Can someone give some information about creating a personalised logon page
> to microsoft exchange 2003 through OWA.
> I have ...
Sent/deleted mail from Outlook appearing when I access WebmailEven though I delete all my sent items and empty my deleted items from
Outlook every day before leaving the office, if I log onto Webmail later on
from home the items still appear in the Sent and Deleted Items folders. Can
I stop this from happening? Once an email is deleted, I don't want it back.
Are you using exchange server? if you use the option to automatically empty
deleted on close, outlook doesn't have a chance to update the server before
it closes. Empty deleted items a few minutes before closing outlook. If
using imap or pop3 and leave mail on the server, do...
Analyzing Data on Different WorksheetsI have a workbook with four different worksheets containing about 10,000 data
points of flow with a time stamp on each sheet. Its too much data for me to put
into a single worksheet for analysis. I want to create a flow-duration curve
using all the data points on all worksheets. Is there a way to create a single
flow-duration curve (requires manipulating the entire data set) when the data
is spread out over 4 different worksheets?? and has so many data points.
Any help is appreciated.
Roger
FarWestEng wrote:
> I have a workbook with four different worksheets containing about
> 10,00...
Selecting date specific data from different spreadsheetsI have several worksheets for different places which each have budget
information regarding how much ‘Amount’ and when a payment is due ‘Date’. I
am trying to create a ‘totals’ spreadsheet which will collect the relevant
information from each spreadsheet so I can total the amount due for each
month due and if values change in the separate spreadsheets with therefore
update the ‘totals’ spreadsheet. VLOOKUP has been suggested but the months
vary in each spreadsheet and therefore their cell locations vary. I need the
formula to look for the specified month e.g. 01-Dec-05, then collect ...
How do I hide the Quick Access Toolbar in Excel 2007?The ribbon takes up so much space I bought a 3rd party program.
Now I would like to get rid of the QAT.
Thx
Get rid of the QAT only?
Button>Excel Options>Customize.
Uncheck "Show QAT below the ribbon"
Gord Dibben MS Excel MVP
On Sat, 14 Nov 2009 16:20:01 -0800, D7 <D7@discussions.microsoft.com> wrote:
>The ribbon takes up so much space I bought a 3rd party program.
>Now I would like to get rid of the QAT.
>Thx
D7 wrote:
> The ribbon takes up so much space I bought a 3rd party program.
> Now I would like to get rid of the QAT.
...
Compare and align rows of multiple but differing columns of data #2I have a table of 4 columns. One column has county names, one
population and the other two have data relative to the county name for
the given year. Each year a new set of 4 columns is generated.
However, some but not all of the county names are in the subsequent
year. Same thing for each successive year. How can I:
1) Match the counties from year to year so they align in a row with
corresponding data? What happens if year being used for comparison
doesn't have county appearing in later year?
2) Make master list of counties (in left column) for all that have
appeared in the data sets...
Query Help 02-14-08I have a query that pulls usage volumes, this works fine. The catch is
I have a list of all of the prices that that item has ever had (price
increases and decreases)
i.e. Item #300500
prices would look like this
1/1/1999 $4.50
3/4/2000 $ 4.10
7/8/2003 $ 5.56
11/1/2006 $ 5.20
1/1/2008 $ 6.00
I have a date parameter in the query that a person can program when
they would like to pull the from i.e. between 1/1/2007 and 12/31/2007.
is there a way to have it where what ever date they put into the
datefield that it'll pull the last date applying to that range? So it
would pull 11/1/2006 since...
WriteXml, DateTime, and Timezone dataThis is a multi-part message in MIME format.
------=_NextPart_000_0040_01C5D4C2.CF4AB1D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Greetings.
I am using a myDataSet.WriteXml(StringWriter) function (and then using =
the ToString() function to convert it to a string) to build an XML =
string based on the contents of my dataset. This in itself works great.
I am then passing this string back to a PowerBuilder module that is =
taking this XML string and doing what it needs to do with it. This is =
almost working great as well. It wo...
how to open multiple outlook data file with on clickHi,
I have about fourty archived files. Normally we would go File --> open -->
outlook data file --> browse to the location, click on the file and the file
will open.
As you can imagine manually open the data files will be quite tedious.
Anyone has any idea how i can automate this?
Regards,
Zeeshan
On 2/26/2010 4:46 PM, Zeeshan wrote:
> Hi,
> I have about fourty archived files. Normally we would go File --> open -->
> outlook data file --> browse to the location, click on the file and the file
> will open.
>
> As you can imagine manua...
Charting Time Series DataI want to replicate the graph format shown in the first graph of the
following article:
[url="http://www.dmreview.com/article_sub.cfm?articleId=1031173"]
I think this format would work well for my purposes, though my data is
slightly different:
Campaign/ Tracking Period /Mail or Control/ Response Rate
Jan 30-days Mail 1.25%
Jan 30-days Control 0.15%
Jan 60-days Mail 2.39%
Jan 60-days Control 0.41%
Feb 30-days Mail 1.50%
Feb 30-days Control 0.25%
Feb 60-days Mail 3.71%
Feb 60-days Control 0.98%
I'd like to have "columns" of line graphs where each column ...
Cannot secure access to mail.mydomain.com
I am a new IT person who took over an already installed system with SBS
2003, SP1 and Exchange 2003 SP2. Also, the previous IT person set up
the DNS at godaddy.com. I have no internal records pointing to our
internal website or anything. I assume that even our people are
directed to our website, etc from the Internet.
My problem is that if someone types mail.mydomain.com or
mail.mydomain.com it takes them to the Windows Small Business Server
Home Page and they can access the internal website!!
If they type mydomain.com/remote or mail.mydomain.com/remote then they
are asked ...
Validation in Data/FormIs there any validation function for user when they input data throught
Data/Form which was created default by excel??
Hi
have you tried 'Data - Validation'. If this does not work
you have to create your own userform
>-----Original Message-----
>Is there any validation function for user when they input
data throught
>Data/Form which was created default by excel??
>
>
>.
>
Data Validation only affects entries that are typed into a cell. You
could try John Walkenbach's Enhanced Data Form. It's a free add-in that
allows combo boxes, so it could display...
Removal of thousands seperator in downloaded dataI have downloaded data with an open space as thousands seperator, an example
is a number like 2 098,67. Excel will not recognize this as a number. How can
I remove this thousands seperator so that the number becomes 2098,67? I need
to do this to use the data in another program.
See other post.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"finney78" <finney78@discussions.microsoft.com> wrote in message
news:CEE4BBB3-12AB-4DDD-AD0A-F88ADD242B73@microsoft.com...
> I have downloaded data with an open space as thousands seperator, an
example
>...
Convert Shape Sheet data to Excel Visio 2003How can I take the data information on my shape sheet within Visio 2003 and
convert it to an Excel spreedsheet? An will I be able to manipulate changes
made to Excel sheet to Visio shape sheet?
thanks
Mlaw42
Roundtripping of data between shapes and external data sources is a very
common request, unfortunately even at the latest version (v2007) it still
requires custom code. The caveat is that o2007/v2007(pro) have put a
significant amount of new functionality to support this.
al
"mlaw42" wrote:
> How can I take the data information on my shape sheet within Visio 2003 an...
A better way of constructing a LINQ queryHi folks,
I�ve got a LINQ query that filters out items in a database that begin
with a number. It looks like this:
char[] numbers = new char[] { '0', '1', '2', '3', '4', '5', '6', '7',
'8', '9' };
var result = (from i in Items
where numbers.Contains(i.Name[0])
orderby i.Name
select i).ToList();
Now this works, but I�m sure there must be a more efficient way of doing
this. Can anyone suggest a way that I can do it in a more efficient manner?
Cheers,
--
Dylan Parry
What about:
var r...
how to save Excel data as ASCII* text?Hi,
How do I save excel data as ASCII* text? That option is not there at all
under "Save as" option.I tried copy pasting the data onto word or notepad and
then tried to save in that format,but that did not work.Until I get the
ASCII*txt format I cant do my statistics on my data.I have my dissertation
due shortly and so would greatly appreciate any suggestions ASAP.
Thank you,
Yours sincerely,
Mitali Das.
Did you try saving it as a .csv file, or a .txt file, or a .prn file?
Each of those is plain old ASCII text.
Mitali Das wrote:
>
> Hi,
> How do I save exc...
Business Portal Requisitions: default Line Item Field AccessSuggestion:
Add line item field access properties to the BP requisition portal roles and
assign them to each user when the role is assigned.
Its a real challenge to set up a new user when (after you've set them up in
BP and assigned them roles) you have to go to the Requisitions Manage Users
screen and set the Line Item Field Access fields. They default to disabled
so each user must have the proper fields manually enabled during setup.
This can be a pain when a large number of users are being created.
----------------
This post is a suggestion for Microsoft, and Microsoft respon...
Help w/ linking data between worksheetsI would like to set up my workbook so that: if in a certain column on the
main sheet code #'s 1-7 are entered, the corresponding row is automatically
transfered over to the worksheet related to those #'s....1-7. Any
suggestions?
Perhaps this approach would work for you ..
In Sheet1
------------
Let's say you have 3 cols of data across in cols A:C,
headers in row1, data in row2 down:
Code Field1 Field2
C1 Data1 Data1
C1 Data2 Data2
C2 Data3 Data3
etc
The identifier column for auto-extract of corresponding rows into the other
"Code" sheets is col A: "Code"...
statistic data about proceduresHello there
On sql server 2005 there are system tables which gives me exact data about
table activities: select, update, delete, insert...
it gives me good idea about activity of server.
Is there also activities table about store procedures as well? on 2005 or
2008
Roy Goldhammer (roy@top.com) writes:
> On sql server 2005 there are system tables which gives me exact data about
> table activities: select, update, delete, insert...
>
> it gives me good idea about activity of server.
>
> Is there also activities table about store procedures as well? ...
How do I update graphs automatically with periodic data updatesI am trying to use a data source of 52 weeks of information that I update on
a weekly basis. I can't figure out how to have the graph display blank cells
on the graph as blank instead of "0." My graph looks great right up to the
first blank cell and then the graph plumets to "0". I would like the graph
to just end where the data in the cells ends, and automatically pickup the
new information as I enter each week.
Infinitejest
You seem to be asking two questions:
1) how to have blank cells not plot as 0.
2) how to get chart to automatically "pickup the ne...