Automatically run query when new/edited record is saved

  • Thread starter Thread starter Ed Moss
  • Start date Start date
E

Ed Moss

I'm working with an ASP - Access 2000 web application that manages
shipping information for a client, and need to make some changes to
it:

My client's label printing program can pull from an OLE DB source, but
is limited to only one table. The main table that the site uses stores
key values from a lookup table (ID,Name) for 4 of the 8 fields that
need to be printed, so I need a mechanism where a single table can be
created to make the Name values available to the label program.

I created the relationships and query needed to display the 8 fields
info, but need to modify this so the following occurs:

What is required so that the query automatically creates a new table
whenever a new/edited record is entered on my main table?

Thanks,

Ed Moss
 
On the Action Page of the Form, you can add code to execute the Make Table
Query. So, when the user presses a button on the ASP form, trigger the SQL.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top