By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

appened rows

P: 20
hello,
i'm tyring to add data to appened query using button but i've this message:
"you are about to appened 1 row (s) ". so how can i solve this problem as sooon as possible please.
Sep 8 '07 #1
Share this Question
Share on Google+
3 Replies


Jim Doherty
Expert 100+
P: 897
hello,
i'm tyring to add data to appened query using button but i've this message:
"you are about to appened 1 row (s) ". so how can i solve this problem as sooon as possible please.
Immediately before the command line in your code that fires the append query type in this line

DoCmd.SetWarnings FALSE

then immediately after the command line

DoCmd.SetWarnings TRUE
Sep 8 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
And make absolutely sure that you add

DoCmd.SetWarnings TRUE

after the fact, as Jim has indicated! Otherwise no warnings will be issued until the app is closed and re-opened again, and you might miss an important warning, as opposed to one that is merely annoying!

Linq ;0)>
Sep 8 '07 #3

P: 20
Immediately before the command line in your code that fires the append query type in this line

DoCmd.SetWarnings FALSE

then immediately after the command line

DoCmd.SetWarnings TRUE

it's work very good thanks alot
Sep 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.