using named cells across worksheets
I've named various cells after producing a multi-worksheet model. The named
cells can be applied in the worksheet they are in but I can't see how to
apply them across other worksheets. At the moment, the only option I can
think of is manually updating every formula in all the connected worksheets!
You defined the names so that the names included the worksheet name, too?
Then you can just use them by making sure you include the complete name:
Is that what you meant???
Nick Malon...Using xsd.exe tool
When I used the xsd.exe tool to generate C# classes from schemas, I
discovered that the automatically generated codes have no difference
when the attribute
contraint is set to "default" or "fixed".
<xs:attribute name="country" type="xs:NMTOKEN" default="US"/>
<xs:attribute name="country" type="xs:NMTOKEN" fixed="US"/>
//both have C# codes
[System.ComponentModel.DefaultValueAttribute(...Unable to log into my Outlook mail
I can log into my win2k domain, but when I open my
outlook I get prompted for username, password,and domain.
When I enter the correct info, the system replies that
it's incorrect. I have tried changing passwords and many
other fixes, including uninstalling and reinstalling
office and still can't get it to work. I can log into
outlook and my account from a different computer, but not
from mine. Scanned my computer with Norton NAV. On the
client side, using Outlook 2002, with winXP sp1, office
2002 sp1 & 2. On the server side, using echange 2000 with
sp 3, windows 2000 ser...Online Log Size
I've got a 40G SS 2005 table without indexes that I need to add a clustered
index to. I know that if I do a standard index addition, it will write out
about 40G to the log and I was hoping to avoid that. If do the ONLINE option
for building this clustered index, will it write out significantly less to
the log by any chance?
Nope - but, you can try changing the recovery model to BULK-LOGGED and
seeing if that reduces the amount of data recorded in the transaction log.
Remember to change the recovery model back to full after the index has been
Note: the transact...Is it possible to use a switchboard/form to open a form from another database?
I want to add a button to my switchboard that opens a form in another
database. Is it possible to do this and if so how, as the button wizard
only seems to enable actions within the same database.
Thanks for any help.
...Import text file using a wildcard
I am running the following code to import all text files that all start with
the same 12 characters:
' Set the parameters to import the text file
If Right(Me!txtFilePath, 1) = "\" Then
strPath = \\mdb8\Global
strPath = \\mdb8\Global& "\"
strFileName = "GlobalImport*.txt"
If FileExists(strPath & strFileName) = False Then
msgbox "File " & strPath & strFileName & " Does not exist!",
vbCritical + vbOKOnly, "No File..."
GoTo ExitImpor...OWA HTTP Error 500.13 Server Busy
We've been getting error 500.13 Server Busy on our Exchange Server since
Friday night. Nothing changed in our setup (Windows 2003 Exchange 2003). We
don't have any restrictions set in IIS to limit the number of connections.
I'm not sure what's causing this.
Email is working properly from Outlook 2003, we just cannot connect from
OWA. Any advice would be greatly appreciated.
Can circular logging in Exchange 2003 really free up 20 GB
of hard disk space? I enabled it and I was amazed to see
my free space five-fold.
yip, not necessarily 20mb but just make sure u backup the transaction logs,
u will need when u do a restore of your database.
"Josh" <Josh@puzzled.com> wrote in message
> Can circular logging in Exchange 2003 really free up 20 GB
> of hard disk space? I enabled it and I was amazed to see
> my free space five-fold.
> Can circular logging in Exchange 2003 r...How to use trial version
I just downloaded an Excel trial. Why can I not enter data in the cells? Is
the trial version just to show me how pretty the program is, or can I
actually try it out? Whats wrong here, am I being stupid?
Yes I was....
I didn't register it...oops
....haste makes mistakes
...Programatically using zoom vs Setting zoom level
Using IE 7 & 8, I need to supply buttons on a page to allow the user to zoom
in or out (I know they could simply user the browser to do this but.........
it’s a long story!!) Experimenting with ways to achieve this, I am having
difficulty achieving the same level of functionality when programmatically
applying a zoom as appears available using the browser menu.
On the very basic webpage below, if I use ctrl (+/-) to zoom the page, the
page content is resized correctly and everything if fine; However, if I apply
a zoom level by setting the .style.zoom property programmatically...could i use use multi row bitmap ?
there's a treecontrol in my app, every item in the tree needs a 16*16
i wanna create 32*32 bitmap, so it could contain 4 icons, seems i could
use the second row icons after i have given a shoot.
> there's a treecontrol in my app, every item in the tree needs a 16*16
> i wanna create 32*32 bitmap, so it could contain 4 icons, seems i could
> use the second row icons after i have given a shoot.
I dont think you can do this. It will screw up the hit testing of the
...log events in the event log
I want to be able to track when a user connects to their mailbox. I have
someone who is trying to connect to other mailboxes and I want this to be log
in the event log. I would like to show the user name and the mailbox they
tried to connect to in the same event. Is there a way to do this?
Thanks in advance for your help...
Question for you...Does this person who is attempting to connect to the
mailboxes have full exchange administrator rights on the Exchange Org? If
so, you may want to refer to a previous post as this same question was asked
and then answered.
"faf19...Selecting cells using shortcut keys not mouse
I am working on a project which does not allow the use of a mouse.
I need to select non-adjacent cells using keyboard only.
This would be the equivalent to selecting cells with the left button whilst
holding down CTRL.
Does anyone know how this can be done?
"Griff" <firstname.lastname@example.org> wrote in message
> This would be the equivalent to selecting cells with the left button
> holding down CTRL.
> Does anyone know how this can be done?
You can press F5 ; then type
C1,E1,A1...Exchange 5.5 size-constraint-violation
Hi to all.
We have a strange problem with our exchange system (5.5 SP4).
In our site we have 4 mailboxservers (3500 users) and one bridgehead server.
Since the rollout from Office 2003/Outlook 2003 we got ndr's with id 290.
In the logs i see the following event:
"A non delivery roport (reason code transfer-failure and diagnostic code
size-constraint-violation) is being generated ... and was redirected ..."
No one get's the ndr and the mail is lost.
If the sender send's the mail a 2nd or 3 rd time the mail arrives.
If i move the sender and the recipient to the same ex...Why can't I select/use items from master page in publication pages
I created text boxes in a master page and when I go to the publication pages,
I can't select any of the objects I created in the master page. It's as if
they are locked. What's up with that? It's driving me bananas!!!!
They are two seperate pages. You have to have the master page selected to
make any alterations to it.
"joyojoy" <email@example.com> wrote in message
>I created text boxes in a master page and when I go to the publication
> I can't select any of ...Diagnostics Logging
Some email to some domains can't be delivered
showing as "The connection was dropped by the remote host"
What type of logging should I enable to troubleshoot this?
also, where does it log too be default?
"James" <firstname.lastname@example.org> wrote in message
> Some email to some domains can't be delivered
> showing as "The connection was dropped by the remote host"
> What type of logging should I enable to troubleshoot this?
I am running a Windows 2000 Server (SP4) with Exchange
2003 on it. Whenever I log in through Outlook Web
Access, and click on a hyperlink in a message, it asks me
for authentication before allowing the link to open the
new page. Only an administrator can successfully
authenticate, and activate the link. Can anyone help??
>I am running a Windows 2000 Server (SP4) with Exchange
>2003 on it. Whenever I log in through Outlook Web
>Access, and click on a hyperlink in a message, it asks
>for authentication before allowing the link to open ...Change password OWA 2003
I am trying to enable the change password feature in OWA 2003. I have edited the registry so the button is available within OWA and SSL is enabled. I can do everything within OWA except change my password.
I've used the script from the following webpage to create the Virtual Directory with the appropriate permissions. http://www.e2ksecurity.com/archives/000424.html
Everything is setup, however I still get the "Page can not be displayed"
I have also reviewed the articles below
http://support.microsoft.com/default...Problem with log in to Vista
I've got a problem with my Vista (Home Premium)
I tried to log in in the morning and this problem occured - all of my desktop icons (same goes to wallpaper) vanished, my Windows taskbar won't open and I can only browse my computer through one explorer window that popped out during a log in (I can browse all the areas/hdd's of my pc)
I scanned my OS with AVG antivir but the problem still occurs.
It's been 8 months since I install the system (and i've got all the updates) and I never had a problem like this before.
What is it? Is it a virus or any other piece of m...creating a log sheet
I've created a method to capture current user (network username) and a date
/ time stamp. I want this output to be logged on a hidden sheet called
'log' strangely enough! How does it find the next available line in log to
see if this will help you. you didn't give too specific of a description, so
hopefully this is what you're looking for
lastRow = Worksheets("log").Cells(Rows.Count, "A").End(xlUp).Row
range("A: & lastrow +1) = "your date/time stamp code"
"sacrum" <sacrum...exchange 5.5 backup
if i am using windows 2000 server with exchange 5.5 do i
need to stop the the services before i take the backup ?
No you don't.
If you run the NTBACKUP app (start > Progs > Accessories
> System Tools > Backup) you will see the Exchange appear
as an additional section at the bottom of your backup
If you don't have the tape drive or the desire to back up
from the actual server itself you can run the Exchange
setup and install only the Administration Components onto
any machine with a tape or space to store the backup. You
will then (with the rig...How to log internet header of incoming emails?
I want to log internet header of incoming emails. I want to see the content
of the Bcc field. Is it possible? And if yes, how and where I have to config
the log settings in exchange server? We use exchange 2000.
You can create a rudimentary log of incoming mail using the SMTP protocol
logging feature of the SMTP virtual server. It will not record the BCC
field or any of the message content, though. The BCC field would be inside
the RFC 2822 header of the message. To record anything in that you would
need an SMTP protocol sink.
The Archive sink mig...OWA, log in to .. log out?
1 FE server
no forms based auth here(yet)
This weekend I put a FE server out and put a SSL cerfiticate on it. The
name in the certificate is not the same as the server, however our internet
facing DNS has an A record for it with the name that is used in the
certificate. after the migration I have a small number of users, about 10
out of 1000 that when using OWA get asked to enter credentials when they
click "log off". why?
Also, because i think its maybe related.
This FE server is physically inside our network behind a pix. One thing I
wanted to achieve but...using send to with outlook with multiple accounts
When I create a word document and try to send it as an
attachment using the send to command it ignores my choice
of email accounts. I click on the internet account and it
sent it using my exchange account.
Are you by chance using Outlook 98 or 2000? If so, you're almost
certainly configured in Corporate/Workgroup mode because you're using
Exchange, and in CW mode, the account at the top of the list in Tools |
Services | Delivery is always the account used to send a message. You'd
have to move a different account to the top to send through that
account, and even then, Exchange...How to find out if a user has logged on ?
Within a Windows Service, is there a way to find out if a user (any user)
has already logged on to the machine ?
Thanks In Advance !
You can use NetWkstaGetInfo with a level of 102 to get the number of logged
And NetWkstaUserGetInfo will give you information about the logged in user.
"Polaris" <email@example.com> wrote in message
> Within a Windows Service, is there a way to find out if a user (any user)
> has already logged on to the machine ?
> Thanks In Advanc...