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  4779 
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: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
