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.

Code:

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

View Replies


ADVERTISEMENT

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

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

Grabbing Last Six Digits Of Social Security Number

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

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

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 Alternatives?

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

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?

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

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?

Thanks

Tricia

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

Forms :: Hiding Certain Fields Based On Number Amount

Jun 13, 2013

I search around online and did come across much info on code to how to hide fields. But, the problem is I cant seem to find a way to hide a certain amount of fields based on a number amount.

example: Lets say I have a 12 text fields to show 12 months of monthly payments, and lets say a client only has a 3 payment term. How can I list 3 under installment field and have remaining 9 fields auto hide since they wont be necessary? this way I only see what applies and not additional text fields.

View 1 Replies View Related

Modules & VBA :: Locked Database - Login Security With Created Form

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

Modules & VBA :: Hiding File Tab On Ribbon Menu

Feb 5, 2014

moving my database from 2003 to 2010 and I'm wanting to use custom tool bars that I created in 2003 to run searches Doing this I hide the ribbon, including the 'File' tab is this possible?

View 1 Replies View Related

Modules & VBA :: Hiding Access Application - Min Max Buttons Gone

Aug 8, 2014

I did a search and found this thread, and the only problem i encounter is the min max buttons are gone though it was set up as both enable, how to show those buttons.

[URL] ......

View 1 Replies View Related

Max. Form Without Hiding Taskbar!!

Jun 18, 2004

Hi,

I have a form with command buttons on it (a menu) but I want the form to be full screen without hiding the taskbar. I can get the form to fill the screen with no problems, its just a matter of having the taskbar available to multi-task!!!

Also, is it possible to have a few forms open at once with each form appearing on the taskbar

i.e. START | Microsoft Access | Form 1 | Form 2

Thanks in advance!!!

Ty

View 4 Replies View Related

Forms :: Hiding 2nd Tab On The Form?

Jul 14, 2014

I want to password protect the second tab control page, so I'm using this code :

Private Sub TabCtl0_Change() Dim strInput As String
Dim ctl As Control ' Hide controls on tab until correct password is entered F
or Each ctl In Controls If ctl.Tag = "*" Then
ctl.Visible = False End If

[Code] .....

then to hide the controls in the first place, we do this using the Tag Property, and in the OnCurrent event of the form:

Private Sub Form_Current() 'Hide controls tagged with "*" until password entered.
Dim ctl As Control For Each ctl In Controls If ctl.Tag = "*" Then ctl.Visible = False End If Next ctl End Sub

The password request and events works fine but when prompting for the password it still shows the second page items and info. so basically it is not hiding the tab.. How do I fix this

View 8 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

Hiding Access Toolbar In Form View

Aug 24, 2007

Hi.

I have a widely used application in Access 97.

Anyway, some staff are not using the forms' menu buttons but are playing around with the Access toolbar (file, edit, et cetera).
The administrator wants me to either disable that toolbar or hid eit from view. Any ideas?

Russ

View 1 Replies View Related

Hiding Drop Down Arrows In A Printable Form

Aug 23, 2006

Hi

I am compiling a database of my fire system 'engineers reports' by creating a form that is identical to the one that I print and give to the customer.
I used combo boxes to look up system type details, from another table, after inputting the serial number. As these combo boxes can only produce one value I hid the arrows behind background coloured rectangles.

When I print the form the arrows disappear, the combo boxes expand by the width of the arrow and the last 2 digits of right-aligned numbers disappear behind my rectangles.

This form has over 200 controls (systems types, parts used numbers and quantities etc) and I need to print it on a single sheet of paper. I cannot afford to leave extra space between my controls.
The only thing I can think of is setting the visible property of my rectangles to screen only, which is not ideal.

Any suggestions would be greatly appreciated.
Thanks

View 4 Replies View Related

Hiding Subform Layout In Main Form

Nov 28, 2013

How to hide the layout of subform in main form?

View 3 Replies View Related

Hiding Close Button When Form Window Maximised

May 8, 2006

Hi,
Anyone know in microsoft access 97 is it possible to remove the close button (top right hand corner) when a form is maximised?
Thanks.

View 1 Replies View Related

Forms :: Hiding Parts Of A Form Or Making Them Greyed Out?

May 15, 2014

hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.

View 14 Replies View Related

General :: Hiding Subform Layout In Main Form?

Nov 28, 2013

How to hide the layout of subform in Main form?

View 5 Replies View Related

Modules & VBA :: Updating Or Adding Records To Form - Find MAX Of Number Portion

Jun 28, 2013

I want whenever I'm updating or adding records to my form, the ID automatically take the value of the previous ID and increment it by 1.

The field type is text (mixed with number) - PM0000000.

I've done some research, what I understand is that I need to:

-do a lookup and
-find the MAX of the number portion.

Name of form - Payment
Name of table - Payment
Name of field - payment_id

I tried these, but to no avail...

Private Sub payment_id_Click()
payment_id = DLookup(("[payment_id]", "Payment", "[payment_id]=Forms![Payment]![payment_id]-1")payment_id + 1)
End Sub

[Code] .....

View 8 Replies View Related

Modules & VBA :: Change Number Of Decimal Places Based On Value In Textbox On Main Form

Apr 11, 2014

I have a subform that displays doubles in a textbox as fixed with 4 decimal places as default. I have been trying to change the number of decimal places based on the value in a textbox on the main form. I have tried this:

Code:
Forms![Main Form]![Holder_subform].Form![Final PCT].[DecimalPlaces] = CByte(Forms![Main Form].Numdecs)

where [Final PCT] is the textbox on the subform containing the decimal number and Numdecs is the textbox on the main form containing the number of decimals I want to use. I want to implement this Form_Current sub.

View 2 Replies View Related

Modules & VBA :: Count Number Of Times Mouse Left-clicks On Active Form

Jun 14, 2013

I would like to update a txtbox with a simple int count of the number of times a mouse is left-clicked while on an active form. How do I do this?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved