Auto import and delete

[Jaudice Joy]

I am attempting to add a button on to a form that will
activate a query or some other function to delete the
days input so we can start the tables fresh the next day.I
have two separate tables that collect data from a scanner
to compare actual recieved parts with days expected
deliveries.I have completed this but would like to make it
easy for the operator to clear the fields for the next
day.Also, if anyone knows how I could set up an easy
way,maybe with a form button also to activate an automatic
import of the days expected recieved parts from an excel
file into the access table.

Thanks ahead of time
Jaundice Boy

 

[[MVP] S. Clark]

Build a delete query against the Entry Table, then issue a command like the
following in a command button's on click event:
Docmd.OpenQuery "qryEntryTable_Empty"


--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-