Grabbing Last Six Digits Of Social Security Number

Aug 9, 2005


simple problem. how would i grab just the last six digits of a social security number?
example: 123-45-6789 to 456789

I'm guessing that I should use the Format function, but I'm not quite sure how to write it. Thanks!


View Replies


Report To Only Show Last 4 Digits Of Social Security Number

May 30, 2007

I have a report to print that only shows the last 4 digits of the Social Security field. How can I do so for the entire list of social security #'s.

Thanks in advance.:cool:

View 4 Replies View Related

Hide Social Security Number

Jun 14, 2005

I have a database for which I would like to disguise a social security number (123-45-6789) with stars (***-**-****) in my form, but only for a group of people for whom "Employee status" is "Staff". The SSN will not be entered in this particular form, only viewed to double check for all individuals who are not "Staff". Can anyone suggest how to do this? Thanks!

View 2 Replies View Related

Search Queri Social Security Number

Mar 17, 2006


I have a query that looks like this:
Like [Forms]![Searchaddress_form]![search_3] & "*"
The filed name is "ssn"

In a form I have an unbound field that is called "search_3" and when I type a number or more and hit enter it's supposed to look it up in the table. But it´s not working

FYI! It works whith letters. I have the same query for searchin first name and it works.
But not with numbers.

Any suggestions?


View 3 Replies View Related

Modules & VBA :: Hiding Social Security Number In Form?

Apr 30, 2015

On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have used the mask on it so it automatically inputs dashes. I am attempting to hide all but the last four digits of the ssn. This is on the on current event of my form.


'Hide SSN
Dim strLSSN, strSSN As String
strLSSN = Right(SSN, 4)
strSSN = ("***-**-" & strLSSN)
Me.SSN = strSSN

View 1 Replies View Related

Social Security Alternatives?

Jun 11, 2007


I need a natural unique id for current and new enrollees, and I do not want to store social security numbers. If a new person enrolls, I need a way to know if they're already in our system.

I was wondering if a lookup table would work, where you switch a random autonumber for a social. If this will work, is it more secure than simply storing the socials?

Thank you!

View 2 Replies View Related

Social Security Masking On A Form

Jun 7, 2006

I have a form based on a table where social security numbers are entered. I would like to enter a social security number on the form and once it's entered the first 5 digits are masked. When I go to the table I would like to see the complete social security number displayed. Is this possible? Can the control source on the form be formatted to hide the existing social security numbers as well so they don't have to be rekeyed with the new format?

Thank you in advance:cool:

View 3 Replies View Related

Social Security Numbers Used As Identifiers.

Sep 12, 2005

G’day all.

I am posting this on more than one site but that should not matter simply because it asks for an opinion and, as such, your opinion should not be construed or even considered as an absolute answer…valued yes, absolute no.

What issues may emanate from using the US SSN, or equivalent numbers in other countries, as an identifier for unique records in a database?

Not under local database control?
And anything else you may care to mention.

Please, members from foreign countries to the US, you are welcome to add your thoughts here.

And please also, this is not about anything you may wish to take up with the Federal Court, Privy Council, High Court or whatever in the future in your country. It’s about your understanding of the situation as it stands, at the moment, in your country.

That’s about it…what do you think?

The following three links should take you to the other two sites…
(Sounds like a bit of gobldegook but you are already on one of those sites.)


View 5 Replies View Related

PageUp Gives Last User Social Security

Apr 26, 2006

I have a database that keeps track of vositors to our center. A student recently complained because after signing in he hit pageup and his social security was displayed.

Students enter thier number and pick a subject and class from drop downs and thenclick sign in.

Is there something I can put in the Onclick event that would not allow a new user to view the previous users info?



View 3 Replies View Related

Social Security In Table And Reports

Apr 11, 2014

How I can generate just the last 4 digits of the SSN need to be shown on the reports which are generated? For example if a SSN were: 123-45-6789 I would want the field to read ***-**-6789. I also would like to have actual row in table password protected on its own is this possible?

View 2 Replies View Related

Change Number Of Digits To 5

Jun 30, 2005

have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX:


change to:

Help please. Dont want to do it in VBA either. I would rather build it as an expression field or something.

View 2 Replies View Related

Currency Convert From Digits To Number

Nov 7, 2007

dear frnd,

i have a access program for printing cheque. i want to use a text box which automaticaly convert number ito digits from user input text box.

View 1 Replies View Related

Need Longer Then 9 Digits In Number Type Field

Dec 14, 2004

I need a field to permit only numbers. Upon selecting number for the data type I select Long Integer for a longer number... But it only allows 9 digits.. I need it to allow to enter in longer numbers... Any help?
Thank you very much in avdance

View 9 Replies View Related

Define Number Of Digits In Table Fields

Jul 14, 2005

I'm just to work with Fox Pro, and I am therefore puzzled with how to define the exact number of digits in a field in a table in Access. If I need 9 digits + 2 decimals in a number filed, how do I define that in design view?

Also, I need to know how to export a table into a text file, with a format without any spaces, and each record is divided with a new line. This an old IBM text format file.

Thanks, Torsan

View 1 Replies View Related

Update Query For Number Less Than 8 Digits Long

Mar 13, 2007

Hi there

Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out?


View 5 Replies View Related

How Can I Limit Number Of Digits Entered In The Text Box? Please Help!

Dec 14, 2005

Hi guys,

I have a text box, which requires a 8-digit number entry. I have wrote the code to check that the length is 8 and if it isn't a label will turn visible next to the field telling the user entry must be 8 digits.

This works for when i enter a number less than 8-digits but when i input a number with more digits as it does not fit into the text box it turns it to a scientific format value and when the code runs it shows the length is actually 8! And therefore the entry is valid!

I.e. when i input 123456789 the text box shows 1.23E+08 which is 8 charecters!

I dont want any error messages to pop up as i handle them by code and use labels to show the error message next to the problem field and i would like to keep this consistent. Is there any way i can do this by a function or a property in the table or form?

I appreciate any help/advice


View 2 Replies View Related

Forms :: Sort Alphanumeric Fields Where Number Of Digits Not Always Same

Mar 13, 2013

I want to know if there's a way to sort alphanumeric fields where the number of digits aren't always the same.

Example: I have the following: 2a, 10a, 3a.

Currently, it sorts: 10a, 2a, 3a.

Is there a way to get it to sort 2a, 3a, 10a without adding a 0 before 2a and 3a?

View 5 Replies View Related

General :: Unbound Lookup Textbox Limits Number Of Digits

Nov 7, 2013

I have a form with an unbound textbox. I want to be able to enter a sequence of digits and spaces (e.g., 02 950 4187); however, when I paste this into the box, I always have to delete the two spaces until the number is 9 digits long. Then it will accept the number and go look for the prize. How do I get the textbox to accept the number I paste in?

View 5 Replies View Related

Queries :: Run A Query That Count Number Of Digits In Each Field / How Many Of Each Exist

May 8, 2013

The field SECL DDI has the users phone number unfortunately over time these have been entered in different formats so there are 5 digits, 6 digits, 7 digits etc...Can I run a query that counts the number of digits in each filed and then tell me how many of each exist


4 digits 3412
5 digits 5000

View 4 Replies View Related

Grabbing Max Or Min Values

Feb 10, 2005

Hopefully this is an easy one. I've got a table with (for example) a list of books sold (field 1) and the price they each sold for (field 2). There are duplicates in both field 1 and field 2. I'd like to create a new table that has each book's name exactly once, and the maximum value it sold for. How can I do that?



View 2 Replies View Related

General :: Grabbing Web Information Into Database?

May 17, 2015

I have two third-party library programs that allow you to type in an ISBN and the software searches, say Amazon, and grabs particular missing data: author, cover jpg and summary etc, and imports the info to the program. I'd like to replicate this process with Access. If I can type in an author, title or ISBN to Access, I'd like it to search Amazon to gather and input the missing data to my assigned fields. Is this possible? Or am I stuck to typing in the information separately.

View 10 Replies View Related

Grabbing Oracle Login From A Linked Table

Apr 20, 2006

Not sure if this is possible but I have in my db a linked ODBC connection to a table. I use a Oracle 8 login to access the linked table. My question is can I capture the user login in ID somewhere in my table to show who is logged in? Thanks...

View 2 Replies View Related

Modules & VBA :: Grabbing Values From Search List Box

Jun 30, 2014

I was able to create a very user-friendly pop-up search form : {URL] .....

I would like to take it a step further... Now, I would like to grab the selected record ID from within one of the list box columns and use it in my SQL statement (to copy the record into a new one). Is there any way to reference a highlighted record value within a list box recordset directly and/or any workarounds?

I know one would be to grab the ID and insert it into the text box, just don't know what the coding references would be for this.

View 4 Replies View Related

Tables :: Grabbing Parts Of A TXT File To Add To A Table

Dec 5, 2013

I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.

I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated.

View 1 Replies View Related

Grabbing Values From A Table Based On Form Entry

Jan 5, 2006

In my database I have 4 tables for a small painting and decorating business.

These are:
tblCustomers, tblOrders, tblStock, tblPayments.

I have a form based on tblOrders to add new orders when they come in from customers.

In this form there are 3 important fields: "CustomerID" (Lookup to tblCustomers), "StockID" (Lookup to tblStock) and Quantity (Entered by user).

However, I want a calculated field that will be worked out automatically when the user is entering these details. The calculated field should go to tblStock and grab the "Cost" field.

However the main problem is specifying what price it will grab from the table. I want it to get the "Cost" where "StockID" = (the stock ID selected in the lookup). I then want to multiply the price by the quantity which the user has entered.

The control source should be worded something like:
= ([tblStock]![Cost] where [StockID] = StockID)*Quantity

but that isn't valid.

Could anyone point me to a piece of VBA or some way to get around my problem?
Many thanks for any help,

View 2 Replies View Related

Creating A Social Network Database

Aug 7, 2006

Hi everyone, I am hoping someone will be able to help me with a problem I have. I am undertaking a social network analysis and in order to do this I need to be able to create a matrix with the following format:

Group Person
J Smith G Fowles M Jones
X 1 0 1
Y 0 1 0
Z 1 1 0

I also need to be able to store and retrieve personal and group level details. Note that people can be in more than one group and groups can have more than one person. My problem is that the data has been gathered by another institution and is only available in the following (Excel) format.

Group Person Role Group Characteristic .....
X J Smith Strategist Level One
X M Jones Supporter Level One
Y G Fowles Financer Level Three
Z J Smith Strategist Level Ten
Z G Fowles .... Level Ten

Any idea how I can go about doing this? I know how I could do it if I manually entered the data, but because there are literally thousands of individuals (and a whole heap of groups too) I am hoping hoping hoping that I can do it using Excel and Access. Any advice would be incredibly appreciated.

Thanks everyone!

View 1 Replies View Related

Copyrights 2005-15, All rights reserved