Having a "front" page

[mb1980]

I have everything setup how I want it on my database, now what I really need is to be able to design one page where I can access everything from, my forms, reports etc so that instead of going through all the different parts to input things or run reports it can be done by different users by just using one page, any advice on how to do this would be greatly appreciated.

Thanks.

 

[gemma-the-husky]

access has a switchboard manager that will give you one of these.

look at tools/addins

 

[boblarson]

There's a couple of ways you could do it.

1. Use the Switchboard Manager (Tools > Database Tools > Switchboard Manager)

2. Create a form and manually put everything you want on it. I use this method exclusively and I use the Tabbed Control to put a LOT of things on one form.

 

[boblarson]

Also, just to show you what you can do with Tabbed forms, here's a sample of what I did for a database. You have to use subforms to put more tabbed forms on a tabbed form, but I did it 3 levels deep with this:

 

[Zigzag]

I try to avoid the switchboard manager and create my own.
See attachment as an example.
I tend to head towards a nice GUI with simple buttons.

 

[Simon_MT]

I use a Menu based UI with Labels with an On Click function. At least with the Labels you can determine a variable colour scheme! In the start-up I simply put Menu. If you require the organisations logo to appear then create a Menu Form for the logo and attach this SubForm to your all your Menus.

There is a Quit All on the Main Menu and CloseForm on all the others. To stop users having multiple instances of the database open I also check for another instance:

Function IsRunning() As Integer

    DoCmd.Maximize
    
 Dim db As Database
    Set db = CurrentDb()
    
    If TestDDELink(db.Name) Then
        MsgBox "The database is already open"
        Application.Quit
        Set Application = Nothing
    End If

End Function

Simon