Results 1 to 4 of 4
  1. #1
    zaballin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2018
    Posts
    2

    Question Share a Table with company fellows


    Hello, I need to found a way to share just 1 table to everybody, showing just some columns but also allowing they can filter by values in each columns, just as you can do it it Excel or Access document.
    For now I have tried exporting to an excel and filtering, but its really cumbersome to hide every column you dont want each time I export the table, eventhough you can make some macros to enhance this process, it seems to consume tons of resources. So i was wondering if its there a way to make a web view of a table or something that makes easier to everybody to check and filter info without opening Access.

    Thanksssss

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Create a QUERY with ONLY the fields you want to show.
    Right click the query in the navigation pane and click Export. You will get a list of export options including HTML document and PDF

    Click image for larger version. 

Name:	Capture.PNG 
Views:	13 
Size:	15.2 KB 
ID:	34229

    Choose whichever is best for your purposes.
    If you need the ability to filter, it will need to be exported to Excel
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    zaballin is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2018
    Posts
    2
    For now it works! Eventhough I found a Jquery function, thath recives an HTML table and it allows you to filter just as Excel! Thank you very much fr you soon response

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Glad its working for you - what does 'a Jquery function' mean?
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Share Table across different Database
    By trident in forum Access
    Replies: 2
    Last Post: 12-02-2014, 05:49 AM
  2. Replies: 1
    Last Post: 10-29-2014, 03:44 AM
  3. Connecting Company Table to Staff Table
    By 3Khats in forum Database Design
    Replies: 3
    Last Post: 12-11-2012, 01:12 PM
  4. Replies: 1
    Last Post: 10-31-2012, 01:27 PM
  5. Replies: 1
    Last Post: 08-15-2012, 03:03 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