Robin-
That code looks fine. What is the SQL of the two queries?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
----------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Friday, May 11, 2012 7:54 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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
Tidak ada komentar:
Posting Komentar