removing option for ammend row

[Chris]

Hi All. When I use an Access DB on my machine and I press the Save button,
a message box appears asking me if I want to add the record. This is the
way the DB should work.

When I load the program onto another machine and I press the Save Button, I
get a msg saying, "would you like to append the rows" (or some thing
similar). I've been told I can turn this off, is this true?

Any Ideas?

 

[John Vinson]

Hi All. When I use an Access DB on my machine and I press the Save button,
a message box appears asking me if I want to add the record. This is the
way the DB should work.

When I load the program onto another machine and I press the Save Button, I
get a msg saying, "would you like to append the rows" (or some thing
similar). I've been told I can turn this off, is this true?

Any Ideas?

Yes; in your Save button code you can add a line

DoCmd.SetWarnings False

before you run the append query (or whatever it is that's adding your
data).

It would be very wise to add a line

DoCmd.SetWarnings True

after the query is executed; otherwise ALL warning messages throughout
Access will be turned off for the rest of the Access session.

John W. Vinson[MVP]

 

[Guest]

Hi Chris,

You're running an append query which is an action query. This can be turned
off by going to "Tools", "Options", "Edit/Find" and in the "Confirm" box
uncheck action queries.