Need help with forms

[PaulSharma]

1. How can i make a form come up when that application is loaded.

2. how can i control is using a code e.g if abc has logged in then show frm123 and if xyz as logged in then show frm555

3. in the attached application, when i am opening a report from LOA Production button it is hiding behind that form, how can i make it modal.

 

[jeremie_ingram]

1. In the TOOLS > STARTUP option you can set the form to load when the mdb is opened. You can also make sure the database window doesnt show.

2. Are you having them log into the database or are you talking an OS log on?
If its just the database, then when they do log in store thier id in a temp talbe that clears on exit (or just before you put thier info in). This way you can refrence who is in the entire session, and make accomindations accordingly. You could also pass thier log on ID into a varible.

3. There is a modal option in the properties listing for the forms, set it to YES. From there you will have to make the proper VB code calls to bring it up and use it.

 

[ShaneMan]

Paul,

On question #3. Your form that is calling the report is set to Modal = Yes, that's the reason your report opens behind it. You will need to either change the form to Modal = No. Code for it to go to Modal = No or set forms visible to false.

Hope this gets you headed toward a solution,
Shane

 

[PaulSharma]

1. In the TOOLS > STARTUP option you can set the form to load when the mdb is opened. You can also make sure the database window doesnt show.

2. Are you having them log into the database or are you talking an OS log on?
If its just the database, then when they do log in store thier id in a temp talbe that clears on exit (or just before you put thier info in). This way you can refrence who is in the entire session, and make accomindations accordingly. You could also pass thier log on ID into a varible.

3. There is a modal option in the properties listing for the forms, set it to YES. From there you will have to make the proper VB code calls to bring it up and use it.

Thank you Shane, Thank you jeremie ingram.. i really appreicate your help. I got answer of my first question and last question. however i still have doubt in Q2. i am using function to check the user, i can get the user but how will i change my login form by coding. i hope you got my point.. i want

if James logs in then login screen should be frmUser but
if Sandra logs in then login screen should be frmAdmin

How can i do this?

I need one more help.. would really appreciate if you could open the attached database and go to MainForm , once you will open this form it will ask you to select two dates select "08/01/2005" and 08/25/2005" and Associate as "All Team" now click total production report.. i will open a report... i am not able to get total for all these values. Please help.