grouping a chart in Access
I have a query that is 31 rows. I created a report that is grouped by Farm
Name and House. The data shows correctly on each page for each Farm and
House, but when I add a chart it gives me the data on the first page, but
then gives me 30 pages of blank charts, till the next group. What did I
miss? I am using Access 2010 beta.
I expect the issue is with the section of the report containing the chart or
the Link Master/Child properties of the chart control.
MS Access MVP
"dstraub" <email@example.com> wrote in message
new...Run report on multi selected records.
I try to make a report for a custom entity that works like the Account
Summary: let's say that it's Customer's Inquiry Summary for entity Customer's
I made the report so that I'm able to run the report on Customer's Inquiry
But when I select multi records in the list of Customer's Inquiry and run
report, only one record is show in one page of the the report.
I would like to have the selected records appear in the report with each
record on each page.
How can I do this?
...Combo box list selection based on earlier selection by user
I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the Product selected from
combo box 1 and upload the corresponding RO# in the combo box 2 list. Now I
am using both combo boxes as Unbound and in the combo box 2 I have the two
columns Product and RO# - in the Criteria row of RO# I have the following:
Like IIf([Forms]![xa_f_lookup]![RO#]=" ",[Forms]![x...Excel 2007 and inverted charts
(sory for my language, I'm from Poland)
Why Excel 2007 is doing inverted charts? For instant, please write in
a1, b1, c1, d1 some text (a, b, c, d) and in next column (1, 2, 3, 4)
and do chart. Excel do from 'd' to 'a', not from 'a' do 'd'. Why?
Right click on the x-axis
Open Format Axis and on the Axis Option tab experiment with "Categories in
Bernard V Liengme
remove caps from email
"skuwka" <firstname.lastname@example.org> wrote in message
news:1181564334.992841.35080@p77g2000hsh...move row data to columns
We had a problem with some test data and instead of test results being
recorded in multiple rows 5 columns wide, all of the data was recorded
in one row multiple columns wide. The data consists of 5 readings
taken every second for a period of 2 hours. Each reading is in it's
own cell (no cell contains more than one reading). Do you know of a
way that I can move each set of readings (5 test results) into it's
own 5 column wide row?
i.e. currently shows in single row as:
0, 0, 0, 0, 0, 128, 128, 128, 128, 128, 234, 234, 234, 234, 234, etc.
and I need in 5 column wide rows:
0, 0, 0, ...orphaned mailbox's in Exchange 2003
For some reason I have about 9 mailbox's that have
suddenly become orphaned because their user accounts have
been deleted. I have used a utility in the past called
killmail that allowed me to disconnect the mailbox's from
the user accounts so that I could recreate an account and
then reattach the new account to the old mailbox thus
allowing the user to keep the mailbox with it's contents.
Can anyone tell me how I can get the killmail utility so
that I can do this?
The same functionality of killmail was built into Exchange 2000 SP2 and
beyond. Its called remove Exchange a...Pie Chart Lables are scrambled
I have a Pie chart in excel that has it's data automatically updated from an external SQL data source. When the data is refreshed, the labels are moved all over the chart, and some are even moved out of the viewable area completely
Does anyone know how to stop this happening
I am trying this for the first time and am having the same problem.
...Using Custom Views
Complete Excel noob here -
If I've defined a custom view in one workbook, how can I apply it to
another. It is not shown in the list.
What I want to do:
I have a workbook with columnar data similar to a check register. I have set
up the formatting for display and print formatting, including headers &
footers. This data is for a specific client but I want to save that
formatting, both visual and print so that I can create new workbooks for
other clients and apply the same formatting. I thought that by saving the
custom view it would work but it is not seen outside of the workbo...Report using Organization Chart from HierarchyID
Anyone with an example of creating an organization chart using HierarchyID?
I have created the hierarchial nodes such as
Is there any way of generating an organization chart easily, where the root
search the web. good examples abound, especially from itzik ben-gan.
SELECT hid, hid.ToString() AS path, lvl, empid, empname,
ORDER BY hid;
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Gum" <email@example.com> wrote in message
news:3B150CBE-D8...serialization when using reflexion
My application needs to serialize a class, which was generated with
xsd.exe from a XSD. It was working .NET 1.1 and it is working with .NET
2.0 very well.
Now I need my assembly to be a plugin, and to be called by reflexion,
but I get this Exception:
"There was an error generating the XML document."
"Unable to cast object of type 'NMI.STARTi.EDI.Ingram.OrderRequest' to
The method I'm calling is static (I tried non-static as well) and the
class ...Can't select objects in Excel 2007
I'm trying to create a form in Excel 2007, and although I can manipulate,
copy & paste controls (check boxes, etc)
I can't select multiple objects to align them, etc.
I've checked on-line help (and have followed the instructions), and other
websites, but no one seems to have indicated a problem.
It is extremely cumbersome and I need a solution. Any ideas?
Thanks in advance,
I know this is about a year too late, but it may help others who have stumbled across this page looking for similar help.
On the Home tab, in the Editing group, click Find & Select....Lot Selection not Showing when I select PO on Receiving Entry
Usually, the Lot selection screen would pop up when I select a PO at the Line
Detail of the Receivings Entry, now it does not! And GP will let items post
without a lot number! It seems as if a setting has changed. Any ideas
Any help is appreciated.
Are you sure the item is marked to track lots? This wiould be set item by
item on the Item Maintenance Options window.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
I have 6 workbooks all with a single worksheet. I want to bring them
together into a single workbook with 6 worksheets. I can do it via copy &
paste, but is there a simpler way please ?
I have excel 2007
You might want to take a look at Ron's article here:
But for only 6 sheets, it might just be easier to copy each worksheet.
*Remember to click "yes" if this post helped you!*
> I have 6 workbooks all wi...how do I use Microsoft Ooutlook with Yahoo Mail
I use Microsoft Outlook. How do I use Yahoo Mail with the M/O. I do all it
says and I still cannot get it to work.
Debby Townsend wrote:
> I use Microsoft Outlook. How do I use Yahoo Mail with the M/O. I do
> all it says and I still cannot get it to work.
Unless you have a paid account , or use yahoo UK then you can't.
Thank you Gordon. I live in Totola, British Virgin Islands so will need to go
into Cable and Wireless to find out what the ISP address is.
But how come you can use Outlook Express with an account like Hotmail?
&g...How do I have stacked columns and a reg col. on same chart?
I have three variables - payroll expenses, vendor expenses, and management
fees. I want payroll and vendor to be on top of eachother, and management to
be next to them. Can anyone help?
> I have three variables - payroll expenses, vendor expenses, and management
> fees. I want payroll and vendor to be on top of eachother, and management to
> be next to them. Can anyone help?
Have a look at Jon's page which has a collection of links to examples of
how to produce clustered stacked charts.
http://peltiertech.com/Excel/ChartsHowTo/Clus...Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
I recently uninstalled and reinstalled Office 2003 and now all the built-in
custom charts are missing from Excel!
When creating a chart using the Chart Wizard, under the Custom Types tab,
there is supposed to be a list of built-in charts, when the Built-In radio
button is selected. Now, there are none.
Does anyone know how to restore those built-in charts? I have tried
reinstalling, and that does not work. Also, I could not find an option
related to this using "Modify" in Add/Remove Programs.
I have Macros that use those charts, and I also need those charts for
certain rep...Select contact then hangs
Hi, please help. I have a user that when she selects a
contact using To: in a new email, after selecting 2, it
closes outlook??. Spec is W2kSP4\office2k with all
windows updates and office updates installed. Profile has
been deleted and re-created, plus i have set up personal
folders and moved contacts into there, and set that
folder as a default, but makes no difference.
...Nudging Text Boxes in a Chart
Has anyone found a way to "nudge" data labels in a PPT chart? I know I can
move them by clicking and dragging but when I try to use the arrow keys (as I
do for objects) the cursor tabs to other areas in the chart. And when
clicking and dragging the labels they seem to snap to a grid and I have very
limited control over them.
Thanks for any insights!!
No one has to "find a way", there are already several standard ways to
accomplish that. :o)
Turn off the "Snap Objects to Grid" (in 2003 View, Grid and Guides) or in
that same loca...Selecting rows from various sheets
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
aa 1 1 1
bb 2 2 2
cc 3 3 3
aa 4 4
cc 5 5
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5
shav's Profile: http...select text in Calendar
I'm working on a calendar in Publisher. I'm adding text into a cell by
spacing down 1 point, then typing in 8 points. Doing fine until April. At
that time, I can only select cells (whole days). It will not let me select
the text. Help is no help. Any hints out there. Did I accidentally select
something to do this?
Have you added a picture to the cell or a shape? If you have send it to the
back, make the cell no fill and try again.
Mary Sauer MSFT MVP
"GoBonnieGo" <GoB...Combining Two Seperate Companies Window's Infrastructure
My company just did an acquisition and we are in a process of
Integrating our networks. For discussion sake lets call Company A &
For now, Company A has windows 2003 environment. It's in native mode.
We have one forest for Company A which has an empty root domain. We
have two child domains in this forest. One child domain is for
corporate office network and other is for
Our production network. We do have users and service accounts in both
Domains and a two way trust relationship is built between both domains.
We have a
Exchange server 2003 (with Sp1) in corporate network d...How to move Ex2k3 Sp1 between Admin Groups
All my Exchange 2003 servers have Sp1 applied. (we are still in Mixed Mode).
How do I move a Exchange "003 server from an admin group with only itself
and an Exchange 5.5 server init to another admin group with both Exchange
2003 & 5.5 servers in it ?
1) How do you actually do it ?
2) Should I remove the Exchange 5.5 Server first or remove it after the move
You cannot move servers between admin groups. You can move users between
admin groups, though if:
a) You're in Exchange native mode
b) You use the site consolidation tools in Exchange 2003 SP1...Creating a worksheet from others (IF statement)
I tried looking fort his answer and I think it is answered in parts of other
questions but I cant get it together.
I have a file called invoices.xls which is a workbook of 12 monthly
worksheets for the year. Each item in a monthly worksheet is a row that
houses project information financials etc (project cost, outsourced cost,
project name etc)
We also have another file (wip.xls) where we double handle all of that
information and cut and paste only those files that we are currently working
I would like wip.xls to be automatically populated with certain cells f...Bubble Chart Set up
I have the following data:
Supplier, Brand, Retail Price, Volume
I would like to chart it as follows:
Suppliers across the bottom, with their respective brands above. The
position on the Y axis should be determined by the retail price.
Each brand would be a bubble. The size of the bubble should be
determined by the brand's volume.
I can not figure out how to get this chart done in Excel 2007. (I
have also tried powerpoint) Any help would be appreciated.
On Fri, 8 Feb 2008, in microsoft.public.excel.charting,
>Suppliers across the bo...Moving Exchange DB's to a new server (different name)
In a DR test, we moved SG's to a new server, different server name,
same SG and MS name. MS mounts, can not connect to mailbox. Delete
mailbox, create a new one, we can then connect. Delete this mailbox,
reconnect to the original, and now we can connect.
How can we accomplish this in bulk?
In other words, after doing a system state restore of AD, then a system
state of Exchange, restored MS file, mounted, etc. We were unable to
connect to these mailboxes. I am assuming this is related to GUID's.
Users in AD specify a server by name. When you say that you move mailbo...