Re: Only displaying the form window

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"geno" <geno@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D061B8D-BA4A-4DEF-BA3E-6D295082F9F9@xxxxxxxxxxxxx
> I got it. Thank so much.
>
> I was trying the codes in the sample database from access 2003
> "northwind" to see if how they work. This database has a startup
> form, before it goes to the mainswitchboard. I was puting the codes
> in "startup" form module, and it was not working, it was still
> showing the access application window. So i decide to delete the
> startup form and just use the main switchboard, i put the codes and
> Kaplann!! it work.
>
> thanks
>
> by the way do you know how to get it to work in a situation like this
> database.

I don't have Access 2003 installed, but if its version of the Northwind
database is like the one for Access 2002, the startup form calls a
function named OpenStartup from directly from its OnOpen property. You
can modify that function, adding these lines before the function exits:

Forms!Startup.Visible = True
DoEvents
fSetAccessWindow SW_HIDE

You should not use the code I posted for the form's Close event, because
you won't want to make the application window visible again when the
Startup form is closed.

You'll also need to make the [Main Switchboard] form PopUp and Modal, so
that when the Startup form closes and opens that form, it will be
visible event though the Access application window is hidden. I've
tried this in my Access 2002 version, and it works. In general, any
form you want to display will have to have its PopUp and Modal
properties set to Yes. Reports are a more difficult propostion, and I
don't remember offhand what te solution is for them.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Blue Title Bar
    ... I would like to create a startup form similar to the one on the Northwind ... database. ... How do you turn off the title bar on the startup form? ...
    (microsoft.public.access.forms)
  • Re: Need code to run on DB close
    ... What if someone has opened the database with the shift key? ... I cannot garantee that the form that calls the Unload Event ... "VBA Dabbler" wrote: ... specifying a startup form in Tools, ...
    (microsoft.public.access.setupconfig)
  • Re: first use of switchboard select option when app is first loaded
    ... You can now disable the startup form until you get this ... Now that the database is not crashing as soon as it starts, ... Start with the built-in compact and repair: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Bypass Key Combination (Macro)
    ... I already have a Startup form where I'm setting my properties. ... bypass without any autokeys macros in your database. ... Properties form where I can enable the bypass key again. ...
    (microsoft.public.access.macros)
  • Re: Protecting tables/queries from changes not in forms
    ... What I need to do is prevent against users making changes directly to the ... You're going to need to lock down the frontend and make the tables/queries difficult to get to. ... Create a startup form that is opened on startup. ... You can also create a MDE from your database, which will prevent changes to forms, reports and modules. ...
    (microsoft.public.access.security)