sql Update confirm message

[spasticus]

hi,

I'm doing a login thing for my database and i need to store whether a user is logged in or not.

at the moment im using UPDATE in VBA on my login form. the problem is when i login i get a message box saying im about to update a field, am i sure.

Is there a way to stop the message from appearing? if not how else could i do the login?

thanks in advance for your help.

 

[tehNellie]

You can turn off all confirmation messages as an option in Access, but I really wouldn't recommend it. I do view, having switched it off before, as the last line of defence before you muller your data. I know I should know better, but the live tables and the development tables look very similar when you've got 4 or more databases open.

If you're using VBA you can wrap DoCmd.SetWarnings False and DoCmd.SetWarnings True around your query to supress the warning only for that query.

 

[spasticus]

thanks for the quick reply - that worked fine thanks

 

[spasticus]

thanks i already did that

 

[tehNellie]

I was a little unclear in the original post, but if you haven't, I strongly recommend that you set DoCmd.SetWarnings True in the immediate window within VBA, otherwise you'll have supressed all Access Warning messages until you close the application.

[edit] Sowing seeds of confusion trying to clear things up