Results 1 to 6 of 6
  1. #1
    daveone23 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2024
    Posts
    25

    Data base repair


    Can someone fix this data base? Somehow it got messed up. The "clear" and search button no longer work. It should clear the entry and let me search for a new criteria.Click image for larger version. 

Name:	clear.jpg 
Views:	14 
Size:	203.9 KB 
ID:	51725
    Attached Files Attached Files

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,439
    Your attachment is invalid - cannot open

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,976
    Me.txtFindATube = ""
    Me.Filter = ""
    Me.FilterOn = False

    Edit.
    It opens for me and works for me?
    This is your code, which is what I suggested previously

    Code:
    Private Sub Remove_Filter_Click()
        
        
        Me.Filter = ""
        Me.cmbTubeFinder = Null
        Me.FilterOn = False
        
    End Sub
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    daveone23 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2024
    Posts
    25
    I see that visual basic code in my program but it does not work. I am lost. Clear filter does not clear the box and the number in the box does not sort the list.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,976
    Have you moved the DB?, is it in a Trusted location?

    So the code is not running?
    Put a breakpoint on the first available line in that code.
    Does it even go into that event?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    daveone23 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2024
    Posts
    25
    I made the directory and it works again. Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-18-2014, 06:41 AM
  2. Replies: 1
    Last Post: 07-08-2014, 06:22 AM
  3. Sharing a data base
    By Cran29 in forum Security
    Replies: 3
    Last Post: 02-05-2011, 06:45 PM
  4. Replies: 7
    Last Post: 11-11-2010, 11:16 AM
  5. Data base design
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-05-2010, 07:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums