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 Replies
ADVERTISEMENT
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.
Code:
'Hide SSN
Dim strLSSN, strSSN As String
strLSSN = Right(SSN, 4)
strSSN = ("***-**-" & strLSSN)
Me.SSN = strSSN
View 1 Replies
View Related
Jun 11, 2007
Hi,
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
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?
Legal?
Voluntary?
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.)
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=3&Number=1001301&page=0&view=collapsed&sb=5&o=&fpart=1
http://www.access-programmers.co.uk/forums/showthread.php?t=93569
http://www.accessvba.com/forum/showthread.php?t=17057
Regards,
Chris.
View 5 Replies
View Related
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
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?
Thanks
Tricia
View 3 Replies
View Related
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
Mar 17, 2006
HI
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?
//Mikael
View 3 Replies
View Related
Aug 9, 2005
hello,
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!
G
View 1 Replies
View Related
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
Feb 25, 2007
Would anyone know if it is possible to mask and input box with a password mask (*****)
my code is simple:
StrPswd = InputBox("Enter Password", "ENTER PASSWORD")
I was trying to mask the entry in ****** when the user enters the password.
Any ideas ??
Thanks
View 2 Replies
View Related
Apr 16, 2005
Hi Gurus.. :D
Need some wisdom.. ;) I got code behind buttons on my main switchboard form to enable passwords on the buttons.. I use the following code...
Private Sub Option2_Click()
On Error GoTo Err_Option2_Click
Dim stDocName As String
Dim stLinkCriteria As String
Dim Password1
Password1 = InputBox("Please Type the Password", "Password Prompt")
If Password1 = "password" Then
stDocName = "Main Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Else
End If
Exit Sub
Exit_Option2_Click:
Exit Sub
Err_Option2_Click:
MsgBox Err.Description
Resume Exit_Option2_Click
End Sub
My issue is that I need to mask the password, I know if it can be done by other methods, such as creating an inputbox on main form and setting the input mask property to Password and useing the button to make this visible.. etc.. However, a little bit of a mess.. the above code is simple and straight forward.. Is there any VB code that I can enter for an input mask for the inputbox :confused:
Hope you can help.. Thanks.. :D
View 3 Replies
View Related
Jul 21, 2006
Hi,
I have a text box where users input a person name as it appears on their bank account. This text box can only take alpha characters and no numbers or other characters except the "&" sign.
Please can some one help in to how i can mask this text box to only take text and nothing else, not even a combination of text and numbers can be accepted, please help!
Thanks in advanced!
View 1 Replies
View Related
Apr 22, 2014
Is it possible to mask data in a report? I have a report that contains a field for an ID number. Depending upon who is receiving the report only a partial ID number can be shown.
Example: Instead of showing ID#: 123456 the report can only show ***456.
View 3 Replies
View Related
Jan 12, 2014
I have the following expression as part of the recordsource for a report:
Is it possible to put a mask on the output of [phone1]? Ideally something like: (716) 555-5555 x1234
Code : phone1: [ContactNo1] & " " & [ContactNo1_ext]
View 10 Replies
View Related
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
Mar 26, 2007
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
View 4 Replies
View Related
Jan 12, 2006
I have a form used for holding purchase information - the purchase order number, date etc. and the subform holds the order line items. Each order line item in the subform has a RECEIVED field check box on it, to denote when the item has been delivered.
I need to allow the storeman access to the form/ subform but only allow him to change the subform 'received' field to say that the goods have been delivered. All other fields on the subform should be locked - How would I do this?
It is not sufficient to disable controls in the subform in the Form_Load() event - this does nothing.
View 1 Replies
View Related
Jan 12, 2006
I have a form used for holding purchase information - the purchase order number, date etc. and the subform holds the order line items. Each order line item in the subform has a RECEIVED field check box on it, to denote when the item has been delivered.
I need to allow the storeman access to the form/ subform but only allow him to change the subform 'received' field to say that the goods have been delivered. All other fields on the subform should be locked - How would I do this?
It is not sufficient to disable controls in the subform in the Form_Load() event - this does nothing.
View 1 Replies
View Related
Sep 8, 2006
Hi there,
I have a number of forms which I wish to password protect. Currently I have done this but the password is hard coded. I need to change this so that I can create a smaller like control panel form that allows some to change the different passwords.
My current problem is changing the hard coded passwords to use a variable instead. I thought to use a Public variable which is in a normal module (not class) however I am a little stuck as I dont know what would be the best way of setting and storing the value of that public variable.
Could anyone give me some advice please?
View 5 Replies
View Related
Dec 15, 2004
I have a table
ID, UserName, UserPassword, Level
and I want to create a form that once you log in as the admin you can create new users give them passwords which they can change later and to select which forms and table the have access to and how they can access them (can the just read the table/form or can the read/write the table/form)
Not sure how to configure level which is attribute to select which forms and table the have access to and how they can access them (can the just read the table/form or can the read/write the table/form)
View 3 Replies
View Related
Feb 20, 2008
Hi all.
Once upon a time I stumbled upon an example form or selection or forms that I merged that allowed the admin user to add and modify user accounts that were set up using the User-Level Security wizard. The form showed the user accounts and group there each were in both of which could be changed or added to as weel as passwords changed or set without going through the full toolbar selection method.
I have since deleted this from my computer in one of my random clean ups but have since been asked for it again. Does anybody have any knowledge of this form or where I might be able to find it?
Cheers
View 2 Replies
View Related
May 19, 2006
Hello,
I have a db that I want to password, so that anyone pressing either F11 or holding shift down at the start, will be prompted with a password.
.....But, I want the user to be able to see the start-up form and associated forms without having to enter a password.
Is this something that is possible to do in Access97?
I have searched the forum for an answer, but can't find anything.
Thanks, Steve.
View 4 Replies
View Related
Jun 18, 2013
I am looking to lock my database until the user puts in the correct credentials.
I have already put the form on Pop Up and Modal. They can still select the "X" in the top right of the window.
View 1 Replies
View Related
Jun 24, 2013
I am relatively new to Access and VB. I am trying to create a log-in system that assigns a security clearance to each user and then restricts access to certain forms and reports based on security clearance. Right now, I have set up the log-in system - that seems to work fine. But when I try to lock the form based on security clearance, I get the 2450 - Form Not Found - error.
The code I am using on the form is as follows:
Private Sub Form_Open (Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 1 Then
MsgBox "You do not have access to this form", vbOkOnly
DoCmd.Close acForm, "formname"
EndIf
End Sub
View 1 Replies
View Related
Oct 26, 2011
Is it possible to do this through vba. If security is setup for all the tables and a user goes in and creates a new table, can that table have security applied to it using code?
So maybe the creator of the table has read/write privileges but everyone else only has read only.
View 3 Replies
View Related