How to use data validation
[NB: I re-structure my question since people got misled from my previous one]
What I really wish to ask is:
I wish to use data validation for a particular cell. But it doesn't work if I
choose "custom" in the "allow" box.
1) In Data | Validation | Settings Tab | Validation Criteria, there is an
2) I chose "custom", there is a formula.
3) I type in some formula, eg:
=J3 (Just Reference)
=J3-J1 (Reference-type formula)
=round(J1) (Function-type formula)
None of them can activate the validation fu...date validation MAYBE
Is there a way to do the following
I will have two columns A = Kill Date B = Use by date - I would like to set
the cell in which the use by date is entered to change colour (Have tried to
use conditional format but failed) So for intance
KILL DATE 1/1/06
USE BY DATE 15/1/06
FOR DATES 1 TO 5 CELL COLOUR GREEN
DATES 5 TO 10 CELL COLOUR AMBER
DATES 10 TO 15 CELL COLOUR RED
I want to use this as an alert to correct use of raw meat within my
Any help would be good
Condition 1: Formula is: =$B2<=$A2+5 format i...Stopping free text entry in validation cell
I have an xls that I have set up with validation lists in some cells. I need
to stop users from ignoring the options in the list and just typing whatever
the want in the cell.
Anyone help? I am sure it is easy, but can't see how to do it.
If you are using a list then that should be enough unless they copy and
paste into the validation cell
"smf" <firstname.lastname@example.org> wrote in message
> I have an xls that I have set up with validation lists...Data Validation / find & replace
If I can one entry within a list set-up using Data Validation, how do I get
it to up-date automatically wherever the original selection has been made?
Example: list has:-
I change Goodbye to See Ya ... now I want everywhere that has Goodbye in it
to change to See Ya without me having to go and make the change ... this may
be in more than one workbook so am assuming that if I was to use
find/replace, I would have to open each workbook individually and repeat
process? Or can you use find/replace on closed workbooks?
>Or can you use find/replace on closed workbo...Cant open PST file!
I had a PST file (300 megabytes) which opened fine but suddenly, under
Windows XP, it is having problems opening. I get the following 2 error
(1) "Properties for this information service must be defined prior to use"
(2) "The file ..... is not a personal folders file"
The file is still 300 megabytes so the data is still there - but why cannot
I open it?? What should I do?
Have you tried running the Inbox Repair Tool (SCANPST.EXE) against the file?
Ben M. Schorr, OneNote-MVP
**I apologize bu...PST Validation Tester
is there some utility out there that will allow me to test a directory
of PST files to determine whether they're valid or not? I'm doing a
GroupWise to PST conversion for a data recovery company and randomly,
one of the PST files I create gets corrupted. I try to open it in
Outlook and it immediately shrinks down to 32K (from 6 Meg) and the
Personal folder is empty, no messages. However, most of the other
ones I do are fine. I'm talking about hundreds of PST files and I
don't want to have to open each one of them 1 by 1. Is there a
utility that will test/verify/vali...cannot import .pst files
My hard drive was about to fail last week and I copied
all of my inbox and sent files to a CD-Rom before
replacing the hard drive. I've been able to restore
everything else in My Documents, My Favorites, etc.
But when I attempt to import the inbox backup, I get an
error message that reads, "Errors have been detected in
the file D:\inboxbackup.pst. Quit all mail-enabled
applications and then use the Inbox Repair Tool."
When I attempt to import the sent backup, I get an error
message that reads, "The file sentbackup.pst is not a
personal folders file."
Can any...Spreadsheet validation
can any one give me any idea about excell spreadsheets validation. An
published article or a link would be very useful.
Message posted from http://www.ExcelForum.com
have a look at
> dear all,
> can any one give me any idea about excell spreadsheets validation.
> published article or a link would be very useful.
> Thanks Abhishek
> Message posted from http://www.ExcelForum.com/
...Data Validation #12
I have data validations in sheet1 as named range lists from sheet2.
When I have deleted sheet2 and copy sheet2 from identical other workbook -
my validations does is not work...
I see Name ranges in copied worksheet, but when I use they in validation - I
have error: "The Source currently evaluates an error. Do you wish
Only after deleting of Named ranges in Sheet2 and recreating its, my
It is possible after replacing of worksheet with named ranges for
validations (named ranges names are identical) use copied worksheet without
recreating ...Is String a valid XML Name?
Is there a way to check a string to see if it is a valid XML Name according
to the definition in the XML specifiction
(http://www.w3.org/TR/REC-xml#dt-name). I wrote code to do this by hand but
then I thought it must be available in the .net framework XML classes
somewhere. Is it?
Harold Putman wrote:
> Is there a way to check a string to see if it is a valid XML Name according
> to the definition in the XML specifiction
> (http://www.w3.org/TR/REC-xml#dt-name). I wrote code to do this by hand but
> then I thought it must be available in the .net framework XML classes
> so...2002 Data Validation blank
On sheet 1 in a workbook, I can set a data validation list
up for a cell. It works.
On sheet 2, an exact copy of the first sheet, I also set
up data validation for a cell. It does not work.
In each case, the list is on the respective sheet.
I have tried saving the book with different names
under "save as ..." to try to enforce the validation, but
to no avail.
When I select data validation for the cell that is to be
validated on sheet 2, it displays that it is in fact a
list and the range is proper, but I do not get the drop
down list when clicking on the cell. The "in...Validators
I am using a CompareValidator to make sure the content in a textbox control
is an integer. I am also using a RangeValidator to make sure the number is
between a certain range.
When the user types an alphanumeric string (i.e. "A67"), both validators
fire. I understand why the CompareValidator fires. Why does the
In this case, I do not want to see both errors. Is there anyway to have the
second through n validators not get evaluated, if the first validator failed?
Are there other options I should be considering?
...Migrating from Novell to Windows 2000 server causes issues with .PST on Win95/98
Hopefully someone has seen this before and can provide a clue.
We are currently migrating all of our user home directories from Novell 5
servers to Windows 2000 servers. The majority of our clients are XP and
Windows 2000 workstations using Outlook 2000. However, there are still a
number of clients using Windows 95/98 and Outlook 98.
After copying .PST files from the Novell home directory to the Windows 2000
home directory using a Windows XP workstation, users using the Windows 95/98
workstations get an 'access denied error' when attempting to open their .PST
folder from the ...Validate cell for date, as well as day of the week
I have looked through what is out there and I am not hopeful that this can be
done, but here goes...
I have a cell that will be populated with a date. I need to make sure that
the date does not fall on a Saturday or a Sunday and that the date is not
older than 2 days. I was hoping to be able to do both of these in a single
validation, but I have a snag. The weekday function requires a cell, but I
am validating on the current cell and, even though I do know what it is, i
want to allow that that may change. How can I accomplish this?
I could not get data validation to work....Export pst files in Outlook xp
My Outlook xp will post the following message when
attemptng to export my "inbox" files for back up reasons:
The messagin interface has encountered an unknown error.
If the problem persists, please restart outlook.
Restarting outlook or tryinng to repair outlook does not
fix the problem.
On Thu, 3 Jun 2004 17:18:44 -0700, "AT"
>My Outlook xp will post the following message when
>attemptng to export my "inbox" files for back up reasons:
>The messagin interface has encountered an unk...Data Validation #31
That was exactly what I needed. I was even able to use the [alt] enter
key to get the formatting that I wanted on the form.
I appreciate it very much :)
rick2701's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15852
View this thread: http://www.excelforum.com/showthread.php?threadid=273439
...Data Validation Option
Is it possible to have a data validation list for entry in a cell but also
be able to enter any value you want in the cell? I have seen Debra
Dalgleish's files where you can enter any value and it is added to the list.
Ideally I would like to have the facility to do this but I do not want to
add this to the list as it is a fixed list. I know this may sound peculiar
but it is a solution to a particular situation. It would mean the user has
the option of entering a value from the drop down list or entering his or
her own value. On returning to this cell the options would remain the same
My outlook.pst is at 2.065+gig, which appears to not allow
the file to be repaired using scanpst.exe. I am unable to
open the person folders to delete/clean out messages to
reduce the size to allow the scanpst.exe to run and am
stuck in a loop. Is there a way to allow access to the
folders to delete/clean the emails.
Hi - you'll need the PST crop utility - back up your file first so you have
a safe copy in case something goes wrong. Note - you may lose some data....
If...Detect Valid Charactor
Well, how to detect a valid character depends on "what" you define as a
valid character. There are various C runtime library functions available for
each specific purpose but you need to know what is a valid character in your
For example, if you define only alphabets as valid characters, then you can
use isalpha() function, or if you define both alphabets and digits as v...Text field validation 11-17-04
I am trying to add a function that will validate a text field in CRM Account
I need to call that function whenever the users enter a value in the text
I know there are no events for text fields.
Where should I define the validate function? It it in
wwwroot\SFA\accts\edit.aspx or acct_cont.js file?
This function will not be called from OnLoad event.
I want to create the function that will simulate as KeyPress (or) OnChange
Appreciate your responses
If you search on the history of this group via Google, you will find a few posts
that outline options for addi...Validation
Julie the same can be achieve without going thru the
double drop down boxes. You could do it just using the
combobox alone. Thank again
Please stay in the ORIGINAL thread. The archives will thank you.
"JLong" <email@example.com> wrote in message
> Julie the same can be achieve without going thru the
> double drop down boxes. You could do it just using the
> combobox alone. Thank again
...importing pst files #3
I've had to reload Office 2000. I am now trying to import
the Outlook backup I made, which is a .pst file. I'm
following the import directions, Outlook is performing
the task, but nothing is showing up - I am unable to see
any of my contacts, emails, or folders I created.
HELP! I'm desperate!
Why are you trying to import? Why not just use the old .pst file as your
main Outlook data file? If you need help in doing this, go to Help | About
Microsoft Outlook and tell us whether Outlook is configured in Internet Mail
Only or Corporate/Workgroup mode.
Sue Mosher, Outlook M...error importing pst files
when trying to convert the old non-unicode PST file to a unicode PST file, I
recieve a message that says "file folder pst already in use" and then it does
not allow me to proceed. any ideas?
Since importing would never be the correct way to do this, one must wonder
what you are doing and why. You provided no information.
"Dono" <Dono@discussions.microsoft.com> wrote in message
> when trying to convert the old non-unicode PST file to a unicode PST file,
...Conditional validation :-)
I am using list validation in column A where user can choose 1-9 in each
cell. What I wish to create is:
if A1=1 then the validation list for B1 is 1.1 to 1.9
if A1=2 then the validation list for B1 is 2.1 to 2.9
and so on.... In effect, its conditional which validation list is being used.
How do I set this up??
Thanks in advance
Here's one way:
Create a table like this somewhere on your sheet:
1 1.1 2.1 3.1 ... 9.1
2 1.2 2.2 3.2 ... 9.2
3 1.3 2.3 3.3 ... 9.3
4 1.4 2.4 3.4 ... 9.4
9 1.9 2.9 3.9 ... 9.9
Assume the table is in the ran...ms access form validation
I am very young in ms access vba,
I am trying to create a simple inventory system. I have a problem in
validation especially in my issue form. I have a query which calculate
the balance of item in stock.
So what i want is when the user issue items, through the issue form
and he/she typet the quantity more the the balance available in the
query, the system tell her/him that he/she is issuing more than
available in stock.
Please help me to write a code;
Note that, the query's name is qry_issue and the field which calculate
the balance is called qtybalance.
The form used to isue iten is c...