Problem:
Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can tell.
Next, foreign students have & as the initial part of their SSN. How
to do this??
Finally, how do I force the cursor to the far left of the field so the
person doing data entry does not have to backspace to the beginning of
the data entry field?
Please be specific - not a sophisticated person making the program!
Thanks. 6 4783
Social Security Numbers are not numbers even though they say they are. They are
text because they can start with 0, start with & and US SSNs have two dashes. So
you need to go to your table and change the data type of your SSN field to text.
All your problems will go away!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... Problem:
Social Security number being used in a database. First problem is that it will not permit numbers beginning in zero to be entered - it sees it as a null or empty space from what I can tell.
Next, foreign students have & as the initial part of their SSN. How to do this??
Finally, how do I force the cursor to the far left of the field so the person doing data entry does not have to backspace to the beginning of the data entry field?
Please be specific - not a sophisticated person making the program!
Thanks.
In article <ta*****************@newsread3.news.atl.earthlink. net>, sp**@nospam.spam says... Social Security Numbers are not numbers even though they say they are. They are text because they can start with 0, start with & and US SSNs have two dashes. So you need to go to your table and change the data type of your SSN field to text. All your problems will go away!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... Problem:
Social Security number being used in a database. First problem is that it will not permit numbers beginning in zero to be entered - it sees it as a null or empty space from what I can tell.
Next, foreign students have & as the initial part of their SSN. How to do this??
Finally, how do I force the cursor to the far left of the field so the person doing data entry does not have to backspace to the beginning of the data entry field?
Please be specific - not a sophisticated person making the program!
Thanks.
ARGH That is horrid! A number is not text simply bcasue it starts with
a zero... That is (IMHO) very poor programming. You are mixing the
storage of a value with the display there of. Look in the formatting of
the controls you use to input/display the SSN and you will see how to
handle SSNs that begin with one or more 0s without bastardizing your
data.
How do I do this? Where would I look if you do not want to tell me,
and what is it called? Thanks.
On Wed, 14 Apr 2004 06:33:14 GMT, Ima Lostsoul <me@myprovider.com>
wrote: In article <ta*****************@newsread3.news.atl.earthlink. net>, sp**@nospam.spam says... Social Security Numbers are not numbers even though they say they are. They are text because they can start with 0, start with & and US SSNs have two dashes. So you need to go to your table and change the data type of your SSN field to text. All your problems will go away!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... > Problem: > > Social Security number being used in a database. First problem is > that it will not permit numbers beginning in zero to be entered - it > sees it as a null or empty space from what I can tell. > > Next, foreign students have & as the initial part of their SSN. How > to do this?? > > Finally, how do I force the cursor to the far left of the field so the > person doing data entry does not have to backspace to the beginning of > the data entry field? > > Please be specific - not a sophisticated person making the program! > > Thanks.
ARGH That is horrid! A number is not text simply bcasue it starts with a zero... That is (IMHO) very poor programming. You are mixing the storage of a value with the display there of. Look in the formatting of the controls you use to input/display the SSN and you will see how to handle SSNs that begin with one or more 0s without bastardizing your data.
<<A number is not text simply bcasue it starts with a zero>>
Can you give me one example of a number that starts with a zero?
Steve
PC Datasheet
"Ima Lostsoul" <me@myprovider.com> wrote in message
news:MP************************@netnews.comcast.ne t... In article <ta*****************@newsread3.news.atl.earthlink. net>, sp**@nospam.spam says... Social Security Numbers are not numbers even though they say they are. They
are text because they can start with 0, start with & and US SSNs have two
dashes. So you need to go to your table and change the data type of your SSN field to
text. All your problems will go away!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... Problem:
Social Security number being used in a database. First problem is that it will not permit numbers beginning in zero to be entered - it sees it as a null or empty space from what I can tell.
Next, foreign students have & as the initial part of their SSN. How to do this??
Finally, how do I force the cursor to the far left of the field so the person doing data entry does not have to backspace to the beginning of the data entry field?
Please be specific - not a sophisticated person making the program!
Thanks.
ARGH That is horrid! A number is not text simply bcasue it starts with a zero... That is (IMHO) very poor programming. You are mixing the storage of a value with the display there of. Look in the formatting of the controls you use to input/display the SSN and you will see how to handle SSNs that begin with one or more 0s without bastardizing your data.
Ima Lostsoul <me@myprovider.com> wrote in
news:MP************************@netnews.comcast.ne t: In article <ta*****************@newsread3.news.atl.earthlink. net>, sp**@nospam.spam says... Social Security Numbers are not numbers even though they say they are. They are text because they can start with 0, start with & and US SSNs have two dashes. So you need to go to your table and change the data type of your SSN field to text. All your problems will go away!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... > Problem: > > Social Security number being used in a database. First > problem is that it will not permit numbers beginning in > zero to be entered - it sees it as a null or empty space > from what I can tell. > > Next, foreign students have & as the initial part of their > SSN. How to do this?? > > Finally, how do I force the cursor to the far left of the > field so the person doing data entry does not have to > backspace to the beginning of the data entry field? > > Please be specific - not a sophisticated person making the > program! > > Thanks.
ARGH That is horrid! A number is not text simply bcasue it starts with a zero...
Good grief! a text is not a number just because it contains only
digits. I remember learning, oh about thirty years ago, that you
should us a numeric field if you are going to add, subtract,
multiply or divide the contents thereof, else use type text.
A numeric field may also be used as a key, but you can do it with
text fields as well.
There is no guarantee that future SSNs will contain only the
characters 0 through 9.
That is (IMHO) very poor programming. You are mixing the storage of a value with the display there of. Look in the formatting of the controls you use to input/display the SSN and you will see how to handle SSNs that begin with one or more 0s without bastardizing your data.
And as the original poster said, he must, now, include "&" in some cases.
That could be misinterpreted as a type-declaration character in a numeric
field.
Clive
"Bob Quintal" <bq******@generation.net> wrote in message
news:82******************************@news.teranew s.com... Ima Lostsoul <me@myprovider.com> wrote in news:MP************************@netnews.comcast.ne t:
In article <ta*****************@newsread3.news.atl.earthlink. net>, sp**@nospam.spam says... Social Security Numbers are not numbers even though they say they are. They are text because they can start with 0, start with & and US SSNs have two dashes. So you need to go to your table and change the data type of your SSN field to text. All your problems will go away!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q********************************@4ax.com... > Problem: > > Social Security number being used in a database. First > problem is that it will not permit numbers beginning in > zero to be entered - it sees it as a null or empty space > from what I can tell. > > Next, foreign students have & as the initial part of their > SSN. How to do this?? > > Finally, how do I force the cursor to the far left of the > field so the person doing data entry does not have to > backspace to the beginning of the data entry field? > > Please be specific - not a sophisticated person making the > program! > > Thanks.
ARGH That is horrid! A number is not text simply bcasue it starts with a zero...
Good grief! a text is not a number just because it contains only digits. I remember learning, oh about thirty years ago, that you should us a numeric field if you are going to add, subtract, multiply or divide the contents thereof, else use type text.
A numeric field may also be used as a key, but you can do it with text fields as well.
There is no guarantee that future SSNs will contain only the characters 0 through 9.
That is (IMHO) very poor programming. You are mixing the storage of a value with the display there of. Look in the formatting of the controls you use to input/display the SSN and you will see how to handle SSNs that begin with one or more 0s without bastardizing your data. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mike MacSween |
last post by:
S**t for brains strikes again!
Why did I do that? When I met the clients and at some point they vaguely
asked whether eventually would it be possible to have some people who could
read the data...
|
by: Sami |
last post by:
Title says it all. Using a Listbox to look up numbers - ie SSN for a
student - and then all of a sudden it shows up as 2323E+08 instead of
say 232-23-2323. Help!
Also, how can I force zeroes...
|
by: Sami |
last post by:
Problem:
Social Security number being used in a database. First problem is
that it will not permit numbers beginning in zero to be entered - it
sees it as a null or empty space from what I can...
|
by: Terry Andersen |
last post by:
If I have:
struct one_{
unsigned int one_1;
unsigned short one_2;
unsigned short one_3;
};
struct two_{
unsigned int two_1;
|
by: tony |
last post by:
I'm designing a survey form page that will be fairly complex and am
becoming confident enough with PHP now to tackle most things.
(Thanks to everyone here who has helped)
Before I go too far...
|
by: ricky.fung |
last post by:
I have several VBA functions in my Access Database that do not work.
I have a combobox that filters my subform data however I cannot select
anything when logged in with Read Only permission.
...
|
by: King |
last post by:
Hi
I have following MS Acess query
Here is the query
ID Name Prgm ID Client ID Date Start Time End
Time Minutes
C4 Trisha TIP DEK0703 7 /7 /2006...
|
by: Klaus Brune |
last post by:
Hello all,
When one tabs through a form (specifically, in Firefox), all the text in
a field is automatically selected.
What I'm looking for is a way to put a function (in onFocus perhaps)...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |