I've seen this posting before, so I am guessing no one was able to answer
this. Here's my suggestion.
If you aren't concerned about users and passwords, then create an ID (number
format) in the table with the password (we will assign the ID to 1). On the
onclick event of the button enter:
if me.textbox = dlookup("[Password]","[Password Table]","[ID] = 1") then
Docmd.close
Dim stDocName As String
Dim stLinkCriteria As String
St DocName = "name of the form you want to open"
Docmd.openForm StDocName, , , StLinkCriteria
else
MsgBox("The password is no good!")
Docmd.quit
End if
> Hi all,
>
[quoted text clipped - 26 lines]
>
> Regards
dan.cawthorne@gmail.com - 22 Jul 2007 18:45 GMT
On 19 Jul, 19:40, meyerryang <meyerry...@discussions.microsoft.com>
wrote:
> I've seen this posting before, so I am guessing no one was able to answer
> this. Here's my suggestion.
[quoted text clipped - 50 lines]
>
> > Regards
Thank you meyerryang