Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2006, 10:30 AM
Registered User
 
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How can I suppress "paste errors" message?

When my user tries to paste incorrect data into a form,I get 2 messages. The 1st, I've been able to suppress & replace with my own message. The 2nd is "records that... was unable to paste have been inserted into a new table called paste errors". I know that it is error # 8511, but I can't figure out where it's happening so I can suppress it. Any advice would be most appreciated!! Thanks!
 
Old July 17th, 2006, 05:50 PM
Registered User
 
Join Date: Jun 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Would this work?

DoCmd.SetWarnings False
'..(your code or other macro events)..
DoCmd.SetWarnings True

Warren.







Similar Threads
Thread Thread Starter Forum Replies Last Post
How to suppress Excel error message idoni Beginning VB 6 2 February 19th, 2008 02:15 PM
IBM AS400 Message Errors to show them in .NET appl julenis SQL Server 2000 2 July 12th, 2006 01:45 PM
IBM AS400 Message Errors to show them in .NET appl julenis C# 0 July 12th, 2006 10:28 AM
Can't get errors to display with <html:errors> michaeldill JSP Basics 0 August 2nd, 2004 01:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.