Professional Web Applications Themes

switching Datasheet / Form view - Microsoft Access

I have a form which is opened from a custom menu bar. The form is set to datasheet as default view, and datasheet is the only view enabled.... When I open the form using the menu, it opens fine, but if I then if I attempt to open it again (I.e. had forgotten it was already open, or want to give it focus), it then switches to Form view, which SHOULD be disabled?? Is Access supposed to act in this way? Is there any way I can prevent this?? Thanks, Nick...

  1. #1

    Default switching Datasheet / Form view

    I have a form which is opened from a custom menu bar.

    The form is set to datasheet as default view, and datasheet is the only view
    enabled....

    When I open the form using the menu, it opens fine, but if I then if I
    attempt to open it again (I.e. had forgotten it was already open, or want to
    give it focus), it then switches to Form view, which SHOULD be disabled??

    Is Access supposed to act in this way?
    Is there any way I can prevent this??

    Thanks,

    Nick



    NH Guest

  2. #2

    Default Re: switching Datasheet / Form view

    In the second instance, you probably use the OpenForm Method with default
    View (acNormal) which will open (or activate) the Form in (normal) Form
    view. VBA code will override the Form's settings.

    Check Access VB Help on the OpenForm Method and specify the appropriate
    value for the View argument.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "NH" <nhNOSPAMPLEASEtrada.net> wrote in message
    news:u9RRJaTTDHA.2676TK2MSFTNGP10.phx.gbl...
    > I have a form which is opened from a custom menu bar.
    >
    > The form is set to datasheet as default view, and datasheet is the only
    view
    > enabled....
    >
    > When I open the form using the menu, it opens fine, but if I then if I
    > attempt to open it again (I.e. had forgotten it was already open, or want
    to
    > give it focus), it then switches to Form view, which SHOULD be disabled??
    >
    > Is Access supposed to act in this way?
    > Is there any way I can prevent this??
    >
    > Thanks,
    >
    > Nick
    >
    >
    >

    Van T. Dinh Guest

Similar Threads

  1. Datasheet View in Form
    By Conner Stevens in forum Microsoft Access
    Replies: 2
    Last Post: July 31st, 09:48 PM
  2. Replies: 0
    Last Post: July 23rd, 06:42 PM
  3. How to Customize datasheet view
    By cuteisme in forum Microsoft Access
    Replies: 2
    Last Post: July 23rd, 04:03 PM
  4. Font size in Form in Datasheet view
    By Fredg in forum Microsoft Access
    Replies: 1
    Last Post: July 23rd, 01:15 PM
  5. subform - datasheet view, new record at top
    By JulieD in forum Microsoft Access
    Replies: 2
    Last Post: July 2nd, 12:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139