Results 1 to 2 of 2
  1. #1
    MollyB is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    1

    Viewing Form via Switchboard

    I've set up some forms, set to open in datasheet view. I have set them to allow no additions or deletions. When I put them as items on my switchboard however, the form is opening in form mode rather than datasheet view. I've tried opening the form via a macro (set to open in datasheet), but it's losing the protection I've put around additions and deletions.



    How can I get the forms set up to open via my switchboard, in datasheet view and maintaining the level of protection I've set?

    Any help gratefully received!

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    In the form design properties, you should be able to set:

    Code:
    Allow form View	No
    Allow datasheet View	Yes
    Cheers,

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

Similar Threads

  1. Resize Switchboard form
    By smikkelsen in forum Forms
    Replies: 3
    Last Post: 04-03-2010, 06:59 AM
  2. Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  3. Converting/Viewing OLE Data as String...
    By oldgem in forum Access
    Replies: 0
    Last Post: 09-12-2009, 06:35 PM
  4. Viewing ending zeros in decimal
    By duecesup in forum Reports
    Replies: 0
    Last Post: 12-11-2008, 02:45 PM
  5. Access 2.0 Viewing Code
    By wollydog in forum Access
    Replies: 0
    Last Post: 12-03-2008, 07:50 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