Switchboard

[Sheba]

hello, could someone please help me with this?:

1) I don't want my switchboard to occupy the whole screen since there are only four items on it. So I made it a
Popup form. However each time I view it, it grows larger in size Although moveable, how can I make the
size fixed?? I tried to change the width property to 24.0cm but it promptly flips back to 30.49cm

2) Also it remains on top of the other forms it calls
Question: How do I make it go away once an item on it is clicked?

I very much appreciate any help on this

[cbende2]

If you post the DB I can look at it for you.

As for #2, check in the form properties, and make sure "modal" is set to "no"

And you can make the menu go away by running a macro either "CloseWindow" or MinimizeWindow," just make sure in the macro wizard that these macros are before opening up the child form.

[Sheba]

sorry but I can't find the section where I can upload the file... I saw it yesterday but I don't seem to see it now...?

[Sheba]

I still can't see the place to upload my database. Only "quick reply" screen is available to me...

Cbende2 - in the On-Open event of my main switchboard, there are macros there. My skills are still beginner and I don't want to mess them up. This is what is there:

SetTempVar
SetProperty
Requery

Could you advise where else I could use this minimizewindow macro?

[June7]

Click the Go Advanced button below the post editor to open the advanced editor. Attachment Manager is below that editor.

[edmscan]

Don't know if this is what you want .. but have Access start your switchboard form on database startup. Under options / current database in the file menu.
Your forms will have to be made popups for this to work.


Put this in the load of your switchboard form ... (this will minimize your database window)
DoCmd.RunCommand acCmdAppMinimize


Then .. add this to the buttons on your switchboard form. (this will open your form from your button and hide your switchboard)

DoCmd.OpenForm "frmFormYouWantToOpenFromYourButton", acNormal
Me.Visible = False

And add on the close event of your forms that you open on your switchboard. (this will hide your form and make your switchboard visible again)

Me.Visible = False
DoCmd.SelectObject acForm, "frmNameOfSwitchboardForm"
DoCmd.Restore
Forms!frmSwitchboard.SetFocus

[Sheba]

Hi edmscan, I fixed this yesterday and did it this way as well. thank you for your response

[edmscan]

Hi edmscan, I fixed this yesterday and did it this way as well. thank you for your response

Glad it is working for you.