Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

how to open existing mdb and work?

Discussion in 'Information Technology' started by SRussell, Jul 28, 2006.

  1. SRussell

    SRussell
    Expand Collapse
    Guest

    I have an MDB and when I open it in Access it runs. I press F11 and I can
    see the parts of the app.

    How do I open the app in design mode so I can drop controls on a new form?

    TIA
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "SRussell" <srussell@lotmate.com> wrote in message
    news:%238DJL73hGHA.1320@TK2MSFTNGP04.phx.gbl...
    >I have an MDB and when I open it in Access it runs. I press F11 and I can see
    >the parts of the app.
    >
    > How do I open the app in design mode so I can drop controls on a new form?


    An Access *file* does not have a "design mode". Each object in the file (forms,
    reports, queries, etc.), has a "design view".

    If you click on a table or query and then press the design button, then you will
    see the design view of that table or query. If that same design button is
    grayed out when you click on a form, report, or module, then what you have is an
    MDE file (these can still be given an MDB file extension), which does not allow
    design view or design changes of those kinds of objects.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. SRussell

    SRussell
    Expand Collapse
    Guest

    "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
    news:gTrgg.37623$fb2.14871@newssvr27.news.prodigy.net...
    > "SRussell" <srussell@lotmate.com> wrote in message
    > news:%238DJL73hGHA.1320@TK2MSFTNGP04.phx.gbl...
    >>I have an MDB and when I open it in Access it runs. I press F11 and I can
    >>see the parts of the app.
    >>
    >> How do I open the app in design mode so I can drop controls on a new
    >> form?

    >
    > An Access *file* does not have a "design mode". Each object in the file
    > (forms, reports, queries, etc.), has a "design view".
    >
    > If you click on a table or query and then press the design button, then
    > you will see the design view of that table or query. If that same design
    > button is grayed out when you click on a form, report, or module, then
    > what you have is an MDE file (these can still be given an MDB file
    > extension), which does not allow design view or design changes of those
    > kinds of objects.


    Thanks, I'll try to describe my problem differently.

    I open Access, I open a friends .mdb file. It opens into his application,
    well after you say YES a few times. I can press F11 to display design part
    of the app. I can see the forms. Unfortunately I cannot reset the menu. I
    open the form but the tools pane or toolbar is NOT VISIBLE.

    How do I get that toolbox visible so I can drop some controls on a new empty
    form?

    TIA
     
  5. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    "SRussell" <srussell@lotmate.com> wrote in message
    news:ucI$qm9hGHA.5096@TK2MSFTNGP02.phx.gbl...
    >
    > "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
    > news:gTrgg.37623$fb2.14871@newssvr27.news.prodigy.net...
    >> "SRussell" <srussell@lotmate.com> wrote in message
    >> news:%238DJL73hGHA.1320@TK2MSFTNGP04.phx.gbl...
    >>>I have an MDB and when I open it in Access it runs. I press F11 and I can
    >>>see the parts of the app.
    >>>
    >>> How do I open the app in design mode so I can drop controls on a new form?

    >>
    >> An Access *file* does not have a "design mode". Each object in the file
    >> (forms, reports, queries, etc.), has a "design view".
    >>
    >> If you click on a table or query and then press the design button, then you
    >> will see the design view of that table or query. If that same design button
    >> is grayed out when you click on a form, report, or module, then what you have
    >> is an MDE file (these can still be given an MDB file extension), which does
    >> not allow design view or design changes of those kinds of objects.

    >
    > Thanks, I'll try to describe my problem differently.
    >
    > I open Access, I open a friends .mdb file. It opens into his application,
    > well after you say YES a few times. I can press F11 to display design part of
    > the app. I can see the forms. Unfortunately I cannot reset the menu. I open
    > the form but the tools pane or toolbar is NOT VISIBLE.
    >
    > How do I get that toolbox visible so I can drop some controls on a new empty
    > form?


    Hold the shift key while opening the file.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  6. SRussell

    SRussell
    Expand Collapse
    Guest

    "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message news:cpBgg.90958>>
    How do I get that toolbox visible so I can drop some controls on a new empty
    >> form?

    >
    > Hold the shift key while opening the file.


    Well after a BSOD, it worked!

    Thanks!
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page