Set User security depending on a selected Company
Is there some way to assign different rights to one user depends on the logon
company, encapsulating the permissions in a user class?.
This is a multi-part message in MIME format.
I think you can do it using the advanced security window.
You just have to select only one company set the rights for the user =
class, then do it again with another company selected.
"Ellery E Gomez" <ElleryEGomez@discussions.microsoft.com> wro...selecting from multiple OR statements
Any idea why this query returns ALL the rows:
select * into #temp2
substring(Firstname, 2,1) <> ''
substring(Firstname, 2,1) <> '.'
substring(Firstname, 3,1) <> ','
substring(Firstname, 3,1) <> '.'
substring(LastName, 2,1) <> ''
substring(LastName, 2,1) <> '.'
substring(LastName, 3,1) <> ','
substring(LastName, 3,1) <> '.'
*I think it'...How do I unlock FILE access?
This morning, at work, I was using Excel to track data on trucks at work.
During break, I opened another Excel document to view. Shortly after the
second Excel document was opened, another truck came in. When I tried to go
back to the spreadsheet file to record the info for the truck that came in,
Excel went idle for 30 seconds, then came back with a READ ERROR saying it
had tried reading a memory address that was un-readable. When I clicked OK
on the read error message box, Excel SHUT DOWN COMPLETELY...
When I RE-started Excel, and tried loading the truck info file that was
suppos...Merging Documents in Publisher
I have several documents that have been created with the same template,
however each document has a different color scheme that is being used for
that template. Is there a way to merge these documents together for printing
purposes so that they are all in one concise place but they retain their
individual color scheme? Currently when I attempted to merge the documents
they would take on the original documents color scheme.
Any help would be greatly appreciated!
THe biggest problem that I am having is the Color Scheme. PLEASE HELP!
&...Axis not highlighting when viewing selections
When using Office 2003, we are experiencing a problem
with excel graphs. When viewing the source data, I
select a series. Then choose the X Values, it WILL show
the selected values. I then close out of that which
takes me back to the Source data, I then choose the Y
Values. This does NOT show the selected values. I tried
going directly to the Y Values first on another series,
and it appears that whichever axis is selected first will
show, the second will not. This is a major hassle when
you are dealing with complicated graphs that contain many
many rows and several diff...Removing Word from Spell Check Dictionary
I am running Windows Vista, Windows Mail and Home & Student 2007.
I accidently clicked on "Add" for a misspelled word when running spell check
in a Windows Mail message. Is there anyway I can get this word out of the
Sure. Locate the custom.dic and open it in notepad. The spell check dialog
(misspell a word and press F7 to invoke it) will have a link to the
custom.dic - either under Options or a direct link.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/...select e-mail account for sending message
I am using Outlook 2007 and 3 e-mail accounts. Is there a way to get
Outlook to prompt for which account I want to use to send a message?
BBran <email@example.com> wrote:
> I am using Outlook 2007 and 3 e-mail accounts. Is there a way to get
> Outlook to prompt for which account I want to use to send a message?
Isn't it more efficient simply to choose it with the Accounts button?
Or assign a searate signature for each account and make one the default?
Milly Staples [MVP - Outlook]
Post all replies to the group to ke...unlock cells become lock cells after pasteing
My worksheet is protected and I have several cells that
are unlocked. I copy some cell value from YAHOO financial
web page to paste into my cells. After the paste my cells
are locked and cannot be changed without having to
unprotect and unlocking and reprotecting. Is this a excel
bug? Is there a way so it doesn't lock my cells on pasting?
"rick kerlin" <firstname.lastname@example.org> wrote in message
> My worksheet is protected and I have several cells that
> are unlocked. I copy some cell value from YAHOO financial
> we...How do I select what movie viewer in attachments
Hello. I would like to be able to select what program like windows media
player or nero player to use when opening my attachments in outlook 2003,
Were do I go to find it. Many Thanks. Terry.
Terry Horton <TerryHorton@discussions.microsoft.com> typed:
> Hello. I would like to be able to select what program like windows
> media player or nero player to use when opening my attachments in
> outlook 2003, Were do I go to find it. Many Thanks. Terry.
Outlook uses whatever is set up as a Windows file association....this i...Selecting and summing across worksheets
I know how to click and drag across cells as a means of viewing a
accumulating total at the bottom of the screen.
But how do I do this across worksheets in order to see an accumulating total
by selecting cells across worksheets.
I don't think you can do that using the feature in the status bar, but you
could make a summary sheet:
"JMS" <JMS@discussions.microsoft.com> wrote in message
news:01378684-633C-495B-BEC8-5F727A...New to Visio
I noticed that we cannot use the CTRL key in Visio to select non-adjacent
items. Is there another way to do this?
On Fri, 13 Apr 2007 07:16:03 -0700, Helen
>I noticed that we cannot use the CTRL key in Visio to select non-adjacent
>items. Is there another way to do this?
Yes, you can. Just hold the Ctrl key and click the shapes you want.
The selected shapes will have a purple outline and there will be
another purple outline showing the full extent of the selection.
Regards, Paul Herber, Sandrila Ltd.
if you want unlock iphone, all version, 1.1.1 to iPhone 3G + 2.0 , today you
can for 9 euros!! Go on http://www.fastunlockiphone.com or
In article <uvcJBydGJHA.4408@TK2MSFTNGP04.phx.gbl>
"yui" <email@example.com> wrote:
> Hi friends,
> if you want unlock iphone, all version, 1.1.1 to iPhone 3G + 2.0 , today you
> can for 9 euros!! Go on http://www..com or
...extract info FROM word INTO excel
how can I take information FROM ms-word documents INTO excel? thanks -
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
You can copy text from Word, and paste it into Excel. If you're trying
to do something more complicated, you'll need to provide some details.
> how can I take information FROM ms-word documents INTO excel? thanks -
> ...How to create the customized Outlook SQL DASL for selected days?
Outlook 2007/2010 provided pre-defined view for tasks due by the selected
days. It seems the SQL DASL Filter dialog has the ability to do it, but I
don't know what's the property tag for selected days
I am using the filter below to get tasks due on today.
When I changed the selected days on the calendar taskpad view, it won't get
the tasks due on the date I selected. Can't find any documents to use SQL
DASL filters except for Andre Delin's weblog: Doing mor...unlocking workbooks
I have thousands of excel file which workbooks are protected
I know the password
somebody told me visual basic was the easiest way to unlock protecte
I don't know VB
Can somebody provide me a vb code in order to unlock those files?
Thanks to al
guilhaume's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1200
View this thread: http://www.excelforum.com/showthread.php?threadid=27833
What type of protection?
tools|protection|...Select MaxDate from xml
How can I select node from xml where the value is the max? Like "Select *
From table0 where date = (select max(date) from table0)". i don't use any DB
Server just xml and dataset.
<text>text2</text&...Word count and language settings #2
Is there any way you can change the language setting for a whole document
e.g. many text boxes at the same time.
Also, is there any way to count words in all text boxes in Publisher at the
same time. I know you can edit to Word, but this is box by box, so takes for
...Opening Word 08 documents in PC
When I emailed a Word for Mac 08 document with a .docx suffix to my office PC and tried to open it in Word, the document would not open. I tried changing the suffix to .doc, but that was denied also.
> When I emailed a Word for Mac 08 document with a .docx suffix to my office
> PC and tried to open it in Word, the document would not open. I tried
> changing the suffix to .doc, but that was denied also.
You need to give more details. When you say you changed the extension
to .doc, do you mean you renamed it from your office PC or you did a Save
As on ...Excel Hyperlink Management, Functions, and MS Word
Is there a text function that returns a specified range within a cell
for instance given the below conditions, i'd like a1 to return "yahoo"
(characeters 12 through 16 of cell b1) and have the hyperlink show up
a1 = ?
b1 = http://www.yahoo.com
c1 = hyperlink(b1,a1)
d1 = find("http://www.",b1)+11 returns 12
e1 = find(".com")-1 returns 16
Basically what i'm trying to do is organize my favorite links in excel
(Column C), and then move them to MS Word without having long urls
displayed on my word document. My procedure for d...windows xp, can not select multiple users in lusrmgr.msc
Hello from Spain,
i was studying lusrmgr.msc, the console for the management of local users
and groups, for my mcdst certification when i realized i couldn't perform
the action of selecting some users with the shift key neither with the
control key. In the book they say it's possible... what am i doing wrong?
I'm working on a windows XP Pro 2002 service pack 3.
On Wed, 18 Aug 2010 20:35:58 +0200, "m0rg4n" <firstname.lastname@example.org>
>Hello from Spain,
>i was studying lusrmgr.msc, the console for the management of loc...Numbers to words
Years ago (in FoxPro) I remember there was code for writing out in words the
amount of a currency field -- like on a check. ie. $25.00 would appear as
"Twenty five dollars." I've developed a receipt that needs that kind of
thing. If anyone can point me in the right direction I'd appreciate it.
Posted via a free Usenet account from http://www.teranews.com
On Sun, 24 Jun 2007 18:11:58 -0700, "Dave Eliot" <email@example.com> wrote:
>Years ago (in FoxPro) I remember there was code for writing out in words the
>amount of a currency ...Selecting ICONS for Macros in Excel 2007
Once you have customized the QUICK ACCESS TOOLBAR by adding icons to run
various macros, is there a way that you can replace the icb=ons with your own
icons? If yes! How?
Have a read of Ron de Bruin's page on the subject.
Andy Pope, Microsoft MVP - Excel
"pcor" <firstname.lastname@example.org> wrote in message
> Once you have customized the QUICK ACCESS TOOLBAR by adding icons to run
> various macros, is there a ...Outlook 2003 cached mode; selected folders only
When cached mode is enabled, it appears Outlook 2003
still syncs all folders, regardless of what is selected
in the Options/Setup/Send&Recieve/Group. Does anyone
know of a way to let the selected folders option dictate
what is synched in cached mode?
We have a number of users with large mailboxes who could
benefit from cached mode, but also are particular about
which folders are synchronized for offline use. They
would like the same folders not synchronized in cached
mode as they were in online/offline setup.
Thanks in advance!
...How do I unlock a document?
When I open Windows I can't type anything. I can't open a new document,
because it tells me that the document is locked.
This is an Excel news group.
If you can't type in Windows, you should visit a Windows news group.
If you're talking about Excel, please post back with a better explanation and
description of your problem and what you are trying to do.
Gord Dibben Excel MVP
On Tue, 30 Nov 2004 13:05:04 -0800, "babyjjl"
>When I open Windows I can't type anything. I can't open a new document,
>b...Adding a Cripped Microsoft Word Doc to another Microsoft Word Doc
I am trying to take a word doc that is cripped small and add to another word
doc as a picture (add on).
Thanks for your help.
I assume you mean "cropped" but you can't crop a Word document. How did you
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Carolyn" <Carolyn@discussions.microsoft.com> wrote in message
>I am trying to take a word doc that is cripped small and add to another
> doc as a pi...