Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    9

    Unanswered: Help - Import file into a hidden table

    I have taken over a database which contains a table that is set as hidden. Recently I have been asked to create a process to import Excel files into the hidden table. I'm not having any problems with the import code but after importing a file the hidden attribute is unchecked automatically. Is there any reason for this? Is there any way to prevent this from happening? I've tried searching the forums and using Google but I haven't found any useful information.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why not just hide the table again after the import code runs?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2007
    Posts
    9
    That is also an acceptable solution but I haven't been able to track down any VBA code that would allow me to do it. I'm sure there is code to hide a table but I'm probably just not wording my searches correctly to find it. Any help you could give me in tracking down the correct VBA code would be appreciated.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why are you bothering to hide the object in the first place? You should be the only person with direct access to the database structure and so it shouldn't make a difference
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ▲ I agree.

    I haven't ever hidden tables with code before, but, at a guess it would probably be done by modifying the Visible property of a Table object. If I get lots of time free (HAahhahaha ROFL!) I'll have a play and post the code back.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Nov 2007
    Posts
    9
    I can't say for certain why it was initially set up this way because I was not the one who created the database. However, due to the nature of this particular database, I am not the only person who needs direct access to the database structure. I was able to find the code that I needed. In case anyone else needs it, the code I used is:

    Access.SetHiddenAttribute acTable, "table name", True

Posting Permissions

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