[AccessD] Hide Database Window and still use OutputTo command

Form Load event? That may have something to do with it, though I can't think
why. Maybe you could try doing the output part in the form's Current event
which is the last event to file in the sequence Open ==> Load ==> Resize ==>
Activate ==> Current that occurs when a form is loaded.

Lambert

> -----Original Message-----
> From:	Barbara Ryan [SMTP:BarbaraRyan at cox.net]
> Sent:	Thursday, February 06, 2003 12:22 PM
> To:	Heenan, Lambert
> Subject:	Re: [AccessD] Hide Database Window and still use OutputTo
> command
> 
> Lambert....
> 
> The error is "2046: The command or action OutputTo isn't available now".
> However,  I just looked at another application --- and -- like you ---I am
> also creating .snp files with the database window hidden.  I am receiving
> the 2046 error in an application where the snp files are being created in
> the Form Load event in a form that is executed at startup --- don't know
> if
> that has anything to do with the error.
> 
> Barb
> 
> ----- Original Message -----
> From: Heenan, Lambert <Lambert.Heenan at AIG.com>
> To: <accessd at databaseadvisors.com>
> Cc: <BarbaraRyan at cox.net>
> Sent: Thursday, February 06, 2003 11:48 AM
> Subject: RE: [AccessD] Hide Database Window and still use OutputTo command
> 
> 
> > Can you tell us what the error message is. I'm using Access97 Sp2 and I
> > routinely have the database window hidden, in the same way as you
> describe,
> > but I have no problems creating Snapshot reports from both MDB and MDE
> > files.
> >
> > So I'm not sure what known bug Doris is referring to.
> >
> > Lambert
> >
> > > -----Original Message-----
> > > From: Mike and Doris Manning [SMTP:mikedorism at ntelos.net]
> > > Sent: Thursday, February 06, 2003 10:58 AM
> > > To: accessd at databaseadvisors.com
> > > Subject: RE: [AccessD] Hide Database Window and still use OutputTo
> > > command
> > >
> > > This is a known bug in Access.  There is no solution except to create
> an
> > > MDE or run the database using the Access Runtime switch.
> > >
> > > Doris Manning
> > > Database Administrator
> > > Hargrove Inc.
> > > www.hargroveinc.com
> > >
> > > -----Original Message-----
> > > From: accessd-admin at databaseadvisors.com
> > > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Barbara Ryan
> > > Sent: Thursday, February 06, 2003 10:07 AM
> > > To: Access List
> > > Subject: [AccessD] Hide Database Window and still use OutputTo
> > > command
> > >
> > >
> > > In an Access 97 application, I am issuing an OutputTo command
> > > "DoCmd.OutputTo acOutputReport, "rptCOAReview", "Snapshot Format",
> > > strAttachment" (strAttachment is the pathname of the output .snp
> file).
> I
> > > do NOT want the database window to be displayed, so I un-checked the
> box
> > > in the application Startup for Display Database Window.  Now I'm
> getting
> > > an error on the OutputTo command.  How can I hide the database window
> and
> > > still create a .snp file?
> > >
> > > Thanks,
> > > Barb Ryan
> > >
> > >