Really stuck with a login problem :( :(

[fazmufc]

Hi all,

I am a total novice when it becomes to microsoft access 2003 but i have some how managed to create a stock control system. I just am getting 1 error in the vital part which is user login area.

When the user wants to login i want it to go to the main menu but instead i keep getting error of object doesnt support this property or method.

Any ideas its really doing my head in as it the problem i need to resolve to get it fully functional

I dont know if anyone can help me in just this area i really appreciate it.

I got it here just uploaded it maybe easier to understand


Basically all i want is the frm_main in the forms area to be edited and when user succesfully logs in, it takes them to the MainMenufrm if thats possible.

Thanks all

 

[boblarson]

Your problem is that you are trying to open forms that don't exist.

switchboard_lev1
switchboard_lev2
switchboard_lev3

don't exist in the database right now.

 

[fazmufc]

OMG appreciate the reply Ah i see, i think i was testing with the switch boards.

Say if i want the form to go to the mainmenu, where in the coding would i have to change it, so when user logins in succesfully it goes to the main menu (MainMenufrm). Thats all im trying to do, i dont think i really need the switchboard forms, well i wont be able to have the option of creating users which maybe a problem but as long this function thats fine

 

[boblarson]

Go into the validate user code in the module and change the

Docmd.OpenForm "switchboard_lev1"

to

DoCmd.OpenForm "MainMenufrm"

 

[fazmufc]

Wow that has done it, really appreciate the help mate

All i want try to is to finish it say when you open Microsoft Access Database that the login page is the first thing that opens up and you have to login to view the other forms, is this easy to do? So like i open Database and pops open the login form as the first thing.

Really sorry for my lack of knowledge with access but i think its all done and dusted now

 

[boblarson]

So like i open Database and pops open the login form as the first thing.

Go to TOOLS > STARTUP and select the login form as the startup form from the dropdown.