Access 2000 Runtime, Error

N

Nick

The database that I have developed, is used by others
running Access 2000 run time. The problem is that if there
is an error on start-up the database brings up an error
message and then closes. This is because the
TransferSpreadsheet action fails because the file location
is not set on start-up. The autoexec macro and the actions
are as follows.
(1) RunCode
Public Function Init()
If Application.GetOption("Confirm Action Queries") Then
Application.SetOption ("Confirm Action Queries"),
False
End If
End Function

(2) OpenQuery
This query deletes the content of a table
(3) TransferSpreadsheet
Imports an Excel spreadsheet to the same table as action
(2). The File Name field =DLookUp
("File_Location","tbDefaults")
(4) OpenQuery
Appends to its own table
(5) OpenQuery
Appends to its own table

Can anyone tell me how to stop the actions so that the
database stays open so the file location can be set?

Regards
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top