MS Access and Authorize net ARB Transactions

BondJamesBond

New member
Local time
Today, 08:49
Joined
Oct 31, 2017
Messages
5
Trying to get downloaded ARB transactions from Authorize.net into MSAccess Program. Previous employee had it working, but I cannot figure out what is broken. I dont understand the code. And I think the files the code is "looking for" are misplaced. Thanks!
 
Option Compare Database

Private Sub Command0_Click()

On Error GoTo Err_1234


DoCmd.RunSavedImportExport "Import-Successful5"


MsgBox "Its finished"

List7.Requery
Exit Sub



Err_1234:

MsgBox "you have dome this beofre"


End Sub
 
Check the list of saved Imports and see if that import spec exists.
If not you'll need to run the import manually then saved the spec.

If it does exist, try putting the spec in brackets:

Code:
DoCmd.RunSavedImportExport ("Import-Successful5")

Also suggest you swop the order of the next 2 lines

Code:
List7.Requery
MsgBox "Its finished"
 
Last edited:

Users who are viewing this thread

Back
Top Bottom