appened rows

[zaiena]

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.

[Jim Doherty]

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.SetWarnin gs FALSE

then immediately after the command line

DoCmd.SetWarnin gs TRUE

[missinglinq]

And make absolutely sure that you add

DoCmd.SetWarnin gs 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)>

[zaiena]

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

DoCmd.SetWarnin gs FALSE

then immediately after the command line

DoCmd.SetWarnin gs TRUE

it's work very good thanks alot