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
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar