Results 1 to 3 of 3

Thread: Help with reports please

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2007
    Posts
    41

    Unhappy Help with reports please

    I am using microsoft access 2007 and vb 6
    I created a report in access using queries and I would like to display the report in vb because i dont wanna create seperate reports in vb.
    Can u help me out please
    i wanna display my access reports using vb
    thanks in advance

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Help with reports please

    Set a reference to MS Access and do something like
    vb Code:
    1. Set Axs = CreateObject("Access.Application")
    2.             Axs.Visible = True
    3.             Axs.RunCommand acCmdAppMaximize
    4.             Axs.OpenCurrentDatabase (DBPath) 'path to database
    5.             Axs.DoCmd.OpenReport TheReport 'your report name
    6.             Axs.DoCmd.Maximize
    7.             Axs.Quit

  3. #3

    Thread Starter
    Member
    Join Date
    Apr 2007
    Posts
    41

    Re: Help with reports please

    thanks for ur reply but i am new to vb and i dont quite understand wat ur trying to say
    i am very sorry for being stupid but can u please explain each step please if u have the time
    it would be very helpfull
    thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width