Cela fait lontemps que je n'ai pas retoucher au option avancer d'excel
et au vb. De plus ma soci=E9t=E9 =E9tant pass=E9 sous 2007 j'ai perdu tous =
rep=E8res. Enfin apr=E8s un tour sur le forum et excel labo j'ai retrouv=E9
mes outil formulaire de la versions 2003 avec l'onglet develloppeur
mais je n'arrive pas =E0 me souvenir comment on cr=E9er la frame sous
excel qui permet d'ajouter dessus des bouton, checkbox... ( c'est
comme l'outil formulaire sous access)
j'esp=E8re que j'ai =E9t=E9 clair et vous remercie par avance de votre aide=...Excel Formula #6
Is there a way to set a formula to calculate how many rows
above (COUNT) with no text or numbers in the column?
"deniseS" <email@example.com> wrote in message
> Is there a way to set a formula to calculate how many rows
> above (COUNT) with no text or numbers in the column?
HTH. Best wishes Harald
Followup to newsgroup only please.
"deniseS" <firstname.lastname@example.org> wrote in message
news:15...How do I reject file types
I would like to reject file types, can someone tell me where or how to do this?
The best way to deal with it would be to get Exchange antivirus software,
which you should be running anyway...it can do this and more. Favorites are
Trend ScanMail or Sybari Antigen...other products tend to generate lots of
For a list of attachment types to block, might want to see
B Tompkins wrote:
> I would like to reject file types, can someone tell me where or how
> to do this?
Thx, I have McAfee Orchestrator now,...Can Drop Down Boxes jump to the answer as you type?
If I create a form with VBA, to create a drop down box to have a list to pick
an answer for to fill in a cell in a worksheet, it will jump to the answer in
the list as you type. Can a Data|Validation|List do the same thing? If not,
is there a way to get that functionality in Excel?
Data Validation doesn't support autocomplete.
If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:
rrucksda...Do I need DSClient to run Exchange 5.5 on an NT4.0 box in Windows 2003 Native Mode ADS?
I am in the process of migrating my WinNT4.0 domain and Exchange 5.5
Org to Windows 2003 ADS/Exchange 2003. I know best practice is to
change the domain to Native mode, but how does this affect my NT4.0
server running 5.5? Do I need to simply load the DSClient onto the
I should also note that we did an inplace upgrade from NT 4.0. This is
a single domain environment.
As long as you no longer have NT 4.0 BDCs you should be able to move to
native mode. Your NT 4.0 server running E55 will not be affected (unless of
course it is also a BDC).
It is a good idea to...Exchange 5.5 MTA Event-ID 290 after site removal
hopefully someone can help me.
We have Exchange 5.5 Org (most SP4) – 1 hub site and 5 spoke sites.
In our hub site we have 1 connector server and one mailbox server.
Due to Exchange server consolidation, I removed one site (KB324340) – same
procedure as I did it three times before -
Now I’m getting every 4 hours on the bridgehead server in the hub site the
following event-id, which points to the old and removed server/site:
MTA Event-ID 290 – NDR,..
A non-delivery report (reason code unable-to-transfer and diagnostic code
unrecognised-OR-name)) is being generated for message message. ...Data Validation problem #5
hi I think that is a different solution entirely - in that example yo
gave me it is a simple case of choosing one list and that then sets th
range for list 2, however the second set of lists are all individual
my requirement is that the validation picks the required items out o
just ONE list, whereas in the example you needed to maintain individua
lists each of which was dependant on the first selection
moosifer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1590
View this threa..."Optional" output of a Public Type record
I have subs and functions that take in and update public type records.
No problem when: Sub Name(InRec As uTypaA, more args.....
Is there a way to optionally write a public type ?
VBA won't allow: Sub Name(Arg1, Arg2, optional uRec As uType = ???
I guess since there's no constant value to assign to the fields.
I get the late bound error msg when I tried this:
Sub Name(prior args....., optional uRec as variant = "")
Dim uWantRec As KnownType
uRec = uWantRec
I can guess VBA must know the Type to initialize the fields....Exchange 5.5 in Windows 2000 Domain
HI I am looking for any advise I can get on this subject, or any references
you may have.
Basically I have an NT4 PDC that currently has Exchange 5.5 installed on it.
I have a windows 2000 Database server that is just a member server of hte
My NT4 machine is running out of space, so I am getting a new server for
exchange. I will install Windows 2000 on this server and then follow the Ed
Crowley Server Move method, to move my exchange server over to this new
I am comfortable with this. I have just now installed an NT4 BDC into the
domain (it is only a very old machine so it ...Import Messages from Outlook Express 6
I would like some advice on importing messages that are
currently on a Win98se machine running OE 6 into an XP
Pro machine running Outlook 2003,
Thanks, any help greatly appriciated,
<email@example.com> wrote in message
> I would like some advice on importing messages that are
> currently on a Win98se machine running OE 6 into an XP
> Pro machine running Outlook 2003,
> Thanks, any help greatly appriciated,
Go here to backup your old OE:
http://insideoe.tomsterdam.com/backup/index.htm...Printing business cards #6
I am trying to design and print cards for my business. I
have the card designed, but I am confused by crop/bleed
marks. The blue lines that intersect inside of Publisher
do not seem to be the same lines that print when I print
the card. How do I know how much room to leave around
the edges (or "margins"). I do not know how much space
is usable. Any help is appreciated.
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from steve <firstname.lastname@example.org>...
> I am trying to design and print cards for my business. I
> have the ...Landed Cost #5
I am trying to implement Landed cost and when the added cost is added on
through the system the it will not take the added cost of landed cost to the
account specified by the accrued purchase price account but sending it to the
variance purchase price unrealized that is specefied under the actual item.
is there any easy answer for this?
I would like to update the post in simpler terms it will use the accrued
purchases account indicated in Landed cost maintenance but it is not using
the account specified by the purchase price variance account specified in
landed cost maintenance. It i...double display in the Watch view with VC++6 sp6
Since the install of Visual Studio service pack 6 the double display
in the Watch window of example before (with vc++ sp5) -7701.7701 give
in the window -7701.7701 now (with the sp6) in obtain -7701.7700999999997
Why is this an issue? It strikes me as a bit of concern over an irrelevancy. Floating
point isn't accurate anyway, so there is no particular reason to be concerned about
trivial differences like this.
On Wed, 30 Jun 2004 09:39:11 +0200, "Olivier" <email@example.com> wrote:
>Since the install of Visual Studio service ...Need RULE to search for Text in Body with varying # of spaces
I have Outlook 2002 and have been using the outlook rule condition:
"With specific words in the body"
However the "Specific words" I'm looking for might contain varying number of
"some text: some more text"
"some text: some more text"
Is there a wildcard or something to match multiple spaces?
--Thanks very much,
Kenneth Parker <firstname.lastname@example.org> wrote:
> I have Outlook 2002 and have been using the outlook rule condition:
> "With specific words in the body"
> However...Duplicate emails on exchange server 5.5
Im using w2k server sp4, and exchange server 5.5 witn sp4 also Im suprised that some of the users are receiving duplicate emails local and internet and it is continously increasing and annoying to the user that they received the same kind of emails despite the fact that they read already. What seems to be the problem. Thank you very much in advance for your help.
>>receiving duplicate emails local and internet
local and internet? Are they different messages?
Is the user a member of a distribution list and are the messages sent to
the DL and the user?
> Im...Event 9646
E2K3 SP1; Mixed Mode
I received a few of these in my Application Log on the E2K3 server, but I
cannot find any information regarding them:
Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 9646
Time: 10:30:51 AM
Mapi session "/o=Org/ou=Site/cn=Recipients/cn=RMonti" exceeded the maximum
of 32 objects of type "session".
The MS KB Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;830836&sd=ee has the
same Event ID, but does not reference the object of type "session&...Barra de Publicidade que =?ISO-8859-1?Q?d=E1?= dinheiritos !!! #4
Se queres ganhar uns Euritos s� tens de instalar esta barra de publicidade, que podes at� minimizar ou fechar em caso de utilizar programas de ecr� completo.
N�o incomoda nada, nem consome recursos. Apenas d� dinheiro, �ptima para quando deixas o comptdor a sacar a noite toda...
Recebes o dinheiro na tua conta PayPal.
If you want to earn money just by sitting in front of your PC, just install this Bar that shows some publicity now and then.
100% safe, no malicious ware.
http://www.eurobarre.com...Check Boxes #6
Is there an "easy" way to add check boxes to a worksheet? As it stands, I
have to manually attach it to the underlying cell, and adjust the size. I
would like to add several hundred checkboxes. Am I doing somethig wrong, or
is it just that akward and labor intensive in Excel?
Public Sub Tester01()
Dim SH As Worksheet
Dim rng As Range
Dim rCell As Range
Set SH = ActiveSheet '<<==== CHANGE
Set rng = SH.Range("A1:A100") '<<==== CHANGE
Can anyone point me to an online 4.5 manual. My network administrator
has suggested that attachments which are sent me and are being blocked
by GS 4.5 is quite difficult to have a script/permissions written
which will allow the attachments to get through. Thanks for any
I've got the manuals on PDF... I'll e-mail them to you.
From what I remember it's very much a case that you either
block the file type for all users or you don't...
For Exchange news, links and tips, check:
>-----Original M...Outlook client bandwidth to remote exch5.5 server
We are using exchange 5.5 and are going to get some clinets access the
server through our WAN links. They are going to use outllook 2000 and are
going to access the exchange server like if it was local. We have a huge
bandwidth pipe to our exchange server but I just want to how much bandwidth
would for example 60 clients take if they were accessing exchange 5.5
through the WAN link at the same time. Or for example how much bandwidth
would one outllook client take.
If you need to know more parameters please let me know.
On Tue, 16 Aug 2005 13:43:54 +0100, "gurvinder.nijjar"
<...MS POS 1.0 Install error...
Im using XP PRO SP2
..net 1.1 installed
MS SQLServer installed
When i try and install MS Point of Sale 1.0 , i get this error message at
the end of the install, when it says "Installing and configuring database"
System.ComponentModel.Win32Exception: The system cannot find the file
Microsoft.Rms.Installation.CustomActions.Utilities.OpenSqlPortInFirewall(String installPath, String portNumber, String& errorMessage...CRM 4.0 Terminal Services support
I have read through the CRM 4.0 planning guide and the "what's new in CRM
4.0" partner guide, and see very little mention of Terminal Services support
for the client Outlook 2003/2007 CRM Plugin. One example in the Planning
Guide page 4-63 shows a "Terminal Server, Microsoft Dynamics CRM for Outlook"
in "Domain B - Forest Y". There also appears to be a discrepancy between
these two guides in support for Windows 2000 SP4 - the what's new page 2-11
specifically says it is supported, and the planning guide page 3-29
specifically says it is not.
Is t...Exch 5.5 public folder duplication
We have created a Public folder of type Post. All users
can post and read from it. We use it as an items for sale
area. Sometimes, however, multiple entries of the same
entry appear, sometimes 2, 3 or 4 copies.
Anyone know what might be causing this?
...Exchange 5.5 standard hit 16gb limit!
Exchange server standard 5.5 hit 16gb limit. seems the admin account used for
internet connector service has about 2 million messages in it. Theres only a
gb or so left on the drive, I cannot delete that users mailbox. Im guessing
because its a logged operation and theres not enough diskspace for the log. I
dont have the mailbox cleanup wizard from sp3, what can be done? A defrag of
course wont work since it needs 10% additional (still wouldnt cleanup those 2
million messages!). So.. it comes up and a few minutes later goes down again.
How else can I get these messages removed with this...Mail-hosting
I'm tring to host mail for another company. Earlier there was a hosting
guide on ms' website, but now I can't find it. Does anyone know where this
info is to be found?
Please do not send email directly to this alias is for newsgroup purposes
This posting is provided "AS IS" with no warranties, and confers no rights.
"Eirik" <email@example.com> wrote in message