Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Access 2002 Query - query

Options
  • 01-12-2003 6:19pm
    #1
    bikini widow
    Registered Users Posts: 135 ✭✭


    I have 5 different queries being exported to excel on a weekly basis.

    These queries export all records which have been checked "yes" in the different user forms. What I need to do is at the end of each week when the administrator hits the export to excel buttons that all records with "yes" are deleted after they are exported...

    is this possible?

    I need this so when next weeks export comes along the same records aren't resent.

    ps I'm not to up on VBA



    Any help appreciated,
    BW


Comments

  • Options
    #2
    McGintyMcGoo
    Closed Accounts Posts: 333 ✭✭McGintyMcGoo


    Create a macro to export each query to an Excel spreadsheet (use a wizard to do it)

    Create a delete query and execute it using a macro.
    All you do is write a query to
    "DELETE tablename WHERE fieldname = True"
    This will delete all records in your table that have that particular field checked.

    Finally execute all macros/code on trhe click of a button.

    Takes 5 minutes to create the above using vba.
    It's really easy so just play about with it.

    If you're really stuck technically, post your questino again.

    :ninja:


Advertisement