Password Macro INTERESTING

[mcf747]

Hey guy I am a self taught access uses with a huge desier to learn. I am pritty advanced and like to think BIG. Anyway I am creatting a db that will alow people to enter there contact info for a school phone directory. Right now I have a look-up fourm that will find their previous info and bring up apassword box. (so anyone cant alter anyone's info without that persion's password) Through many examples and a lot of reserch I have found that a passoer feild is a simple macro with a condition like this one, [Forms]![password prompt]![Text2]="passsword_here". The problem is, sience I want every one to have their own password I wrote a code like this one, [Forms]![password prompt]![Text2]="[password]![password]" The last part, is a quiere that pulls up a specific students password via. their student number wich is obtained in the first stage were they enter their name. I am more than willing to post the db if anyone wants to see what I have done. Sorry if this post is a little confusing but i am hoping the experts can follow it.

Thanks,
mcf747

 

[DarkAngel]

Are you asking for advice or just showing what you've done?

Paul

 

[mcf747]

I am looking for help

 

[DarkAngel]

So what exactly do you need doing? What bit of your code doesn't work?

 

[Stavi]

OK the original post is a bit hard to read but he does say which bit he is struggling with

"[password]![password]"

He wants that bit to be "Password from password table where student number equals selected student number"

I dont know how to add filters to this sort of expression, I am trying to find out now, thats how I found this thread

 

[Stavi]

I sorted my problem, I had to learn the DLookup function, I assume the same will work for you.

I wont try and tell you how to do it, I dont understand the syntax properly yet, why is it square brackets there and quote marks there!!! oh well, at least it works