DUPLICATE RECORD FAILURE 1

[88lbr]

It was either after a recent W2K OS upgrade or LAN profile reset the duplicate record command button in my form stopped functioning. My record is sent to a "Paste Errors" table.

 

[quest4]

88lbr, the LAN profile should not have had any effect, unless computer names and address were changed, on your dbase, and niether should have an OS upgrade. Was Access upgraded in the process? Check your tables and make sure the fields are still set to no dup's. Also recheck your relationships and last of all recheck your command button code. Hope this is a little help to you. Good luck.

 

[willir]

88lbr

I have seen some of the recent patches - 2K, Office, IE - create some quirkiness. Although I suspect a lot of the "fixes" are for registry entries, some of the updates such as SP4 for Windows 2000 are pretty significant. (I am not too sure how far back you go.)

Recreate the command button and see if that helps. I hope it is this simple.

BTW - As noted in a previous post, the new MDAC 2.8 does not include many of the associated modules where the user had to reinstall plug-ins to resolve an ADO issue.

Richard

 

[88lbr]

Below is the code for the commmand button created using the command button wizard. Does it look OK?
Would converting from ACCESS 2000 to 2002 cause this?
____________________________________________________________
Private Sub Command582_Click()
On Error GoTo Err_Command582_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

Exit_Command582_Click:
Exit Sub

Err_Command582_Click:
MsgBox Err.Description
Resume Exit_Command582_Click

End Sub

 

[catrionaob]

Hi, i'm having a problem with multiple select list boxes on my form. I need the user to be able to select more than one option which i've done using the multiple select option but my problem begins when i try save these multiple selects back to the bound table. It will not save multiple entries in one field i.e. cause duplication.

Is there anyway around this other than creating 6 different fields in my table? Would greatly appreciate any help anyone can give me

 

[hkaing79]

catrionaob-
Does the table have to be bound? I'm not understanding what you're trying to do. Could you elaborate?

It seems you have 6 fields in a table that is bound to a form. And you're using one listbox to enter data into these 6 forms? Also, how exactly are you going about saving these forms?

 

[GingerR]

catrionabob you might have made this a new post instead of attaching it to one from a year ago

so is what you are saying is that you have a list box and a user can select many rows, and you'd like them to hit a button and have that data written to your table? List boxes are handled differently than combo boxes or text boxes. What is your code so far?

 

[jpstroud]

catrionaob... make sure that you don't have a Duplicates Not OK index on that particular field and that you do have a (separate) key field for the bound table.

 

[catrionaob]

GingerR - sorry i'm new to tek tips and added the post onto end of this old one by mistake. jpstroud - that's solved my problem, should have checked that myself! thank you