Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Getting Access Error Messages when running Access through Excel

Here's the relevant code:

Dim IllustrationWB As Workbook
Dim InputSheet As Worksheet
Dim BDCodesWB As Workbook
Dim BDSheets As Worksheet
Dim BDCodesPathFile As String
Dim lngLastRow As Long
Dim lngLastRowCodes As Long
Dim strBDCode As String
Dim strBDCodes As String
Dim objAccess As Access.Application

Sub ImportBDCodes()
'start access and run code which exports query results
On Error GoTo errAccessFail
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase
"\\Server03\shared\Agreements\AgreementInventory.m db", True

For some reason this is now causing an error in Access when it has been
working before for months. What I'd like to get is the Access error number
and description. How can I do that?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Access-to-Excel Automation.... Bob Barnes Excel Discussion (Misc queries) 2 June 16th 06 08:57 PM
Running an Access Query From Excel Paul Smith[_3_] Excel Programming 0 August 17th 04 11:16 PM
Running A Access Macro From Excel Frank Excel Programming 2 August 12th 04 06:43 AM
Running Macros in Access from Excel Simon Dowse Excel Programming 1 June 7th 04 03:48 PM
Running Access MAcros or VB modules in Excel Nick Excel Programming 0 October 28th 03 06:27 AM


All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"