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 4811
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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... 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.earth link.net>, sp**@nospam.spa m 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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... 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.earth link.net>, sp**@nospam.sp am 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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... > 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.comca st.net... In article <ta************ *****@newsread3 .news.atl.earth link.net>, sp**@nospam.spa m 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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... 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.comca st.net: In article <ta************ *****@newsread3 .news.atl.earth link.net>, sp**@nospam.spa m 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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... > 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******@gener ation.net> wrote in message
news:82******** *************** *******@news.te ranews.com... Ima Lostsoul <me@myprovider. com> wrote in news:MP******** *************** *@netnews.comca st.net:
In article <ta************ *****@newsread3 .news.atl.earth link.net>, sp**@nospam.spa m 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******@pcdata sheet.com www.pcdatasheet.com
<Sami> wrote in message news:4q******** *************** *********@4ax.c om... > 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 and some who couldn't but that it wasn't important right now.
And I said, 'sure, we can do that later'.
So now I've developed an app without any thought to security and am trying
to apply it afterwards. Doh!, doh! and triple doh!
|
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 to appear in a key number? This is
necessary for use with IDs beginning with a zero.
Finally, input forced to begin in far left of field? There is a
character used, and for the life of me I cannot recall.
|
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 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
|
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 with this I was wondering if anyone could perhaps
offer advice or point me to any documents/web pages that could help with
ensuring the security of the form/page and site. It is likely that the
form will come under attack I expect.
Even comments...
| |
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.
The statusbar comes up with a message saying:
"Recordset is not updatable"
This combobox works with Admin permissions but not Read Only.
|
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 10:00:00 AM 12:00:00 PM
120
|
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)
that will automatically move to the END of the existing text (a blinking
cursor).
Yes, I've Googled, but cannot seem to locate just what I'm looking for.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |