Help

  • Thread starter Thread starter jervin via AccessMonster.com
  • Start date Start date
J

jervin via AccessMonster.com

Hi,

Is there way to assign a password in the main switchboard? i mean i had my
main switchboard i set this up in my starup. One of the option in my main
switchboard is to design the switchboard. Is there a way that i could put a
password for that particular option?


thanks
 
Presumeably the option has a command button procedure "behind the
scenes", something like this:

private sub cmdBlah_Click()
(stuff to activate the Design option)
end sub

Just add the lines in CAPITALS:

private sub cmdBlah_Click()
IF INPUTBOX ("ENTER PASSWORD:") <> "S3CR3T" THEN
MSGBOX "SORRY, INCORRECT PASSWORD"
EXIT SUB
END IF
(stuff to activate the Design option)
end sub

HTH,
TC
 
thanks...
Presumeably the option has a command button procedure "behind the
scenes", something like this:

private sub cmdBlah_Click()
(stuff to activate the Design option)
end sub

Just add the lines in CAPITALS:

private sub cmdBlah_Click()
IF INPUTBOX ("ENTER PASSWORD:") <> "S3CR3T" THEN
MSGBOX "SORRY, INCORRECT PASSWORD"
EXIT SUB
END IF
(stuff to activate the Design option)
end sub

HTH,
TC
Click to expand...
 
Hi,

I try to do the following in all the options that i have but it won't work.
it goes directly to my form w/o asking any password.
I dont know if i made it right: i made right click on my switchboard form,
design, right click in gray color, build event, then drop down to options 3
up to 7,select on click and input the code and save.

regards
 
It's not a good idea (and is largely unavailable since A2000) to make design
changes, in particular code changes, on a running database.

Bad idea. Bad design.

Make pre-designed buttons available or not available, fine.

Chris
 
Sorry, I have no idea what "options 3 up to 7" might be on your PC.

You may need a tutorial on how to write code behind a command button.
Try this search in groups.google.com:

tutorial vba group:*access*

HTH,
TC
 
Back
Top