ivchisholm
Last Activity: Oct 6 '11, 07:56 PM
Joined: Mar 24 '11
Location:
-
ok, Didn't see what NeoPa said, so going to try it out. I'll update with progress soon. -
Yes I said government to indicate that it was for a government agency. Private company computer applications are required to fit within certain rules (especially when dealing with privacy act data), while some government applications are allowed certain leeway if protective measures are used.
So I made sure to indicate government, as I have asked this question on other boards, and people answered "you're not supposed to use SSN"...Leave a comment:
-
Yes, unfortunately, this is to generate a primary key. I had a discussion about this with someone earlier today about this.
I say unfortunately, because, even though I understand the lack of uniqueness of last names and last four, it is necessary/possible for 2 primary reasons: (1) It will only have about 300 records at a given time, so likelihood of duplicating is minimal/negligible and (2) people in higher position want it that way,...Leave a comment:
-
I already have people in the database. I would like for this to populate the [EmpID] field for already existing records, as well as for new records as they are created.
Furthermore, I don't just want it to concatenate the two fields into the third field on the form...I want to store this within the [EmpID] field on the table, as well.Leave a comment:
-
AfterUpdate to populate field after data entry into two other fields.
I have:
tbl_Consolidate d with [LName], [FName], [Last4], [EmpID]
qry_EmpID with "EmpID: UCase([L Name]&[Last 4])"
frm_AdminData to fill in the last name, first name, and last four.
What I want is this:
After I fill in LName and Last4 on the form, I want it to automatically populate the EmpID query and fill in the form's EmpID field.
Example: I... -
My database, at any given time, contains data on about 100 current employees. I also maintain the data on past employees for a period of two years, so about another 150 to 200. After 2 years, they are deleted.
Thus, there will be a maximum of about 300 employees' data contained within the database. The chances of duplicated last 4 digits of SSN, as you stated, Stewart, is 1:10,000 and I don't know the "chances" of duplicated...Leave a comment:
-
Combine two fields into another field within SAME table
I have a table [Consolidated] which lists employees. The SSN used to be used as the primary key (it was legal, given it was a government database), but now I want to delete that field and replace it with a new primary key. I have fields [LName] [FName] [MI] and [Last4] among several others. [Last4] refers to the last 4 digits of their SSN.
I want to create a new field in the SAME table [Consolidated] that combines the [LName] and... -
Need help designing the structure of a form/subform
I have a database that has these two relevent tables: "Clients" and "WeighIns"
"Clients" has these fields: "IDClient", "LName", "FName" and other information not pertinent to this post.
"WeighIns" currently has these fields: "IDWeighIn" , "IDClient" (linked to "Clients" table), "WeighInDat e", "HT", "GoalWT",...
No activity results to display
Leave a comment: