I'm a new programmer in vba and try to write a billing system. I would like to know where I can find examples of nice intro screens for my application, eventually with colors for the background in gradient colors, animated gifs etc...If no examples exist, can I program them in vba ?

thanks.

tsc

The Stardust Company

You can look at some pretty cool interfaces here to get some ideas:

http://www.activ8.com.au/interface/

Or, you can create your own Splash Screens by creating a regular old form and setting the following properties:

Scrollbars: Neither
Record Selectors: No
Navigation Buttons: NO
Auto Center: Yes

Plus whatever else you like. Then program several of the Splash Screens events as follows:

Private Sub Form_Activate()

    ' Hide built-in Form View toolbar.
    DoCmd.ShowToolbar "Form View", acToolbarNo

End Sub

'Private Sub Form_Deactivate()
'
' ' Show built-in Form View toolbar where appropriate.
' DoCmd.ShowToolbar "Form View", acToolbarWhereApprop
'
'End Sub

Private Sub Form_Open(Cancel As Integer)

    Me.TimerInterval = 5000

End Sub

Private Sub Form_Timer()

    ' If statement used to reset TimerInterval property.
    If Me.TimerInterval <> 0 Then
        Me.TimerInterval = 0
    End If

    DoCmd.OpenForm "frmSwitchboard", , , , acNormal
    DoCmd.Close acForm, "frmSplashScreen"

End Sub

The code sets the Splash Screen's timer interval to 5 seconds (5000 milliseconds) so that the Splash Screen automatically closes after 5 seconds and opens up your Switch Board, or any other form.

Also set the apps start-up object to your Splash Screen form via Tools -> Startup.

HTH,

Bob

Also remembered I've played around with one of Peter DeBeat's (sp?) freeware modules that'll do your BackColor Gradients in your form's detail section for you. Its at:

http://www.peterssoftware.com/bcg.htm

Regards,

Bob

I tried using one of the modules that I got from the Peter's Software website it and I went through hell trying to update the VBA code inside my database

majora

The Stardust Company

The Stardust Company

The Stardust Company

Bob,

I just wanted to make a comment on the VBA code for the On Deactive event of the splash screen form.
I was having a problem getting into Design View so I could make needed changes to my Music Inventory 2001 database. I had already implemented a splash screen form and I had also coded it using the code you provided so it would work correctly.
Thing is, I noticed that for the On Deactive procedure, there is a ' before the text "DoCmd.ShowToolbar "Form View", acToolbarWhereApprop in the On Deactivate section. You CANNOT have a ' in front of the code you want Access to execute. Access will not execute comments

Just thought I'd let you know

Ben

Hi Ben,

Sorry I didn't clean that up before posting it. Must have been debugging something and forgot to uncomment that particular block.

Regards,

Bob

Hi Ben,

An easy way to get around this apparent problem when the Form View toolbar isn't visible is to press the F11 key. That will display your Database Toolbar and Database Window where you can select design view.

Bob