Results 1 to 9 of 9

Thread: Access automation, view single object

Threaded View

  1. Sep 28th, 2004, 02:58 PM #1
    DaveBo
    DaveBo is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2001
    Location
    N42 29.340 W71 53.215
    Posts
    422

    Resolved Access automation, view single object

    I'm currently able to open an Access MDB file's objects (reports, tables, forms, etc) from a VB app, but the full-blown MDB comes up also.

    Is it possible to just open/view a single object, e.g. one report, without exposing the whole Access app?

    Here's what I'm doing now
    VB Code:
    1. Dim accApp as Access.Application

    2.        :

    3.     Set accApp = New Access.Application

    4.  
    5.     accApp.OpenCurrentDatabase (MDB_Path)

    6.     accApp.Visible = True

    7.     accApp.RunCommand acCmdAppMaximize

    8.  
    9.     accApp.DoCmd.OpenReport "my_report", acViewPreview

    10.     Set accApp = Nothing
    Feel free to make any constructive criticisms/suggestions.

    Thanks, DaveBo
    Last edited by DaveBo; Sep 30th, 2004 at 12:12 PM.
    "The wise man doesn't know all the answers, but he knows where to find them."
    VBForums is one place, but for the really important stuff ... here's a clue 1Tim3:15
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width