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 RepliesHi,
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!
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:
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.
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 RelatedI 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
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
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
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:
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
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.
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!
I am working in Access 2000. There is a table in the database that is maintained by two employees. All other employees should only be able to view and query the table. Is there a way to do that without having them log into Access?
View 5 Replies View RelatedIs there a way for people to be locked out of a table but still access the table through forms. I tried using the user security but i couldn't access the tables through the forms. So they can't change the table. But can add and modify through forms.
View 3 Replies View RelatedI'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)
I'm on a project to build a database for the stores in our area. Things like managers, banks, and partners obviously should be in seperate tables. Most of the information though, seems to belong directly in a table of stores. Basically each record is a store and there will be very many attributes per record (about 30+). Some attributes only relate to certain departments and only someone from that department should see that info. If I broke up the big table into smaller tables it would be the same information but every table would have to have the store number to link it all back together. From a design standpoint this is bad because the store number is redundant.
So my question is, is it a good idea to split up the table for security purposes?
My main concern is security, I can take a hit on performance or storage.
Hi,
Not sure what section this should go in but it vaguley relates to access and VBA so it's in here.
After a complete nightmare trying to do some decent graphs in ASP i decided to try using excel linked to my Access DB.
I've set up my pivot tables in Excel to link to the Db on the webserver. The user can open the workbook from the website and view the reports and graphs.
The problem is the database contains sensitive data for more than one organisation.
I have a workbook for each organisation selected dynamically when the user logs in to the webpage.
I've set a parameters in the pivot table querys so that all querys will be filtered using the users organisation code.
Trouble is you can access the data source of the pivot table through the wizard and ammend the parameter to view other organisations data.
Is there a way of preventing the user from accessing this feature i.e locking the wizard?
Thanks
TS
Can someone tell me how to go about adding security to a field in a linked table so that only certain people can access and modify the information? I am using Access 2002. I also wonder if someone can tell me how to modify a field in a linked table? I have tried altering and saving the changes, but it won't save them because it's a linked table. Thank you in advance to anybody who can help me out here!
View 2 Replies View RelatedHi,
I'm building a DB where I have multiple users. I would like to have all data in 1 table but only give access to records created by the individual user. Is this possible?
Alternatively, if each user has it's own table, how can I report on the sum of all tables.:confused:
Cheers,
Rene
I have a dropdown list of reports that is supplied by table. I also have listbox that are populate by another table. I want to be able to run the reports from the dropdown and from the listbox ....whatever the selection is to pull that info from the report and display.
View 3 Replies View RelatedAnyway, I would call myself intermediate level at best with Access. I never expected to have to do so much with it, but when my bosses found out I could do Access basics, they began demanding more and more.
I manage an EMR from which a datapull occurs on discharge to various access databases.
They wanted me to add a triage patient data pull to track what procedures are being done to triage patients. So I built a database with the following 2 tables.
tblTriageVisits and tblTriageProcedures
tblTriageVisits has the following fields
-Patient ID
-Export Time
[Code].....
The tblTriageVisits stores all the patients triage visits. The other table stores what was done to each patient on those visits
It should also be noted that this EMR exports times in number of seconds since 12/31/1975, so TimeProcFMS is the number of seconds since that date for example.
The pulls work great and the duplicate record elimination method works great.
I have to design a couple of different reports based on this data and one in particular has pretty much flumoxxed me.
I need to make a report that lists each patient by date they were there and then shows what was done to them. I have tried several different variations of this as both queries and reports. The report breaks down when I try to get it to show just those procedures that would be for that triage visit. I got to the point where it would group by day and then sort the patients alphabetically. Then I added in the visit fields. And it would put all triage procedures for that patient from all their visits in each visit.
So, I was like great, let me filter out those that don't occur between the two dates, admission and discharge
I used the following two formulas (the first one on the procedure name field the second on the procedure date field)
=Switch(DateAdd("s",[TimeProcFMS],#12/31/1975#)>=[Admission DateTime OB DateTime] And DateAdd("s",[TimeProcFMS],#12/31/1975#)<=[LD Discharge Date/Time DateTime],[Procedures FMS])
=Switch(DateAdd("s",[TimeProcFMS],#12/31/1975#)>=[Admission DateTime OB DateTime] And DateAdd("s",[TimeProcFMS],#12/31/1975#)<=[LD Discharge Date/Time DateTime],DateAdd("s",[TimeProcFMS],#12/31/1975#))
And they work, sort of. They do eliminate those procedures that occur outside of the date range I am looking for. However, the access report still leave spaces in the report where the filtered out items would be.
Did I approach this problem correctly? And if so, how do I get rid of those spaces?
Note, I can read and mostly understand SQL, but am not comfortable working in it yet. And the Access SQL box gives me a headache, it is so jumbled up.
I have a basic database design, well I think so anyway. It only has two tables:
1. tblClientInfo
2. tblNotes
Basically each client has multiple notes/comments that can be linked to its record, hence the tblNotes table. The two tables have a one-to-many relationship, being that each customer can have many notes.
I then have two forms:
1. Claims Loss Form
2. tblNotes_DatasheetSub1
So I can enter multiple notes for each customer. The problem I am having is with the report output. It wants to print every note (record) that is linked to the customer. I just need it to print the most recent note for each customer (It would save a lot of wasted paper).
Example of a print out of what it is doing:
John Doe - 123 Easy St - Notes 1 (Most Recent Note)
John Doe - 123 Easy St - Notes 2 (Previous Note)
John Doe - 123 Easy St - Notes 3 (and so on...)
It is printing duplicates of the same customer by adding the additional notes for that same customer on a new line.
How can I tell it to only print the customer one time in the report, and most importantly, to only use the most recent note that is linked to the customer?
I tried using DMax("NoteDate","tblNotes"), but this only returns one customer with one note. I need it to do that for each and all customers.
I have successfully ran a subquery (two queries with one linked to another) by following detailed instructions from this page I found: [URL] .... It works, but the problem is it only shows the latest date for each note, not the actual contents of the note. I feel so close with this option, but so far at the same time.
The TOP n records per group looks promising that I found here: [URL] ...., but I honestly don't know how to implement it correctly in my SQL. I am very much still learning Access and apparently have stumbled into something that is much more complicated than I had originally imagined. I just assumed I could filter the duplicates out, or tell access to print the last or most recent note record for each customer.
I've been trying to figure this out, but it looks like a no go.
I wanted to give my users the ability to create/modify queries, but NOT create/modify tables.
Does anyone know if this is possible in Access 2002?
Thanks,
Earl
I have an imported table that I created a form for (containing 400+ entries). I created a subform on it for a new table that I will be entering information to tie in with the imported form.
However, when I try to create a report, the report won't acknowledge any of the information. It's all outlined in the SQL, but nothing appears.
I did discover, though, that if I create a new entry on the imported table, that information appears on the report, but nothing for the existing data that was imported.
Please help!!!!!
I am creating a report which is about 200 pages and would like to add a table of contents for each category i have with page numbers, however i have googled and tried many different things but to no avail and what it the correct way or even showing me on a sample database.
View 2 Replies View RelatedI am trying to get some totals on a report, but the totals are from a table that the form is not related to as such.I am trying to get a textbox to show how many records in a query match the given criteria and show me the number of records that match. I was thinking DCount, but not sure if it will work?
I have a query called 'VehiclesAllocatedToday' which is already filtering records to show only those allocated today. On a report that shows Unfit Vehicle (and is related to a different query), I would like a text box that shows me how many records there are where the text "Type One" is in the TypeRequired field.