Re: Receiving Events from MS Access from Custom Toolbar in VB.NET
From: david epsom dot com dot au (david_at_epsomdotcomdotau)
Date: 06/23/04
- Next message: Hui: "Problem with exposing Windows Form as COM DLL"
- Previous message: Albert D. Kallal: "Re: Receiving Events from MS Access from Custom Toolbar in VB.NET"
- In reply to: Alain Hogue: "Re: Receiving Events from MS Access from Custom Toolbar in VB.NET"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 08:57:20 +1000
> First I am using a custom toolbar. Access do not allow custom toolbar
> remain available if there is no database opened.
The people who originally developed Access had in mind a 'relational'
database system, where all the data ABOUT the data in the database
was also stored in the database. That included the menu system,
stored procedures, views, and the keyboard mapping.
(user preferences were stored in a separate user preference database)
Access has since been hacked around to share code with Office and
VBA, but in the main, Office and VBA have not been changed to match
Access, so implementation differences remain.
(david)
"Alain Hogue" <alain@aza.qc.ca> wrote in message
news:uWUAJ3QWEHA.1952@TK2MSFTNGP12.phx.gbl...
> Thanks for answering my post. But this is not exactly my problem.
>
> First I am using a custom toolbar. Access do not allow custom toolbar to
> remain available if there is no database opened.
> Second, some program, like Excel, raise event when someone open or close a
> workbook. Why not Access?
> Finaly, when the user close the database, Access just stop showing my
> toolbar. I have no way of knowing if a database was closed or not.
>
> Have a nice day!
>
> "Albert D. Kallal" <PleaseNOOOsPAMMkallal@msn.com> a écrit dans le message
> de news:uZFPmEJWEHA.2340@TK2MSFTNGP09.phx.gbl...
> > "Alain Hogue" <alain@aza.qc.ca> wrote in message
> > news:uYnqAcpUEHA.1656@TK2MSFTNGP09.phx.gbl...
> > > Hi everyone!
> > >
> > > I have created a toolbar to use in MS Access 2000, 2002, 2003. I would
> > like
> > > to be notified when the user select a new database or close the
current
> > one.
> > > Also I would like my toolbar to remain available even if no database
is
> > > opened.
> >
> > I would say that you need to build code for each item in the menu bar.
In
> > fact, when I create custom menu bars, or tools bars, I write code for
each
> > option in the toolbar. If you write code for each option, then you
> certainly
> > then can come up with some schemes to notify your application.
> >
> > however, like in c++, or vb, or most environments, there is NOT a event
> that
> > fires when you open a file in vb, or c++. and, also this is the same in
> > ms-access.
> >
> > So, for most of the menu options, that menu code can (and in fact often
> > does) call standard code in a module. However, there is NOT a VBA
> equivalent
> > of the file open command exposed.
> >
> >
> > --
> > Albert D. Kallal (Access MVP)
> > Edmonton, Alberta Canada
> > pleaseNOOSpamKallal@msn.com
> > http://www.attcanada.net/~kallal.msn
> >
> >
>
>
- Next message: Hui: "Problem with exposing Windows Form as COM DLL"
- Previous message: Albert D. Kallal: "Re: Receiving Events from MS Access from Custom Toolbar in VB.NET"
- In reply to: Alain Hogue: "Re: Receiving Events from MS Access from Custom Toolbar in VB.NET"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
