Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Calling MSAccess from VB, won't stay open

    Hi all,

    Wondering if anyone can help with weird behavior. I have a VB6 form in which I am calling several differnent access reports from the same .mdb. They all work great except for 1. When I call the report, it flashes on the screen, and then immediately disappears. Anyone know why? The rest of the reports all appear in preview mode inside a MSAccess window. I can't find the difference with this one report. They all use the same code for calling as well (i.e. DoCmd.OpenReport...). So I'm wondering why one is different? Has anyone see this?

    Thanks for any and all help to prevent me from further banging my head against the wall.


  2. #2
    Join Date
    Nov 2003
    Is there any code within the report itself the tells it to close?


  3. #3
    Join Date
    Mar 2004

    Re: Calling MSAccess from VB, won't stay open

    Make sure your connection object is not getting out of scope and therefore automtically cutting the connection.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts