@mrrayj: "I would like to import a single unique record from excel based on a 6 digit 
number search and append it to my table. Anyone know the best way to do this?
Thanks
Ray J
Brooksville, Florida"
    @arvinm: "Rather that a myriad of VBA code for a simple task, I'd consider an lookup 
in Excel, then a copy/paste. If this is something that must be done 
frequently, especially by untrained staff, I'd look at the Excel automation 
code at Ken Snell's Access/Excel pages:
<url>
Arvin Meyer, MCP, MVP
<url>
<url>
<url>
"Raymond" <email_address> wrote in message 
news:<email_address>
<quote>"
    @mrrayj: "its appears it appending as many records as there are in the source table.
I delete some records and the next query wants to add as many records are in 
there. Not sure why?
Ray J
<quote>"
    @mrrayj: "The code in my append comm button...
I'll check back monday, thanks again, Ray
Private Sub Command11_Click()
On Error GoTo Err_Command11_Click
    Dim stDocName As String
    stDocName = "Query3"
    DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Command11_Click:
    Exit Sub
Err_Command11_Click:
    MsgBox Err.Description
    Resume Exit_Command11_Click
End Sub
Ray J
<quote>"
    @mrrayj: "I found the err sunday night so thanks. The unique records I changed to yes 
in query properties and that seems to be the trick. 
I still have not figured why my form fields do not show the record I choose 
but thats a job for monday, thanks again...
Ray J
<quote>"
    @dg: ""Raymond" <email_address> wrote in message 
news:<email_address>
<quote>
It's not clear to me what you've done to make the fields show the 
information from the selected record.  What is the RecordSource property of 
the form?  what is the Row Source property of the combo box?  What are the 
Control Source properties of the fields on the form, that you want to show 
data from the selected record?
Dirk Goldgar, MS Access MVP
<url>
(please reply to the newsgroup)"
    @jvinson: "<quote>
Please post the SQL view of query3. My GUESS is that you're joining the target
table to the source table (hence the multiple records); the append query
should be based on the linked Excel spreadsheet (only), not on it joined to
the table.
             John W. Vinson [MVP]"
    @mrrayj: "At one point I had these tables related but I took that out, the fix I found 
was marking a property unique. Going back to my earlier problem with field 
display and will post what those sources are...
INSERT INTO vrc ( UBL, NAME, PHONE, SNAME, OTHERUBL )
SELECT DISTINCTROW residents.num, residents.name, residents.phone, 
residents.sname, residents.special
FROM residents, vrc
WHERE ((([Forms]![APPEND]![Combo8])=[residents]![num]));
Ray J
<quote>"
    @mrrayj: "form name is append
combo8 row source = residents.num & residents.name
fields control sources are Residets.name ; addr101; addr102
The fields are showing the first record in the residents table no matter 
which record I search, but it is appending 1 record and the right record, so 
not all dome and glome...lol 
Ray J
<quote>"
    @jvinson: "<quote>
That's your problem.
You're combining *EVERY SINGLE RECORD* in residnets with *EVERY SINGLE RECORD*
in vrc, and appending the resulting records into vrc.
Just remove the ", vrc" from the FROM line.
You want to append INTO vrc, but FROM residents. You con't need to append from
vrc into vrc, and your attempt to do so is causing the errors and the
duplicates.
             John W. Vinson [MVP]"
{'source': 'USENET', 'other_information': '{"reply_count": 9, "forum_name": "microsoft.public.access.gettingstarted.20140624.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}