By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Access 2003 compile question

P: n/a
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".

Aug 6 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Aug 6 '08 #2

P: n/a
Chris O'C via AccessMonster.com 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".

Aug 7 '08 #3

P: n/a
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 = "vinegarandoil"

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

Aug 7 '08 #4

P: n/a
Chris O'C via AccessMonster.com 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 = "vinegarandoil"

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?

Aug 7 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.