how can i make grafs for role call?
...Can youp propagate changes to inserted text from file?
If you insert "text from file" in a document, but later make changes to the
source file, can the changes to the source file be propagated to the document
where you inserted the text?
If you insert a link to the source file. Otherwise no.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>>...Syntax error I can see the forest but not the trees
I'm having a problem I can't see the trees from the forest.
In the following SQL I added on the Job Sheet [Customer Name] and Me.
The SQL was working fine before the modification. It's proberbly very obvious
out there. I have been looking but just can't see it. Help
SQLstrg = "INSERT INTO [Job Sheet] ([CustomerID],[Customer Name],[Start Date],
[Notes])" & "VALUES(" & Me.[cboCustomer] & ", #" Me.[txtcompanyname] & "# ,"
& Chr(34)& Me.[txtDate] & "# ," & Chr(34) &...How can I dock a toolbar to the rigth?
When I dock a toolbar to the top side of its parent window it is
located to the left hand side by default (I explain what I say: the
left top corner). What should I do to dock this toolbar to the rigth
(right top corner)?
See DockControlBar() in the MSDN
a.. AFX_IDW_DOCKBAR_TOP Dock to the top side of the frame window.
b.. AFX_IDW_DOCKBAR_BOTTOM Dock to the bottom side of the frame window.
c.. AFX_IDW_DOCKBAR_LEFT Dock to the left side of the frame window.
d.. AFX_IDW_DOCKBAR_RIGHT Dock to the right side of the frame window.
"txemuki" <firstname.lastname@example.org> w...Can't connect a windows 7 computer
I have a brand new Dell server with SBS 2008. I have a brand new Dell
laptop running Windows 7 Pro. On the laptop I run http://connect and
go through the wizard until I press "Set up this computer for myself"
whereupon I get the message "The computer does not meet the maximum
operating system requirements for running client setup"
Any advice please
Many thanks - Anthony
Have you installed SBS2008 Rollup 3 on the server?
969121 Description of Windows Small Business Server 2008 Update Rollup 3
...I can recieve not send emails even though the test message works..
I can not get the email to leave the outbox even thought test messages work.
...Formula text count #2
I Have a list in a column that has a lot of tank numbers on a ship
listed as the following:
In another column, I have a list to identify whether the tank has been
opened noted with a date if it has and blank if it hasn't. I'm trying
to count the amount of V tanks that have been opened, J tanks that have
been opened and so on. I need an if, ifcount, or vlookup formula that
can do this. Any assistance would be greatly appreciated.
You can probably use a Pivot Table. Have it summarize the data in
column A and the column in wh...Is there a convenient way to save data
Is there a convenient way to save dialog data so it remembers the users last
selection? I have a dialog based application that only has three user
variables all of which are ints. What is the best way to make theses
variables persistent for a given user on a given machine?
"Jeff B" <email@example.com> wrote in message
> Is there a convenient way to save dialog data so it remembers the users
> selection? I have a dialog based application that only has three user
> variables all of which are ints. What is the best w...How can I open a worksheet to a specific cell?
I have a public worksheet and people update as needed and just hit save,
and the next user opens to the cell where it was last saved. How can I
have the wooksheet save in any cell, and open in A1 the next time it is
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Put this in the ThisWorkbook code module (right-click on the
workbook title bar, choose View Code, paste the following in the
window that opens, then click the XL icon on the toolbar t...What's the best way to find out if user is currently using mailbox ?
on Exch2000Sp3, I go to Systems Manager and I see
mydomain\certain user mailbox.
Last logoff time = blank.
As an example, I compare my logoff information:
my Outlook is currently opened but my logoff time = 10/07/04, 9:00AM
Are those info reliable indicators of current mailbox activity ? Please
If policy allows, examine the sent items folder.
MVP for Microsoft Exchange Server
"Marlon Brown" <firstname.lastname@example.org> wrote in message
> on Exch2000Sp...can anyone help with this error? #2
Date: Mon, 6 Feb 2006 21:52:59 -0600
Reporting-MTA: dns; corp.2tsi.com
Received-From-MTA: dns; localhost
Arrival-Date: Mon, 6 Feb 2006 21:52:53 -0600
Final-Recipient: rfc822; email@example.com
Remote-MTA: dns; smtp-relay.2tsi.com
554 <firstname.lastname@example.org>: Recipient address rejected: Access denied
I think user haven't rights to send messages through SMTP Connector
"Greg Siegel" wrote:
> Date: Mon, 6 Feb 2006 21:52:59 -0600
> Reporting-MTA: dns; corp....Can I add 2ft 7in plus 5ft 8in and get 8ft 3in as an an...
How can I enter and format the data in feet and inches and get an answer in
the same units (without pre-converting everything to inches?)
When I add the data, I do not want the answer in decimals. Just feet and
If you have your measurements formatted such that feet
are in column A and inches are in column B, then try:
Simply enter the numbers in col. A and B without adding '
This formula assumes that the numbers in col. B are whole
numbers...can you tell me the difference between excel 2000 and excel 2003
can you tell me the difference between excel 2000 and excel 2003
Search the Microsoft Knowledge base for new features in XP and in 2003
for more complete information.
The biggest difference that I have noticed on a daily basis is auto
recovery. If there is a crash, Excel XP and 2003 will attempt to allow
you to recover the workbook that you were working on.
If you do probability, statistics, or simulations, then many algorithms
are greatly improved.
You have more flexibility in what you protect on a worksheet (for
instance, you can protect formulas...Why can't I find my posted questions???
Thank you for your help. FMW
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
...Non-inventory item (Can we limit access to who can use this?)
Can you limit by access level on who can ring items up as a
non-inventory item where you have to put in your own price? I want to
be able to only let managers access that.
Also, how can you bring up a report and have in the description field
for the non-inventory item, what you wrote in there when you rang the
person up? For instance we have item "000" as the non-inventory item
code... the cashier uses this for now for items not in the new system
and can edit the description and price at the time of purchase. When
I try a sales report to see what was sold in a given period...thes...How can I stop my 'tab' key from jumping multiple columns in Exce.
For some reason I skip about 10 columns when I press my tab key. It used to
be where it only scrolled over 1 column. Does anyone know how to fix this?
Uncheck "transition navigation keys" and the two boxes below also unless you
want Lotus emulation.
Gord Dibben Excel MVP
On Tue, 12 Apr 2005 12:32:09 -0700, "Jesse" <Jesse@discussions.microsoft.com>
>For some reason I skip about 10 columns when I press my tab key. It used to
>be where it only scrolled over 1 column. Does anyone know how to fix this?
...Can't use Outlook2003 as admin
On a personal pc when logged in as admin cannot send or receive e-mail. But
when I go into another user (as user, not admin) I can send and receive
email. Any ideas?
> On a personal pc when logged in as admin cannot send or receive e-mail. But
> when I go into another user (as user, not admin) I can send and receive
> email. Any ideas?
Oh, "cannot send or receive". And that tells anyone else WHAT? How do YOU
know that e-mails don't get sent or received? Any error messages?
Since you are logging under a different Windows account, hav...Can you make a series 2 bar the same in the chart?
My manager has a spreadsheet that he wants to make into a bar or column
chart. I have done all of that and set it up. My problem is he wants the
second bar to be the same all the way across for each month. How do I make
each bar the same all the way across for each month? Do I have make a
separate column for the figure that I need to pull from the spreadsheet in
order for it to be the same for all the bars? I hope I am asking this
Yes, you should add another column of data and include that in the
plot. Though I am not sure of the visual effect of adding a 2nd bar
that is...How can I pull Word data into Excel?
I need to insert data from a table in a Word document into an excel
spreadsheet. The data in Word will be updated and I need those new numbers
to update either when the Word doc is saved or when the excel spreadsheet is
opened. Any ideas? I'm obviously not using the right words for help to know
what I want.
...Can't get rid of alternate row color
Howdy. I've got a number of subforms displaying in datasheet view. I want to
get rid of the alternate row color scheme. I've set both the back color and
alternate back color to the same value, but they still show in alternating
I changed the default alternate row color (through Access Options>Current
Database) to be the same as the row color. In a new form, all rows are the
same color. But forms created when the default back/alternate colors were
different still show alternate colors.
Is this a bug, or am I missing something?
Look f...can I work on Publisher docs on Mac OS X
I have a need to amend MS Publisher docs I receive on a Mac OS X computer. Is
there anyway this can be achieved?
Phil.T <PhilT@discussions.microsoft.com> was very recently heard to
> I have a need to amend MS Publisher docs I receive on a Mac OS X
> computer. Is there anyway this can be achieved?
A suggestion I have heard:
Export your Publisher file as an MHT file.
Open them in Word 2004 on the Mac.
Then to go in the other direction, save as a web page, and reopen in
If possible, though, I would recommend opening them in Publisher running
under Virtual PC ...Help, I can't resize chart legends on my axes or titles
I only have this problem on this machine. Things work fine on all others
Running Office 2003 (SP2) on XP Pro (SP2) on an Inspiron 9300.
When I enter text into chart legends, it gets clipped and when I click on
the frame, Excel won't let me drag the frame wider. What could be causing
If I copy the file to another computer and reopen, it's fine, everything
works, but if I copy it back the problem immediately returns.
I've run the update for Excel, I've updated my video drivers, nothing works.
My apologies for taking up anyone's time. This problem has apparent...Dividing a problem into parts and can't get the parts back togethe
I have three tables in a Master/Detail/Detail relationship. They are titled
Label / Product / ProductPart. One Label can have one or more Products and
each Product can have one or more ProductParts.
The ProductParts have two attributes: Category and Application Number
(productpart_category, productpart_app_no). Usually (95% of the time), the
Category and Appliction Number is the same for all the ProductParts for a
given Label. This makes it easy to return a result table (after a search of
the 20,000 labels) like this:
Label Id | Label Name (taken from Label table) | Category ...Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
I am new here and have been snooping around some of the threads, yet
not quite found the simple formula I expect to solve my problem. The
closest matches seemed to advanced for my need, so I reckon and hope
this will be an easy one for the more experienced members.
What I'm looking for is a formula that will:
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a column with similar
conditions in the next column.
Say A2:A21 contains 9 "0"s and the remaining 11 are "1"s, of which only
5 (the "1"s) appear on the same ...Can Excel startup Word?
Since Excel and Word seem to be part of the same
MS-Office software set, I assume that Excel can
easily be used to open Word??? Just wondering
if I can automate Word from the Excel application
in any way.
Yo can do it this way:
Dim oWord As Object
Dim oDoc As Object
Set oWord = CreateObject("Word.Application")
oWord.Visible = True
„Robert Crandal” ezt írta:
> Since Excel and Word seem to be part of the same
> MS-Office software set, I assume that Excel c...