if with "or" statement

[slimjen1]

Hi all. Using access 2007. I have some generic code for users to logon to a database using their windows api. The only way I know to retrict a user to a form or to a record only they own is on form load.

If GetNetworkUserName <> "jdoe"  or <> "janedoe" 
then 
msgbox "you don't have permission to access this form

It only half works. If <> "jdoe" works but <> "janedoe" doesn't.
How can this code work with or?
Thanks

 

[John Big Booty]

Your syntax is a little out, try;

If GetNetworkUserName <> "jdoe"  Or GetNetworkUserName <> "janedoe" Then
     msgbox "you don't have permission to access this form"
End If

 

[pbaldy]

As posted elsewhere:

Further, with the <> test, you want And rather than Or.

 

[slimjen1]

Thank you for your help. Can you tell me how I can retrict user to only their records? Do I do this the same way with the form load?
Thanks so much

 

[slimjen1]

Also; do I use "and" instead of "or" even If I want either user? With form load I want to be able to test for either user not both. If getuser <> to user1 or user 2 then.....
Thanks

 

[pbaldy]

Lets say the user is jdoe. Does that not meet the test of <> "janedoe"? Test it for yourself.

 

[slimjen1]

Ok I test it. thanks. Any idea on retricting user access to their records?
Thanks

 

[pbaldy]

Base forms on a query with a criteria.