[Access 2007] Runtime Error 3219

S

Steve B

I'm using the basic Password Challenge from this MS Bulletin

http://support.microsoft.com/kb/209871

I have a FE \ BE based database but I'm Getting the error "3219" after the
user has pressed submit.

The Password form code is

If IsNull(Forms!frmPassword!Text0.Value) Then
MsgBox "You cannot enter a blank Password. Try again."
Me!Text0.SetFocus
Else
MyPassword = Me!Text0.Value
DoCmd.Close acForm, "frmPassword"
End IfThe error is not present if I load the form and submit on
the backend table. I've never had it before as the database has just been
split due to requests from other users to access the database.

Now I'm slowly learning VBA so does anybody have a Solution and a basic
explanation as to why it happens?
 
F

franklin

Steve B said:
I'm using the basic Password Challenge from this MS Bulletin

http://support.microsoft.com/kb/209871

I have a FE \ BE based database but I'm Getting the error "3219" after the
user has pressed submit.

The Password form code is

If IsNull(Forms!frmPassword!Text0.Value) Then
MsgBox "You cannot enter a blank Password. Try again."
Me!Text0.SetFocus
Else
MyPassword = Me!Text0.Value
DoCmd.Close acForm, "frmPassword"
End IfThe error is not present if I load the form and submit on
the backend table. I've never had it before as the database has just been
split due to requests from other users to access the database.

Now I'm slowly learning VBA so does anybody have a Solution and a basic
explanation as to why it happens?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 3219 1
How to change a password in a form? 3
error 3219 Invalid Operation 0
Eror 3219 Invalid operation 8
Exit Password Prompt Option 10
enable disable 2
Startup Password to access switchboard 8
Delete record 3

Top