Results 1 to 5 of 5

Thread: Reports and VB6

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Location
    Scotland
    Posts
    96

    Unhappy

    Hi,

    I need to run access reports from vb (no other way around at the moment!) I have been using the following code but I keep getting runtime error 2486 : Unable to peform as some other event is preventing it...try later

    I have tried using doevents before it but it doesn't help

    Does anyone have any ideas?

    :code:

    Dim appAccess As Access.Application
    Set appAccess = New Access.Application

    appAccess.DoCmd.OpenReport "reportname", acViewNormal
    appAccess.Quit

    Set appAccess = Nothing

    any help greatfully appreciated

    H.

    Just trying to muddle through...

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Are you getting the error on the Quit command or the OpenReport command?

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Location
    Scotland
    Posts
    96
    OpenReport command
    Just trying to muddle through...

  4. #4
    Fanatic Member
    Join Date
    Oct 1999
    Location
    England
    Posts
    982
    How have you opened the database.

    There is the
    Code:
    appAccess.OpenCurrentDatabase
    method.


    Things I do when I am bored: DotNetable

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Oct 2000
    Location
    Scotland
    Posts
    96
    Thanks for your help

    Just trying to muddle through...

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