Data Validation #8
Hope some genius out there can help.
I need to ensure that users enter a numeric value in the current cell of a
range of cells. I've attempted to use the "Data Validation" feature of Excel
but do not want to restrict the user to a particular range of numbers, but
merely to restrict them from entering a text value. I selected my
"Validation Criteria" as "Custom" with a "Formula"
=ISNUMBER(CELL("address")). This approach only seems to work on the first
cell in the range. Subsequent entries in the other cells in the range where
Is the Extender Product just for version 8? I looked in Download and
couldn't find version 7.5.
Extender was not owned by Microsoft before version 8 I believe.
You may be able to get it from its original distributor - eOne Business
Website is here - www.eonesolutions.com.au
"Doug" <Doug@discussions.microsoft.com> wrote in message
> Is the Extender Product just for version 8? I looked in Download and
> couldn't find version...Creating Driver Package
I have been using the Jan Axelon WINUSB c# sample from his
using this , the driver shall be install if it connected.
How to create the driver package for this.
Ever Tried,Ever Fail, No Matter Try Again Fail Again Fail Better
Jayakumar Natarajan <JayakumarNatarajan@discussions.microsoft.com> wrote:
> I have been using the Jan Axelon WINUSB c# sample from his
FYI, Jan Axelson is a woman.
>using this , the driver shall be install if it connected.
>How to cr...Migrating Users to New Exchange 2003 Server
Is there a way to change which server that Outlook 2000, 2002, 2003
looks at wihtout having to redo their profiles??
We have an Exchange 2000 server, E2K, and we are migrating some users,
not all, to a new server that is coexisting, E2K3. I want to be able
to move groups of users without having to go to their desktops and
Thanks in advance,
...New Windows 2K / Exchange 2K
I move mailbox and public folder from an old server (Win2K/Exchnage 2K) to
new server (Win2K/Exchange 2K).
I follow the instructions on the KB 307917, for public folder replication.
Accindentally, I uninstal Exchange 2000 on the old server before to remove
public folders replicas on the new exchange server.
Outlook client can work on the public folders of new server, but I can not
work with public folder (to remove public folders replicas) with Exchange
System Manager (ESM).
I Want to use folder proprierties to remove replica from old server.
I can not see the public folder on the root publi...add new field in form
I need to customize a great plains form.
I need to add new field in the form .
Then I need the data of the field stored in the notes of the form
Can you advise me about the steps and the need code that I showed write .
Maybe you should ask this in the Great Plains newsgroup.
"john" <firstname.lastname@example.org> wrote in message
I need to customize a great plains form.
I need to add new field in the form .
Then I need the data of the field stored in ...multiple work sheet data to link in one worksheet
Kindly help me out with this problem. i have a data of multiple clients.
e.g. complete data of a single client will found in single work sheet. the
name of the work sheet is equal to name of the clients. i have around 50
worksheets like this. i just need to combine the sales and operating profits
of all the clients in below given format for each of the month. kindly
suggest how to do it.
sept 09 oct 09 nov 09
client name sales GOP SALES GOP SALES GOP
For, "sales" and &qu...Cannot Create Tasks
Exchange 5.5, Windows 2000, Outlook 2000. I have a user
who is trying to create tasks and he gets a message that
says that he does not have permission to do this. He can
edit tasks and delete tasks, but not create them. We've
run the repair utility, reinstalled, thought that it had
to do with the PALM software and removed that, and there
has been no change. Any help would be much appreciated!
...Create any size bitmap
Is there an easy way to do this? I want the user to be able to draw in any
size bitmap they want. I have looked at CBitmap but can't seem to get it to
"ScottyO" <email@example.com> wrote in message
> Is there an easy way to do this? I want the user to be able to draw in
> size bitmap they want. I have looked at CBitmap but can't seem to get it
That was too easy. I can't belie...Creating a worksheet with stats created from selected data...
I am creating a spreadsheet that I believe requires 3 sheets. The first sheet will be a database containing up to 500 company names. The second sheet will contain a pivot table for total stats, so far so good. I also need to produce different stats (percentages of actual vs target) for a selected number of companies (the companies will remain the same or only change infrequently). Any suggestions for the best way forward for the third sheet? TIA.
...Importing Data/Field Mapping
I am going to be importing user contact data from a text file. I
know the process, but what I am looking for is a listing/description
of contact fields in CRM so I can give let the users map their
fields to CRM fields...and save me some time. I know I can go to the
import data function, but is it posted anywhere?
IT Support Specialist
Go Into your Deployment Manager Under Schema and then
contact, all the fields are listed.
>I am going to be importing user contact data from a text ...My Data Base will Not open in Publisher Mail Merge
When I try to Merge a Data Base into a Publisher piece heres what i get:
The data source you have chosen contains more than one worksheet or table.
Please enter the name of the worksheet or table that contains the
information you want to merge.
I have NO IDEA what its asking me for. Publisher Help doesn t seem to have
the answer, the co. that I bought the Data from has no idea. She sent it in
CSV format if that helps. Thanks firstname.lastname@example.org
Sounds like it has move than one worksheet in an Excel file. Make a backup
copy, then open it with Excel, if it has more than one worksheet delete...Error Entry Point Not Found.
When I start Outlook with default to show outlook today,
I get the following error message: "The procedure entry
point GetIUMS could not be located in the dynamic link
library MSDART.DLL. If I switch it back to starting in
inbox I do not get this message. I only get it when it
tries to access outlook today. Can anyone help? Thanks
I'm getting the same exact thing. If you find a cure,
could you repost. Thanks
>When I start Outlook with default to show outlook today,
>I get the following error message: "The procedure entry
>poi...Creating array from matrix with blank values
I have a matrix in the following format
1 X X X X X X X X
X X X 3 X X X X X
4 X X X X X X X X
where 'X' is a blank cell.
I need to get the data in the form
Any suggestions? I tried a nested if statement but it doesn't work
since there are more than 7 ifs.
If there is only one value in each row, then simply using
where A1:L1 is your top row, then copied down for two more rows, will give you your desired result.
MS Excel MVP
<Andryll.Davis@gmail.com> wrote in message
news:email@example.com......Can i Create an hyperlink in a shape to that shape Data?
I'm trying to create a hyperlink in a shape that link's me directly to that
shape data without use of reports or external data.
The point of this is: when publishing a pdf of de Visio 2007 document, the
hiperlinks i've created work in the pdf or in the visio viewer.
EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks #24
...How to add KillFocus handler for dynamically created controls?
For a normal combobox
ON_CBN_KILLFOCUS(IDC_COMBO1, OnCbnKillfocusCombo1) works
I tried to do the same thing with dynamically created combobox, but it
didn't work. Could anyone help?
Not sure what is happening for you but it works fine:-
1) Create a dialog based application.
2) Create a class derived from CComboBox.
3) Add a member in the Dialog class and let's name it as
myComBoBox of type CComboBox
4) Now go to OnInitDialog and add this at the todo.
CRect(10,10,200,100), this, 1);
5) N...Can't change data type
I was trying to update field size in table design. I get a message saying
'You can't change the data type or field, it is part of one or more
relationships. If you want to change the data type of this field, first
delete its relationship in the Relationships window.
I have deleted the relationship and I still get this message when trying to
update the field size.
Sounds like you missed one... In the Relationships Window click the show all
button and delete the remaining ones and try changing your field size again.
Also, if this database is split then yo...Hyperlink new window
How do I get a hyperlink to open up a new Internet Explorer window (i.e., I don't want people to have to back out of the linked website to get back to mine).
Please refer to existing threads in correct forum. See the thread "Open in
New Window" isn't appearing as an option" posted yesterday in
David Bartosik - MS MVP
for Publisher help:
enter to win Pub 2003:
"Paul" <Paul@discussions.microsoft.com> wrote in message
news:F49A8EDA-030E-4826-927D-A97F7442DB...Create Sales Order Question
It's hard to know tables of GP that relating to Sales Orders. When I create
a saleorder, what table/tables should a saleorder be stored? such as table
names: SOP10100,SOP10101,etc. I don't exactly how many tables and which ones
Anyone has ideas, please let me know.
Thanks and Appreciations
Go to http://msdynamicsgp.blogspot.com/, scroll down the right side of
the site and download the GP table reference. Thanks to Mr. Polino,
this will answer your questions.
MCP-GP, MCT, MVP
East Coast Dynamics
Thanks for your resp...Writing in data from a userform to a spreadsheet
I'm currently doing some work using Excel and VBA as part
of my dessertation but i'm stuck and really need help. Can
someone please help me!
The problem is that i'm writing data(numbers) from
textboxes in a userform and copying these values into a
column of cells on a spreadsheet, the problem is that the
SUM function does not work to sum up these values into
another cell. Excel sees these as blanks even though the
numbers do appear.
please can someone help me,
Couple of things to check:
1 The numbers are actual numbers and not preceeded with a ' character...Constant data appearing in Immediate Window of VBE
Somehow the below constantly appears in my VBE Immediate window:
How can I erase it so that the window is "clean"?
I just loaded my book.xlt and erased it and resaved book.xlt. Then Closed
Reopened Excel and Alt-F11 Ctl-G and there is again...??????
[VerifyOpen] > 1
It looks like debug code to me that is being written to the immediate window
in Debug.Print statements. Each ...Send Receive issues with Outlook 2007 & Window 7
I cannot get may outlook to work with Windows 7. I keep getting a 'receiving
reported error (0x80042108) : 'Outlook cannot connect to your incoming (POP3)
email server... please contact your ISP.
It does complete the send task (ie completes 1 of 2 tasks)
I have called the ISP provider and they say everything is setup OK, I have
re-installed office 2007 with SP2, I have turned off the firewall protection,
I can access the internet.
"Frustrated Brian" <Frustrated Brian@discussions.microsoft.com> wrote in
message news:03D834F0-B4DD-4930-...How to get query/report to show an entry if system date
It is a little more complicated than that for me atleast.
Here is the situation: I am making a "Daily Report" for our manning. We
have people go on vaction and have appointments often in our office.
I have built a database that we can enter in all of this information where
(vacations, appointments, people coming and people going, etc...)
My situation is I want to make a Daily Report to send out to each section
everyday, but I do not want everything to show up for each form on the
report. I only want what is going to affect that day.
If Jason Jones is ...how do i create a divisible formula
I use a xl doc that has numbers in the cells that need to be divisible by 15.
Can i incert a formula that will check the number in B5 and display an error
message in F10 if the number in B5 is not divisible by 15.
Try this in F10
> I use a xl doc that has numbers in the cells that need to be divisible by 15.
> Can i incert a formula that will check the number in B5 and display an error
> message in F10 if the number in B5 is not divisible by 15.
On Wed, 6 Jan 2010 05:32:01 -0800, Ti...New Meeting Request as default
When I am viewing my Calendar and I double click on a specific time, the
default window that opens is for a new appointment.
Is there any way to have a new meeting request window open up instead?
Paras Shah <firstname.lastname@example.org> typed:
> When I am viewing my Calendar and I double click on a specific time,
> the default window that opens is for a new appointment.
> Is there any way to have a new meeting request window open up instead?
Not sure, but it's a simple mouse click to use the "i...