Keeping MS Access active 
Author Message
 Keeping MS Access active

Are there any tricks to keeping MS Access active using AppActive?  I am
using the following code to start Access and produce a report.  The report
is created properly, but the VB app is always current.  I would have to use
Alt-Tab or the Task Bar to view the report.

    Set objAccess = CreateObject("Access.application.8")
    With objAccess
        .OpenCurrentDatabase filepath:=gsDatabase
        .DoCmd.Maximize
        .DoCmd.OpenReport ReportName:=CmbReports, View:=Access.acViewPreview
        .DoCmd.Maximize
    End With
    report = "Microsoft Access - [" + CmbReports + "]"
    AppActivate report, 1

Thanks,




Sun, 13 May 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Active program: keeping the app active and checking time

2. Active X form to save data into MS-Access via web

3. MS Active X control downloads OK but home grown Active X Control will not download

4. MS Active X control downloads OK but home grown Active X Control will not download

5. Accessing current record in MS Access with DDE from MS Word

6. Regarding Accessing External database using MS-Access and MS-Visual Basic

7. Link MS Access on PocketPC to Desktop MS Access

8. Keep document active while form runs

9. Keep grid selection hilited when form not active

10. How Do I Loop Midi Files OR keep another form active when they stop

11. s there any way to Keep the active logo like Netscape always at Right side

12. keep object active

 

 
Powered by phpBB® Forum Software