Recent content by accessaccess

Due to having a linked table is there an alternative way to prevent duplicates?

do i input that statement in the 'control source'? would the following work? =IIf(DCount("[EMPID]","Updated Headcount","[EMPID] ='" & [Me].[txtEMPID] & "'")>1,"Error duplicate","Yes")

Hi Just saw your post before I posted my other post, what does Me mean? what does records mean?

What does DCOUNT("COLUMN", "TABLE", "CELL1 =" &[CELL2]) what does the bold and underline mean? is that saying that the CELL1 is equal to the value in CELL2?

Plog Could you assist in helping to write the correct statement so i will be using the txtEMPID in the expression? what do the [], !, " ", mean when they are used in an expression?

Hello I have a TABLE with the following data: - EMPID - LASTNAME I have a form with the folliwing data: - text box for user to enter EMPID, txtEMPID - LASTNAME I would like to create a button to initiate a query to do the following: - once the user enters a EMPID in the form, it will...

For queries, I can create a quiery to search for duplicates based on the field in the table, but how would I insert the query result into the form so it would run and search based on what the user entered? ultimately i want to provide a Y/N if the user's EMPID input is already in the EMPID table.

Also since I have a linked table in Access to the SharePoint site I cannot make the EMP_ID unique and index without duplicates. I would have to change in the source data on SharePoint which 2007 unfortunately does not allow. Is there a work around?

EMP_ID is unique, but it is not 'unique' in Access, poor wording on my part. The EMP_ID is like a SSN for an employee. there are some positions that are open and have not been filled and as a result they are blank and duplicate. You mentioned the trying beforeInsert, how would i...

Cronk Yes, there are empty and duplicate values so the EMPID is not a primary key. Would it be possible if... In the form I had a EMPID duplicate box (EMPID_DUP) which displayed a 'Y' OR 'N' i had an input text box where the user would type in the EMPID The EMPID_DUP did a DLOOKUP...

Cronk thanks for the quick response... How would i assign the EMPID as a primary key? i am assuming i would adjust my table settings? if i had open resources that were blank would this cause the EMPID field to yield errors? I was thinking if i had a cell in the form duplicateEMPID and...

Hi everyone we are working on an Access (2007) database that is on a SharePoint Site (2007). Currently the form is operational, but there is one last thing that would be nice to have. The table is "Updated Headcount" which contains "EMP_ID" which are unique numbers stored as text. In...