How to link with an Access DB
Hi, I have an Acces DB with many tables.
I need to choose the name of a customer in a cell of Excel.
For example, in acces I have this tables:
I need to choose the last name from a drop down menu in a spreadsheet and
then in other cell I need to put all the data regarding the last name that
I hope to be exaustive, and sorry for my english. :-)
...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Table link documentation
I am having trouble trying to locate A/P check data that has project related
costs. I found the check data but it is does not indicate the projects, I
found the project data but can not determine thye logical link between the
two tables, I may be using the wrong tables the tables I am using are PM80500
and PA31102. Is there any documentation of how all the tables in the system
are logically link. I am trying to write reports in MS Access, but there
are 1500+ tables in GP (version 10)
In an effort to find the correct table you can do a number of things (believe
me I do)....Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...how can i edit the positioning of the balloon comment in a word fi
how can i edit the positioning of the balloon comment in a microsoft word
please reply on my email
What you can do is adjust the space reserved for the balloons in the margin.
In Word 2007, on the Review tab, click Track Changes, and then click Change
Tracking Options. Change the "Preferred width" setting.
Microsoft Word MVP
"melikelmalik" <email@example.com> wrote in message
> how can i edit the positioning of the balloon comment in a mi...Outlook 2003
In Outlook 2003,
#1 Is there a way to refresh the unread folder so that read
messages no longer apear? Right now I have to click closed the unread
folder and click it again
#2 Is there a way to create a toolbar button that goes directly to
...Opening Multiple Web Links in a Column
I am very new to using web links in excel. A task I do very often is
open a list of different websites that are in various columns in an
excel spreadsheet. I am quite sure I am doing it the slowest way
possible, so I need some help please. Basically I have been clicking
on one link at a time. When I do this, the first website opens and
excel automatically minimizes, then I have to go re maximize excel and
then click the next web link and the same thing happens, etc... very
time consuming. I am wondering if there is a way, either through Excel
or whatever means necessary, to open all...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Chart Linking
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Link Outlook 2003 to Exchange 5.5 over VPN
How do you do it?? I have a VPN, I can ping the ip of the
mail server (NT4) but cannot see it when I test from
within Outlook 2003 exchange account
Put the IP address and server name of the Exchange server in your local
computer's hosts file and see if you can then ping by name - if you can, you
ought to be able to access the mailbox. That's just one quick way to do
it....but it ought to work.
> How do you do it?? I have a VPN, I can ping the ip of the
> mail server (NT4) but cannot see it when I test from
> within Outlook 2003 e...MS Excel: Linking spreadsheet and Absolute and Relative Paths
Our staff uses several spreadsheets, many of which are linked to
SEVERAL other spreadsheets.
Of course, all of these documents are stored on the network.
The problem we are having is the absolute path that the link uses.
Some users will access these file via (e.g.) 'S:\excel documents',
while others will use 'R:\excel documents' to connect. Each time a user
connects there is a 50-50 chance they will have to update the links.
** What a hassle**
Is there any way to use a relative path to link spreadsheets?
Using a UNC path isn't possible due to security restrictions and
cha...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...combination clustered column and stacked bar chart
I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.
I don't know if I'm fully understanding what you want. Possibly these two
examples can hel...Bulk Edit Parent Account
I seem to have the problem of not being able to bulk edit parent accounts in
CRM 4.0. I have tried to follow the instructions for fixing this in 3.0,
http://support.microsoft.com/kb/933898/, but the lines they have you change
are not in the 4.0 version of the account entity xml file. Is this a known
bug in 4.0 and is there a fix?
...Error in chart wizard
The following error occured in Excel 97:
-> User clicked on chart wizard
-> clicked the customer types tab and got the following
errors one after the other:
1st - Microsoft Visual Basic Permission to use object
2nd - Microsoft Excel Error accessing user-defined custom
3rd - Program error Excel.exe has generated errors and
will be closed by windows. You will need to restart the
program. An error log is being created.
This happened on more than one machine. I do not get this
error message on my machine. I have a screenshot of the
errors if it would help.