Unique Names in 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?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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;
'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?
Some of the column names will be longer than 64 characters which is the max for Access.
The table will eventually be exported to excel with a wide and tall first row.(clients request)
I've shortened the names to a 2 digit code that after moved to the first row, will be updated with the longer names.
The table doesn't have static names and will be generated on the fly depending on what parameters the user selects.
In another table2 I have only one column with unique company name (49,000).
what I need is that I want the full info of in table2 from records.raw table.
As records raw is consisted of multiple contacts when I am trying to match with company names it is showing me all the companies.
main phone, city, state etc. which are available in records.raw table) from records.raw table?
For instance say I have a table that consists of three fields, A, B and C as below.
A B C
1 2 3
1 1 1
1 2 2
Now, say I create a new table with fields called X and Y, as below.
What I want to know is this:
If I make the X field in Table 2 a lookup of the B field in Table 1, how can I make the lookup return only the unique records in this field?
(I.e. The lookup in the X field of Table 2 would only show (2,1) and not (2,1,2).
When I create a report to display the data, it displays it as 1,2,3.etc., instead of the names separated by a comma.
What do I need to do to display the names