necessary permissions

[Guest]

I have a database that is working fine with two exceptions. A form with 2
combos, a text field and an OK button is behaving oddly. I noticed that if I
entered the wrong value in the second combo and went back to change it, it
automatically closes down as if I'd clicked on 'OK'. Obviously there is no
code that is meant to do this and I don't know where to start to fix it.

The second thing is a button on a form that is meant to cycle through a list
of email addresses and send appropriate emails. Clicking on this gives the
error 'You do not have the necessary permissions to access the mdb object.
Contact your administrator ...'. The offending line seems to be set
db=current, which removes the error but also stops the code from working.

HELP!!

 

[John Vinson]

I have a database that is working fine with two exceptions. A form with 2
combos, a text field and an OK button is behaving oddly. I noticed that if I
entered the wrong value in the second combo and went back to change it, it
automatically closes down as if I'd clicked on 'OK'. Obviously there is no
code that is meant to do this and I don't know where to start to fix it.

If there's a button, there's code. Could you open the form in design
view, click the Code button on the toolbar, and post the code here?
There *must* be something in the code of which you aren't aware, or
which is doing something you don't expect!

The second thing is a button on a form that is meant to cycle through a list
of email addresses and send appropriate emails. Clicking on this gives the
error 'You do not have the necessary permissions to access the mdb object.
Contact your administrator ...'. The offending line seems to be set
db=current, which removes the error but also stops the code from working.

Try CurrentDb instead of Current.

John W. Vinson[MVP]