Calling Access97 from a VB6 program


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Calling Access97 from a VB6 program

  1. #1
    Jos Roijakkers Guest

    Calling Access97 from a VB6 program


    My VB6 program uses an Access97 database. This database also contains reports.
    The VB6 program starts these reports with the following lines:

    Dim MSAccess As New Access.Application
    With MSAccess
    .OpenCurrentDatabase "database.mdb"
    .DoCmd.OpenReport "reportname", acViewNormal
    .CloseCurrentDatabase
    End With

    I want the VB6 program to hold execution until the report has been sent to
    the print spooler. In other words: how can i detect from within the VB program
    whether or not the Access program has terminated?

  2. #2
    David Woodward Guest

    Re: Calling Access97 from a VB6 program


    You need the access code to return a value to VB. Well sort of...

    Just get the Access program to set a flag in a table or variable and get
    the VB program to read this to make a decision on what access has done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center