+ Reply to Thread
Results 1 to 5 of 5

Clearing table contents when closing Access?

  1. #1
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    141

    Clearing table contents when closing Access?

    Hello,

    I do not understand why this macro is not deleting my table's contents when exiting Access or even closing the form. Since I have multiple forms, how is this code suppose to work if my main form gets closed?

    Thanks!!!

    HTML Code: 

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,679

    Re: Clearing table contents when closing Access?

    Please Login or Register  to view this content.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    141

    Re: Clearing table contents when closing Access?

    Unfortunately, it did not work. I corrected the typo in the code and still did not work. I guess Access does not have the same functionality as Excel.

    Thanks.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,679

    Re: Clearing table contents when closing Access?

    Works in my DB. Without seeing your DB, can not offer any further assistance.

  5. #5
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    141

    Re: Clearing table contents when closing Access?

    This is a sample file. Table includes a set of default dates. If dates are changed in form, it adds a new date row in table. I need to wipe any entries and return to default dates when re-opening the file. I have included a module with your code to prove that it was not working.


    THanks again for your help!!!!
    Attached Files Attached Files
    Last edited by icyrius; 01-15-2020 at 01:15 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete Table Contents in Access and Upload New Data
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2017, 04:16 PM
  2. Clear cell contents on closing/opening without clearing formulas
    By CFT Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:47 PM
  3. [SOLVED] Clearing Cells upon closing the document
    By Galliand in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-03-2013, 04:14 PM
  4. Import Access Table contents with criteria.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-30-2011, 11:05 PM
  5. Clearing Contents
    By makku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2011, 05:23 AM
  6. Macro: Closing an open file and clearing clipboard
    By plunkettyplunk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2010, 04:10 AM
  7. clearing cells upon opening or closing
    By sc10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2010, 10:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1