Topics Search

Unique Names in Table

Unique Names in Table
Views: 0
I have a table with and ID field that is is the primary key field. I have FN and LN fields in the table.

I have a form to add new names to the table. The form has FN and LN fields and a field to combine the fields into LNFN. What code can I use to make a message popup and tell the user thatthat name already exists in the table and ask the user if (Yes or No) he/she still wants to add the name?
Sponsored Links:

More topics

 

2 data sets of unique names

Preview
Imagine 2 lists of unique names -
They overlap because some of the names in the first list are also in the second.
1) Delete the names-in-common from the second list?
2) Make a record of which names these are
 

Similar Names

Preview
My table contains a list of unique last names. I want to write a query that will return all names who have the same first (5) characters. For example:

Smith
Smithe
 

Unique Values via .rowsource

Preview
I have a form which has a few dropdowns. Two of these are firstName and lastName. What I was doing previously was when the form was opened, copy all last name (who had transactions on them) values from the contacts table into a table (indexed no duplicates).

This would automatically give me unique values. The problem is that I added functionality to view two different types of datasets (canceled and uncanceled data).

Each of these tables will have different names so I am now getting the names via the rowsource line. When the radio button is clicked to viewcanceled, I change the rowsource from vba.

The problem I am having is getting unique values again. Right now if there are two smiths, there are two entries in the lastName dropdown for Smith.
 

Finding similar names between two tables.

Preview
I have two tables linked by Name. The names are not unique and may have Corp., or Corp. or Corp in one table and Corporate spelled out in another table. Some may have a hypen separating names etc.

I would like to create a query to see all the records and fields from the table on the left and only a few fields from the second table on the right if the names are similar and state matches.

I was able to create the query but my results are for the exact matches on the name.
 

Inner join

Preview
I have two tables with names and amounts :
Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1

I created an inner join between the names on both of these table as i need the amounts from tble 1 with the names of table 2. Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2
this was code used to find the similar names on tbl 2 with amounts from tbl1...
 

Adding multiple records in subform

Preview
I have one Table titled Audits.

From this one Table I have created two forms Audit (main) and SubAudit (Sub).

Main Form-field names are Unique ID and Date.
Sub Form-field names are Call Date Correct, Correct Part, and Correct Description.

On the main form I have a command button that opens the subform to enter records.

The problem I am having is that when I enter multiple records under the subform it is not entering the Unique ID and Date for all the records entered in the subform.

Here is what I am trying to accomplish if the Unique ID is 106 and the Date is 12/2/2008 and I click the command button to open the subform and enter 4 records I want the underlying table to reflect Unique ID 106 and Date
 

inner join question

Preview
I have two tables with names and amounts

Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1

I created an inner join between the names on both of these table as I need the amounts from tble 1 with the names of table 2

Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2

this was code used to find the similar names on tbl 2 with amounts from tbl1

SELECT tbl2name, tbl1Amount
FROM list2 INNER JOIN list1 ON tbl2name = tbl1name;
 

Creating unique ID but not for duplicate text rows

Preview
I have an excel spreadsheet with about 20 fields. 2 of them include first_name and surname and I want to create a unique ID for each separate entry, however I don't want the same names getting different unique ID's
 

VBA Question on Comparing fields and updating

Preview
I have two tables - first table has a column with file names, a column with file names after being renamed and a status column.

Second table has a column with new file names.

(I have a directory that I renamed each file with a unique name 0000001.tif, 0000002.tif, etc.)

All I need to do is create a button on a form that will look at table 2 and if the file name is there it will update the status column on table 1 (I have all 0's in it and if the file nameon table 2 is there then the status field will change from 0 to 1).
 

Cannot get values for a Combobox..

Preview
I am trying to retrieve the unique names from a table into the combobox on a form. I have the attached code for the command button on the form.

'Invalid use of Null'.

if I use another table for a string value for the same recordset, the code works and the combobox gets populated with the unique names of the field selected.

I tried to retrieve the values for different fields from the table tblPlants, but I get the same error.
It appears that I cannot populate the combobox with any of the field values from the tblPlants. But the values are not Null - by using the code line for the MsgBox (msg), I am able to see the values in the MsgBox.
Or is it some other criteria I am missing?