How to minimizing database window using code

I

ions

Access User

Local time

Today, 13:31

Joined

May 23, 2004

Messages

823

• Mar 1, 2005

• #1

Dear Access Expert

when i run the two lines below

DoCmd.SelectObject acReport, stDocName, True
DoCmd.PrintOut acPrintAll, , , , 4

........... the database window (with the tables, queries, etc....) appears.

I don't want this behavior. How do I minimize this window using code?

Can I prevent it from popping up altogether?

Thank you

 

M

modest

Registered User.

Local time

Today, 16:31

Joined

Jan 4, 2005

Messages

1,220

• Mar 1, 2005

• #2

--- how about you delete one of your threads before we answer?
--- no need for a double post... especially in the same forum, same category, with the exact same wording (2 mins later)

 

T

trucktime

Registered User.

Local time

Today, 14:31

Joined

Oct 24, 2004

Messages

556

• Mar 2, 2005

• #3

Window

To hide the database window:

Private Sub cmdHide_Click()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub

To show the database window:

Private Sub cmdShow_Click()
DoCmd.SelectObject acTable, , True
DoCmd.SelectObject acForm, Me.Name
End Sub

 

I

ions

Access User

Local time

Today, 13:31

Joined

May 23, 2004

Messages

823

• Mar 3, 2005

• #4

Thank you Truck Time

It worked

Again Thank you for your help