Showing Specific Data from Master Sheet to Another Sheet
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
I have tried pivottables but I am having issues showing the data in it
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jo...Activities don't show up until we hit the refresh button
We upgraded from 3 to 4 and it appears that the upgrade did not complete
successfuly, but the users used the system.
Everything appears to be working well except for a couple of strange things
like when we create an activity the activity does not appear until we hit the
Refresh button, going to history and coming back does not fix the issue, only
the refresh button any quick fix on this one?
...SBS 2008 Fax Sent Items Not showing all faxes sent
I need to allow sent faxes to be seen by all users. I have Windows XP and
Windows 7 64bit client machines. Currently they can only see their sent
faxes. In SBS 2003 they were able to see all sent faxes.
Could you create an Outlook rule based on the fax sent acknowledgement that
copied the fax to a public folder?
"RodSoh" <RodSoh@discussions.microsoft.com> wrote in message
> I need to allow sent faxes to be seen by all users. I have Windows XP...Show All Groups in 2007
I've looked for this setting, but can't seem to find it -- or, maybe it's not
available (which would totally surprise me) -- is there a way to always "Show
All Groups" in Access 2007 as opposed to having to right click on the
navigation pane and activate all the time? I prefer to see all my objects at
once. Thanks for any help.
Yes: the top of the Nav Pane has a drop-down. Choose:
To see them sorted like previous versions, right-click on the top of the Nav
Pane, and choose:
Category | Object Type
Allen Browne - Microsoft MVP. Perth, W...Upgrade from 2004>2006 Advice plz
I like the free support which is running out for 2004 and will bite the
bullet and go to 2006 deluxe.
Any hints? (I remember that 2005 was a total mess)
I have 2004 and it doesn't run out to 2007, that is when I'll upgrade.
"jnsaunders" <firstname.lastname@example.org> wrote in message
>I like the free support which is running out for 2004 and will bite the
>bullet and go to 2006 deluxe.
> Any hints? (I remember that 2005 was a total mess)
I skipped 2005 and am satisfied with 2006. Of course, it d...Outlook 2007 256 Color Mode
Just returned home from a business trip, opened up my Outlook 2007 and
it was UGLY! Looks like its running on 256 color mode or something.
Running on Microsoft Vista / Office 2007 / Dell GX620 pc. It was
working before I left.
Not sure what cause or solution is. Tried doing a Office Repair...no
If you have a solution, please e-mail me at email@example.com as I may
loose this site location.
Is it ONLY Outlook that looks that way?
Ben M. Schorr, MVP
Roland Schorr & Tower
<firstname.lastname@example.org> wrote in message ...Messages stuck in Outbox + Heavy CPU load Outlook 2007
I am using Outlook 2007 with Windows Vista Ultimate.
I have a very annoying problem. On a random messages, Outlook "decides" that
a certain message will not leave the outbox whatsoever, even if I will write
the same message again and again. It happens usually with attachments
(usually small ones) but not always.
This is what is happening usually:
I am writing the message as usual, and trying to send it. In the lower
corner, Outlook informs that send/receive was completed successfully but the
message remains in the outbox, and somehow blinks a little (if I can
describe it ...access 2007 and custom toolbars in earlier version
Is there a way in Access 2007 (Enterprise) to modify a custom toolbar
created in say Access 2002? In the help there are only topics about
the quick access toolbar. I want to modify the action of a button, but
right clicking and choosing customize, like used to be so easy (once
you get used to it), is no longer possible. Does that mean no more
custom toolbars and no backward compatibilty here?
Help would be very welcome as the user friendliness of my user's
experience is at stake here.
...I can't run My outlook 2007 as its capacity is exceeded. How can .
My outlook 2007 has exceeded is maximum capacity two days ago and since then
I can't run it since I am always getting a system comment saying that I need
to empty folders to have it back - which I did inquite a large number os them.
Now I would like to know how can I overcome this situation since, as I
said, I have emptied quite a lot of folders and no result was obtainesd so
Kindly help me with your advices. the soonest if possible
There is no such thing as Maximum Capacity in outlook. How many
emails a day do you receive? ...How can I prioritize tasks by number in Outlook 2007?
I am trying to create a custom priority for my tasks in Outlook 2007, but I'm
not able to edit the field that was created when I changed the settings to
include a custom priority. I'm trying to put a number into it, so that I can
sort my tasks in a certain category by number, but I'm not able to.
We aren't watching you and your explanation is missing details.
Where in Outlook are you trying to view the Tasks? There are 3 places to see
If in the Task Folder, what View are you in? If in Tasks folder you
probably need to turn on in-line editing.
Judy Gle...How do I send newslette in email without showing the publisher too
When I email my newsletter as an attachment, when you open the attachment, it
takes you to the publisher program page where I built it. How can I send a
"finished" newsletter out?
As a .pdf file.
MVP Microsoft [Publisher]
How to ask a question
"Lifefire" <Lifefire@discussions.microsoft.com> wrote in message
> When I email my newsletter as an attachment, when you open the attachment,
> takes you to the publisher program page w...DPM 2010 standalone tape drives
I have a two drive seagate dat72 device that I am trying to configure
to span both drives for a protection group.
I think that the problem is that they are seen as two seperate
libraries (standalone drives)
Is there any way to span these two devices with a single protection
On May 5, 11:43=A0am, Ken <kgare...@gmail.com> wrote:
> I have a two drive seagate dat72 device that I am trying to configure
> to span both drives for a protection group.
> I think that the problem is that they are seen as two seperate
> libraries (standal...Money 2007 H & B + Windows Vista
I have read a lot about problems with installing and using Money (2007) on
machines running Windows Vista. Is there some kind of "manual" how to go
about the install procedure? A manual that describes where to have the
program installed installed and where to keep the data? And a manual that
describes how to keep the rights as an administrator as you would normally
have under windows XP?
And maybe there are some other issues that I haven't thought about.
"Eric" <email@example.com> wrote in message
news:468fe69d$0$37724$5fc3050@dre...Excel 2007. How do I get un-installed add-ins off the toolbar?
I have 2 Large Icons on the ribbon/toolbar of Excel 2007. These are
Omnipage and s-force. Both of these have been uninstalled and I have
de-activated both add-ins. How do I get these off the toolbar forever?
...Balances don't show when reconciling
I just upgraded to Money 2004 and the totals dollar value
of debits and credits cleared no longer shows. Instead,
this line shows:
"The difference between your statement and register is:"
along with the difference. I want to know the dollar
value of debits and credits I have cleared so far and
compare that with the bank statement.
Somebody at Microsoft thought this was an "improvement" compared to the way
they presented the data in M03 and earlier. It's probably something that
came out of the usability lab after they took their great grandmother in to
see if ...Transaction error in Money 2007
Since TAXCUT is out and Money is free with it (Staples), I purchased and
upgraded from 06 to 07. My first download resulted in a transaction on my
Fidelity account that listed the sale of one mutual fund and the purchase of
another. Following the prompts I accepted each transaction but received the
An error occurred but Money was unable to retrieve and display details about
what happened. (Resource = rcmpiad. Error = 4061.)
I have tried deleting the transaction but it continually says 1 transaction
I have run salvage and it claimed to fix some on-line issue...Stop Buttons showing when opening up form
I have a button on my Main Start up page that when click makes these buttons
visible, but when I open up my DB they automatically show on start up, is it
possible they not be visible till I click ckbHelp.......Thanks for any
Private Sub ckbHelp_Click()
If ckbHelp = True Then
cmbHelpNewHorse.Visible = True
cmbHelpActFinHorse.Visible = True
If ckbHelp = False Then
cmbHelpNewHorse.Visible = False
cmbHelpActFinHorse.Visible = False
In design view, set the property pf the *button* Visible=No
"Bob" <firstname.lastname@example.org> wrote i...Some contacts don't show on drop down box when addressing email
I was using Outlook Express, my computer motherboard died, got new
computer with Windows 7, trying to learn Outlook 2003.
The computer tech from my husband's office put Outlook 2003 on the new
computer and somehow transferred the addresses that I had in Outlook Express.
I do not know what method he used to get the addresses into Outlook 2003.
Some things carried over just fine, some things didn't, i.e. a group list of
my subdivision property owners, so I had to re-make that distribution list.
When I want to email my daughter, her name or email address is not s...Customized picklist fields are not showing up in the preview
can you please help me out in the following situation:
i have customized my crm 1.2 system in a huge manner. now all customized
picklists do not show up in the preview of e.g. opportunity. opening such a
related opportunity offers me the possibility to change the picklist field as
note: all built-in picklist fields are showing up in the preview...
Did you publish the customizations? And performed an IISReset?
After those actions your changes should be visible.
Hope this helps,
> hi,...Signatures not showing up in email
I have signtures setup and selected in Outlook 2003 and
format set to HTML yet they don't show up on the email
when I select new. Any ideas on what I'm missing?
Are you using Word as the editor? If yes, you must define a signature in
Word and then your other signatures will be available via the right click
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
KMW <email@example.com> asked:
| I have signtures setup and selected in Outlook 2003 an...Fractions showing up as decimals
I have a spreadsheet with columns of fractions, but when you select a cell
the function bar shows a decimal instead and when you save as text file it
saves as decimal instead of fraction. Could someone please tell me how to
make it show as a fraction in the function bar? I have tried formatting the
cell as fraction and it does not work that way
Formatting a number as a fraction like 1/2 or 1/5 is strictly for appearance on
The underlying value is still .5 or .2
The formula bar shows that number and when you save as text file, that is the
number that gets saved, n...Rich Text formatting in Access 2007
In Access 2007, is it possible to add rich text formatting to text in a memo
field (or mixed formatting within any text field). I have just upgraded to
the new version of Access, and it appears that this feature still has not
been added. Is this correct? (If so, why?) If it is not possible to format
individual words within a field in Access, , is there a simple, free add-in
that will enable Access to do this kind of basic formatting, such as adding
italic, bold, and underlining?
Thanks very much for any information you may have.
Rich Text format for Memos in:
Tables - Look in t...VBA Help in Access 2007
When looking through the Help engine, either local or online, I get blank
pages when I look at many detail pages in the Help file. For example, when
looking at most all web pages in ADO (Section I: ActiveX Data Objects (ADO),
there's one title line and no detail.
Is that planned behavior (no data) or is there some setting or site to find
information? I'm specifically looking for handling records in a table (read,
=?Utf-8?B?VGVycnk=?= <Terry@discussions.microsoft.com> wrote in
news:04199121-0746-4A15-B201-03F13827D29C@microso...Editing Password protected form fields in Word 2007
We have created a Word document with a legacy text form field. We inserted a
word date field and protected the document allowing Filling in Forms. After
protecting the document when we try going to the form field and clicking on
back space to delete the entry we get "This is not a valid selection" message
We have existing word documents in 2003 with similar form fields. We were
able to delete the entries and add new data. After converting the documents
to 2007 or create new documents in 2007 and try to delete the entries we get
the above error.
...Upgrading Excel with technical features for engineers, please
I would like to see much more technical features in excel. I am studying for
structural engineer and I make models with excel. But the program doesn't
have enough features to make good models, think about mechanics (and showing
its specifics graphs) and physics calculations which got to do with
So make us an "technical excel" for structural and hydraulic engineering
New students don't have mathematics anymore, the have to make models with
excel nowadays!!! ;)
This post is a suggestion for Microsoft, and Microsoft responds ...