Kamis, 10 Mei 2012

[MS_AccessPros] Running 'make Table' queries at start up

 

I have a database that uses a front end that is linked to an on line
data source.

I use a query to make a table so that I can make reports from fixed data.

I need the VBA to use in the "On Load" event of the main form that
overwrites the exisiting table.

I have tried to adapt advice given a few months ago which used an
'Update' query but the code did not like the fact that the table existed.

It was based on this:

In VBA in the On Load event, do:

Dim db As DAO.Database

Set db = CurrentDB
db.Execute "name of query", dbFailOnError
db.Execute "Name of other query", dbFailOnError
' etc...

Set db = Nothing

Many thanks,

Robin Chapple

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar