Data Validation Input Message Format
Good Evening All
With Data Validation, and having an 'Input Message',
is it possible to format this message, and resize the message pane?
Help awaly greatfully received.
The font size in the list can't be changed.
You can make the font appear larger if you increase the zoom setting
(manually, or through code).
See Debra's site for more information about Data-Validation
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"mpb1" <email@example.com> wrote in message news:...Get default browser NOT by the registry
I've been searching for a while for the "right" way to get the default
program for specific protocols and file types, namely http and https
protocols as well as the various htmlfile types. Everything that I come
across has to do with querying the HKCR section of the registry, but this
doesn't seem to be the right way of doing it. When I launch a URL on my
computer, Windows performs some action to determine what program should
handle that call. I assumed that there'd be an API call in Win32 or
elsewhere that I could use to determine this same ...Avoiding returning a 0 when no data in cell
I have worked out the formula I need to use (with help from someone
from this group).
However how do I stop it returning a 0 when no data is present in the
You may want to suppress the #n/a error, too:
> I have worked out the formula I need to use (with help from someone
> from this group).
> However how do I stop it returnin...Evalutation Software Error on Old data
When I attempt to open the manager connected to an old database (i.e.
a copy from a backup months or years ago.), I get an error saying the
evaluation copy of the software has expired, and the program shuts down.
Using version 1.3.1011
Yep, The DB is older than 45 days and therefore will not let you access it.
If you create a new DB you can use it.
"Greg Shepherd" <firstname.lastname@example.org> wrote in message
> When I attempt to open the manager connected to an old database (i.e.
>...Java script help please
I am trying to work with two dates on phone call entity in crm - actual
start and scheduledend
what i want to achieve is -
set the actual start date to current date if it is null and then
add 5 working days to actual start date
below is the code i am using
var CRM_FORM_TYPE_CREATE = 1;
var CRM_FORM_TYPE_UPDATE = 2;
crmForm.all.actualstart.DataValue == null
crmForm.all.actualstart.DataValue = new Date();
case CRM_FORM_TYPE...Password won't work
I believe I've read all the password problem posts but haven't found my
answer. My new computer is running Vista, I have loaded Money 2006 Deluxe
on, and when I try to open a backup file it asks for my password. I enter my
password and it will not accept it.
Please help - my life is in that file.
In microsoft.public.money, Slim in Mexico wrote:
>I believe I've read all the password problem posts but haven't found my
>answer. My new computer is running Vista, I have loaded Money 2006 Deluxe
>on, and when I try to open a backup file it ask...External website and Exchange server
Happy new year and thanks for reading my post !
This is going to be the very first time I have to install SBS2008
(Std), we have a peer to peer workgroup network and as we are moving to
a new office, I've decided to add a server to increase and enhance the
network performance and collaboration.
We have a couple of active domains, with website and email, hosted in
an external company. We'd like to use Exchange to centralize the emails
but we'd like to keep our websites hosted externally. Is it possible or
do we have to host our own websites in our SBS2008 se...How to get the registry data for all users
In my application, for each user some string is stored in
registry( under HKEY_CURRENT_USER).
This software is installed and uninstalled only by administrator.
While uninstalling, I want to remove the registry entries of all
users. Is there any way to access the HKEY_CURRENT_USER entries of all
other users while the application is run as admin ( so that i can
remove the entries).
> In my application, for each user some string is stored in
> registry( under HKEY_CURRENT_USER).
> This software is installed and uninstalled only by a...Help! External email not going out!
We run Small Business Serve 2000. We do not use smarthosts.
No outbound email is going out. Some of our users began receiving Delivery
Status Notification (Delay)'s. All they say are:
This is an automatically generated Delivery Status Notification.
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Then it gives the email address it failed delivery to.
I can see that there are a ton of messages in the queue, under the Default
SMTP Virtual Server.
What should I look at for troubleshooting??
The only...Move Mailbox 55 to 2003 delegate/client permissions not working
Hope someone out there can help.
We recently started moving mailboxes from Exchange 5.5 to Exchange 2003.
What we find is that users who remain on the old system and which had
permissions to certain folders of a user moved to 2003 can no longer access
Now here is the strange part, on this particular 2003 user, when you remove
the permissions on Outlook and recreate them the 55 user can still not
access the folder.
BUT, if I assign permissions to a completely diff Mbx (previously migrated
to 2003) on 2003 then the 55 user can access the resources.
We have many users w...queue can receive internal mail but not external mail !!! help !!!
i have CRM 3.0 installed and all is working fine. The only problem is the
queue can receive the mail that send from internal BUT CAN NOT receive
external mail! any way to troubleshot this as i had read some of the forum
but is doesn't help. from the exchange system manager if mail send from
internal is able to route to crm mail's box but if the mail is from external
then it would not able to route to crm mail's box. There is no error message
on the event viewer log.
thank you if any one can help on this !!!!
1. CRM-Exchange Email Router installed?
2. Mail for...dvd drive not working
I am having some trouble with my NEC 3550A DVD drive in Windows XP SP3.
The drive is not visible in Explorer and cannot be accessed. The
Device Manager does show the drive but informs me the driver is missing
or corrupted (Code 39).
I have uninstalled the DVD drive numerous times from the Device Manager
and either rebooted or ran the Add Hardware Device applet. In each
instance the OS finds the Plug and Play device and installs the device
drivers but informs me that it couldn't do it properly. I have
replaced the IDE cable and tried out a known good DVD drive as a
replacement...How do I get automatic sequential numbering when using an invoice.
Mary, have a look here,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"MaryL" <MaryL@discussions.microsoft.com> wrote in message
...Graphing daily data
I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates. Any ideas on how to accomplish this?
Use your worksheet to pull the relevant data together into a series. Do the
data manipulation in your worksheet, then the chart plots the series which
you have generated in the worksheet.
"Fozzie" <Fozzie@discussions.microsoft.com> wrote in message
>I am trying to graph daily data f...Pivot Table Data field
I am importing the data from Ms Access, and creating Pivot table.
Row, Data and Columns have drop down manus where you can select and
In Row and Columns when if i unselect any values in drop down menu and
go back values are still there. However, With Data when i unselect any
values it vanish i am unable to retrive it back. Please any one let me
know if i unselect any values from the Data dropdown menu they still
-------------------------------------------...SSRS 2008 get report parameters to work
I want to add report parameters to a sql server report service 2008 that has
been generated by the report wizard and have the parameters work.
I can get the report parametes to look like they work by doing the following:
1. select view then report data then right click parameters in the report
2. I then select add parameters then enter a 'name' then enter a prompt
name and then select data type.
3. I then right click on the dataset and then click dataset properties and
then click on parameteres in the dataset properties window and add
the parameters I w...Extracting data and returing to colums.
I am about half way there, but I need some more help.
These are web inquires that parsed out in the same colum and repeat th
same way all down the page.
I want to be able to use the fields as guidelines to pull the dat
adjacent to it and sent to the new colum. In a way it is transposin
all the data, but I need to pull all the first names of these peopl
and have them align in the first colum. Same for Last name, business
So if the information that I have come across like this in th
spreadsheet, I just want the customer infomation to move to th
appropriate colums like the third example...how do I convert Mozilla thunderbird data to outlook 2010?
Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
Outlook and would like to switch back. Can't seem to see a conversion utility
I suspect you export from thunderbird to a format Outlook can import, eg csv
(assuming pop mail)
"Mishka" <Mishka@discussions.microsoft.com> wrote in message
> Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
> Outlook and would like to switch back. Can't seem to see a conversion
>...Scheduled delivery not working
We set up a custom schedule under delivery options on the SMTP connector to
schedule delivery of any messages over 4MB. It is set to deliver after hours
to keep from maxing out our connection to the internet. Unfortunately,
messages seem to be sitting there for days on end and not going at the
scheduled times. I am able to manually force the connection and emails go
fine. Anyone have any ideas of where to look since everything looks just
...Show hours worked or Text "Day Off"
I have a spreadsheet that keeps track of hours worked during the week. The
formula is =IF(OR(B23="",C23="",D23="",E23=""),"Day Off",(TEXT(B23,"h:mm
AM/PM")&" - "&TEXT(C23,"h:mm AM/PM")
"&TEXT(D23,"h:mm AM/PM")&" - "&TEXT(E23,"h:mm AM/PM")))
The columns track the In and Out times, Column B is In, Column C is Out,
Column D is In, Column E is Out.
This works great when there are no hours worked or there is a time in all 4
columns. It will give...Complicated conditional formatting if numbers match across a data set..How?
Ok. Here is the setup I have. I have columns of data setup across the
-1.5 -110 -1.5 -110 -2 -110
1.5 110 1.5 -105 2 -110
The -1.5 and -110 are in two seperate columns but together are under
the Heading A., the second set of two numbers is under Heading B, etc.
So each set of two columns should be considered a set together. My
I need some kind of query that will go across each data set and compare
the numbers and highlight them in some way if they meet certain
conditions. Take Heading A as a benchmark (Heading A makes up Columns
A/B for example). I need Column A to c...Data not displayed in some Public Folder items
Hello, I have a problem with some items in a Public Folder. These items are
posted using a form from the Organisation Forms. A while ago we had a problem
where the form stopped working (sorry I don't know the details as I was not
directly involved) and a new form was created and set up to be used in the
The problem is that the data contained in posts to the folder prior to the
new form being published do not contain any data. The posts are still there
and can be opened, but no data is shown other than the sender's name and the
name of the public folder.
I am guessing t...can't get outside email
can't get Outside email, Using groupwise connector. There
is an error everytime an email arrives, that says message
is looping. and the messages are never sent.
...external and internal port numbers
cx Im seting up file sharing between my desktop (host cmputer) and my laptop
...I'm asked to insert external and internal port numbers. Are those the same
as the ones I have entered in my email setup??
> cx Im seting up file sharing between my desktop (host cmputer) and my
> laptop ..I'm asked to insert external and internal port numbers. Are
> those the same as the ones I have entered in my email setup??
No. Different application. If it's the file sharing built into the operating
system, you'll want to ask in a newsgroup about that OS.
Microsoft O...Get email from .edb file?
I have a perfectly good .edb file. However it's impossible to mount.
Is there a utlity that can extract email from that flat .edb database?
This is Exchange 5.5
Thank you, JB
yes...look at Quest's Recovery Manager for Exchange...
"Jack Black" <JackBlack@hat.com> wrote in message
> Hi All
> I have a perfectly good .edb file. However it's impossible to mount.
> Is there a utlity that can extract email from that flat .edb database?
> This is Exchange 5.5
> Thank you, JB