mde library reference intellisense

[ctyrrell]

Sorry for the double post - I posted this earlier on
microsoft.public.access.modulesdaovba and then realized later that this
was a much more appropriate group for my problem.

I have created a library of generic routines I use for several of my
Access appplications, MyLib.mde. I just create a reference to it from
the Access Application and I can use all the routines and globals from
the App.mdb as I develop it. As I am developing code in the App.mdb,
the intellisense works beautifully, up to a point. Once I have typed
the name of the routine, intellisense shows me what arguments I need to
pass, and their types, etc. So far so good.

What I don't like however, is that the case of the routines (in my
typing) does not automatically fix itself, once I have completed the
statement and, if I have any other uses of that same routine (or
global), they all change to the case of what I am typing. This makes my
code in the App.mdb much less readable, and is annoying.

For a very simple example, I have a global gfDebug in MyLib.mde, that I
use throughout my code in both MyLib.mde and App.mdb. When I type
'x.visible = gfdebug', I expect it to automatically become 'x.Visible =
gfDebug', but it does not. Instead I get 'x.Visible = gfdebug'. And
everywhere in the App.mdb that I use gfDebug now becomes gfdebug. Note
that the 'v' of visible, does update to 'V', as expected, but the 'd'
in gfdebug does not.

I usually count on the case of my typing automatically correcting, as I
go along, so that I am sure I typed the variable or routine name
correctly.

This is not a show stopper but it is my only problem with my Access
library paradigm. Is there anything I can do to make it behave the way
I would like?

Any insights or feedback would be greatly appreciated. By the way, I am
using Access 2000.
Thanks,
Christine

 

[Cindy M.]

Sorry for the double post - I posted this earlier on

microsoft.public.access.modulesdaovba and then realized later that this
was a much more appropriate group for my problem.

I have created a library of generic routines I use for several of my
Access appplications, MyLib.mde. I just create a reference to it from
the Access Application and I can use all the routines and globals from
the App.mdb as I develop it. As I am developing code in the App.mdb,
the intellisense works beautifully, up to a point. Once I have typed
the name of the routine, intellisense shows me what arguments I need to
pass, and their types, etc. So far so good.

What I don't like however, is that the case of the routines (in my
typing) does not automatically fix itself, once I have completed the
statement and, if I have any other uses of that same routine (or
global), they all change to the case of what I am typing. This makes my
code in the App.mdb much less readable, and is annoying.

For a very simple example, I have a global gfDebug in MyLib.mde, that I
use throughout my code in both MyLib.mde and App.mdb. When I type
'x.visible = gfdebug', I expect it to automatically become 'x.Visible =
gfDebug', but it does not. Instead I get 'x.Visible = gfdebug'. And
everywhere in the App.mdb that I use gfDebug now becomes gfdebug. Note
that the 'v' of visible, does update to 'V', as expected, but the 'd'
in gfdebug does not.

I usually count on the case of my typing automatically correcting, as I
go along, so that I am sure I typed the variable or routine name
correctly.

This is not a show stopper but it is my only problem with my Access
library paradigm. Is there anything I can do to make it behave the way
I would like?

Any insights or feedback would be greatly appreciated. By the way, I am
using Access 2000.

Whenever I've seen what you describe, the ultimate reason behind it has
been an inconsistency in my code (such as two Subs with the same name).
Doing a full Debug/Compile usually turns it up.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[ctyrrell]

Hi Cindy,
Thanks for responding. I do compile my App that is using the Lib.mde,
all the time as I am developing, and yet still get the situation where
the global variables in the mde and the routines in the mde do not keep
their correct case when I am typing in the App.mdb referencing them, so
I have to type the cases accurately. The funny thing is that while I am
typing, the intellisense does display the routine names with correct
case. But when I am done typing a statement it keeps whatever case I
typed and all other places that call that same routine will have the
same poor case. For example if the routine is 'OpenWord' but I typed
'openword', all other places in my code that were 'OpenWord' will
become 'openword' too.

Is there any technique for developing some kind of type library
interface for my Lib.mde?

Any other thoughts or recommendations?
Thanks
Christine

 

[Cindy M.]

Thanks for responding. I do compile my App that is using the Lib.mde,

all the time as I am developing, and yet still get the situation where
the global variables in the mde and the routines in the mde do not keep
their correct case when I am typing in the App.mdb referencing them, so
I have to type the cases accurately. The funny thing is that while I am
typing, the intellisense does display the routine names with correct
case. But when I am done typing a statement it keeps whatever case I
typed and all other places that call that same routine will have the
same poor case. For example if the routine is 'OpenWord' but I typed
'openword', all other places in my code that were 'OpenWord' will
become 'openword' too.

Is there any technique for developing some kind of type library
interface for my Lib.mde?

The only other time I see something like that is when I've made a
declaration of the variable in a different case. Or when the modules in
the project have been damaged. To make sure of that, I do a File/Remove
(with export) in the VBA Editor, then import the modules again.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail