Results 1 to 5 of 5
  1. #1
    NOTLguy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    60

    Control Button that displays Datasheet view

    Is it possible to have a control button on a form that displays the table in datasheet view ( read only) ? if so, how is it done?

    Regards,
    Bill

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    DoCmd.OpenTable "tablename", acViewPreview

  3. #3
    NOTLguy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    60
    Quote Originally Posted by TheShabz View Post
    DoCmd.OpenTable "tablename", acViewPreview
    Thanks for the quick reply. I tried it and the result is like a report that spans over many pages. Is there any way to have it look like a table being opened in datasheet view, only read only?

    Regards,
    Bill

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    well, the best way would be to have a subform that is bound to the query "SELECT * FROM tableName;"

    I think it would be best to have some background as to why you want to open a table as read only anyway. there really isnt a valid reason out there for opening a table if you aren't going to edit it.

  5. #5
    NOTLguy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    60
    Quote Originally Posted by TheShabz View Post
    well, the best way would be to have a subform that is bound to the query "SELECT * FROM tableName;"

    I think it would be best to have some background as to why you want to open a table as read only anyway. there really isnt a valid reason out there for opening a table if you aren't going to edit it.
    On more sober thought, I have decided to forget this. Thanks for all your help,

    Bill

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

Similar Threads

  1. Missing Columns in Datasheet View
    By mikel in forum Access
    Replies: 3
    Last Post: 01-02-2015, 01:57 PM
  2. Subform, Totals, in Datasheet view
    By eww in forum Programming
    Replies: 1
    Last Post: 09-27-2010, 10:22 AM
  3. vertical text in datasheet view?
    By johncinpcb in forum Forms
    Replies: 0
    Last Post: 06-14-2010, 07:14 AM
  4. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM
  5. Form - Datasheet View
    By kalove in forum Forms
    Replies: 0
    Last Post: 06-20-2007, 11:29 AM

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