VBA, Run-Time Error 2486 - Can't Carry Out Operation at Present Time

Run-Time Error 2486 - Can't Carry Out Operation at Present Time

Author	Message
Dave Hammon #1 / 2	Run-Time Error 2486 - Can't Carry Out Operation at Present Time Hi, I'm trying to open an access report for VB to make some modifications to it, however I'm getting error 2486. Does anyone know what this error means and what I can do to resolve it, the code works fine in Access VBA but not VB (and yes I have got the correct project references). The code casuing me trouble is below Dim rpt As Report DoCmd.OpenReport ("Report by User"), acViewPreview It crashes on the DoCmd line. Any Ideas? Cheers, dave.
Sun, 19 Sep 2004 19:01:49 GMT

Van T. Din #2 / 2	Run-Time Error 2486 - Can't Carry Out Operation at Present Time VB doesn't have the DoCmd Object like Access. If you automate Access (as an automation server), then I think you need to fully qualify it like: Dim rpt As Access.Report Access.DoCmd.OpenReport ... HTH Van T. Dinh Quote: > Hi, I'm trying to open an access report for VB to make some modifications to > it, however I'm getting error 2486. Does anyone know what this error means > and what I can do to resolve it, the code works fine in Access VBA but not > VB (and yes I have got the correct project references). The code casuing me > trouble is below > Dim rpt As Report > DoCmd.OpenReport ("Report by User"), acViewPreview > It crashes on the DoCmd line. Any Ideas? > Cheers, > dave.
Sun, 19 Sep 2004 23:43:48 GMT

Page 1 of 1

[ 2 post ]