-
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
:confused: H.
-
Are you getting the error on the Quit command or the OpenReport command?
-
-
How have you opened the database.
There is the
Code:
appAccess.OpenCurrentDatabase
method.
-