Access 2003 compile question

[Salad]

I have a database called MyApp.MDB. When I go into a module and want to
compile the thing, it might have, on the menu bar line "Compile
MyAppTest". IOW, the app name it's about to compile does not match the
application name. This is a bit disconcerting but seems to not affect
anything. Any reason why A2003 doesn't know the name of the app it's
compiling. I never worried about something like this with A97 since it
simply says "Compile LoadedModules" or Compile All".

[Chris O'C via AccessMonster.com]

Re: Access 2003 compile question

The reason the "compile appname" is different than the application's name is
because your vba project is named MyAppTest. When the db file is created,
the same file name is assigned to the vba project. Your file name has since
been changed, but the developer didn't change the vba project name to match
the new file name.

To fix it in the code editor, click on the menu Tools MyAppTest Properties.
On the general tab, change MyAppTest to MyApp in project name and save it.

Chris
Microsoft MVP


Salad wrote:

>I have a database called MyApp.MDB. When I go into a module and want to
>compile the thing, it might have, on the menu bar line "Compile
>MyAppTest". IOW, the app name it's about to compile does not match the
>application name. This is a bit disconcerting but seems to not affect
>anything. Any reason why A2003 doesn't know the name of the app it's
>compiling. I never worried about something like this with A97 since it
>simply says "Compile LoadedModules" or Compile All".

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200808/1

[Salad]

Re: Access 2003 compile question

Chris O'C via AccessMonster.c om wrote:

The reason the "compile appname" is different than the application's name is
because your vba project is named MyAppTest. When the db file is created,
the same file name is assigned to the vba project. Your file name has since
been changed, but the developer didn't change the vba project name to match
the new file name.
>
To fix it in the code editor, click on the menu Tools MyAppTest Properties.
On the general tab, change MyAppTest to MyApp in project name and save it.
>
Chris
Microsoft MVP

That worked. Thanks for the info.

Where would I find info on VBA project names? Is there any purpose to
them? Would anyone care what a VBA project name is?

>
>
Salad wrote:
>

>>I have a database called MyApp.MDB. When I go into a module and want to
>>compile the thing, it might have, on the menu bar line "Compile
>>MyAppTest". IOW, the app name it's about to compile does not match the
>>application name. This is a bit disconcerting but seems to not affect
>>anything. Any reason why A2003 doesn't know the name of the app it's
>>compiling. I never worried about something like this with A97 since it
>>simply says "Compile LoadedModules" or Compile All".

>
>

[Chris O'C via AccessMonster.com]

Re: Access 2003 compile question

I don't know of any official documentation, other than that pertaining to the
vba password for Access 2K and up.

It might be useful for those customizing the code editor. For instance,
instead of changing the vba project name manually, next time you could use
the following code:

Application.VBE .VBProjects(1). Name = "vinegarand oil"

Useful, eh?

Chris
Microsoft MVP


Salad wrote:

>The reason the "compile appname" is different than the application's name is
>because your vba project is named MyAppTest. When the db file is created,

>[quoted text clipped - 7 lines]

>Chris
>Microsoft MVP

>
>That worked. Thanks for the info.
>
>Where would I find info on VBA project names? Is there any purpose to
>them? Would anyone care what a VBA project name is?

--
Message posted via http://www.accessmonster.com

[Salad]

Re: Access 2003 compile question

Chris O'C via AccessMonster.c om wrote:

I don't know of any official documentation, other than that pertaining to the
vba password for Access 2K and up.
>
It might be useful for those customizing the code editor. For instance,
instead of changing the vba project name manually, next time you could use
the following code:
>
Application.VBE .VBProjects(1). Name = "vinegarand oil"
>
Useful, eh?

Totally! :)

>
Chris
Microsoft MVP
>
>
Salad wrote:
>

>>>The reason the "compile appname" is different than the application's name is
>>>because your vba project is named MyAppTest. When the db file is created,

>>
>>[quoted text clipped - 7 lines]
>>

>>>Chris
>>>Microsoft MVP

>>
>>That worked. Thanks for the info.
>>
>>Where would I find info on VBA project names? Is there any purpose to
>>them? Would anyone care what a VBA project name is?

>
>