p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Duplicate Error Message Stopping it (http://p2p.wrox.com/showthread.php?t=26109)

ru1 February 25th, 2005 03:39 PM

Duplicate Error Message Stopping it
 
Does anyone now how I can stop the error message from appearing when I am removing duplicate entries. I am populating a temp table in a form and it works great. But, for every user, I get the message about not being able to append so many records.

Thanks,

Ru1


dartcoach February 25th, 2005 03:51 PM

How are you populating the table? Is it the recordsource, or are you using code to insert records?

dartcoach

yami56 February 25th, 2005 04:53 PM

i dont know what you are exactly look for but here is some solutions
docmd.setwarnings false
or another example
Private Sub cmdclick_Click()
On Error GoTo Err_cmdclick_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "someform"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdclick_Click:
    Exit Sub

Err_cmdclick_Click:
rem here you can put what ever you want do show
MsgBox "There was a problem while opening your form",vbinformation,"some title"
    Resume Exit_cmdclick_Click
End Sub


Best Regards,
Hamed Gholamian


All times are GMT -4. The time now is 11:33 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.