Results 1 to 7 of 7

unable to delete table with certain prefix via vba

Threaded View

littleangel unable to delete table with... 09-02-2023, 08:10 AM
TMS Re: unable to delete table... 09-02-2023, 08:26 AM
Marc L Re: unable to delete table... 09-02-2023, 08:31 AM
littleangel Re: unable to delete table... 09-02-2023, 09:18 AM
Marc L Re: unable to delete table... 09-02-2023, 09:35 AM
TMS Re: unable to delete table... 09-02-2023, 09:28 AM
littleangel Re: unable to delete table... 09-05-2023, 12:57 AM
  1. #1
    Registered User
    Join Date
    11-29-2020
    Location
    india
    MS-Off Ver
    2021
    Posts
    92

    unable to delete table with certain prefix via vba

    i m trying to scan thru the namemanager via vba macros and delete all tables with prefix "import" but i keep getting error sub or function not defined on dlookup

    sub DeleteTables()
    
        If Not IsNull(DLookup("Name", "MSysObjects", "Name='import' AND Type = 1")) Then
        DoCmd.DeleteObject acTable, "import"
        End If
    
    End Function
    Last edited by littleangel; 09-05-2023 at 12:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete entire row that contains specific prefix
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2023, 03:45 AM
  2. Unable to delete numbers in table
    By Deniouz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2021, 09:06 AM
  3. [SOLVED] Unable to Delete Table Rows
    By omagoodness in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2019, 04:53 PM
  4. [SOLVED] add prefix to number based on validation from other data if found prefix 0, do nothing
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2018, 11:52 AM
  5. [SOLVED] macro to delete prefix and file extension through desktop and its subfolders
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2018, 06:08 PM
  6. Delete cells based on Prefix
    By Will03 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-21-2014, 11:19 AM
  7. [SOLVED] Delete workbooks with specific prefix in its name
    By Manish84 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2014, 06:07 PM

Tags for this Thread

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