Splitting a database

[cliffsimms]

I have a report which I need everyone to see but I do not want them to see anything else but the report. What do I need to do and how do I do it?
Beg. Access user here

 

[tc3of4]

Create a Form, and in the On Load property...
type the following

Private Sub Form_Load()

'/** Type this in
DoCmd.OpenReport reportname, acViewPreview

Exit Sub


Now
1) Go to the Tools section in the Tool Bar (Command Bar)
2) Select StartUp
3) In the Display Form/Page combo box
select the Form which you just created

What this does is when this database starts up it will automatically startup the Form which you selected... And when this Form starts up it runs code from the On Load property... which you just typed in to open the report...

For your knowledge, to view your database window press the [F11] key...

Now to make it so when the user clicks on Close (on the report) so that they don't see anything else, you can make it quit the application.

1) In the design mode of the report
2) Select the Events Tab
3) Select the Close property
4) Choose Event procedure

Now put this in as your code

Private Sub Report_Close()

'/** Quit the application
DoCmd.Quit

End Sub

Hope this helps,
tc3of4


[This message has been edited by tc3of4 (edited 01-18-2001).]