This debug comple command jumps tp some outdated source code. What gives?

[Lou_Reed]

I am having some program trouble with the file that I have attached to the post.



When I open the frmEmail, it immediately points a out an error

chk.TicketAssigned

Okay, fair enough. When I try to debug by clicking compile from the menu it gives me a completely
different source code set. It was something from a couple of days ago and it is no longer relevant.

My executable lines a commented out. It is junk.

What is going on? I want the source that I am working on now, not something a few days ago.

I moved some subs programs around. Could that be it?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Please I really need an answer to this question. I am stuck here!

Respectfully,

Lou Reed

[pbaldy]

I'm not clear on what you mean. When I compile, it takes me to lines of code that are not commented out, and are referring to controls that don't exist on the form the code is in.

[Lou_Reed]

The lines of code that are commented out are from a previous db. I get the source code for frmEmail when I open it up and it gives an error. Fine. SO now I must debug.

When I go to the Menu and click debug then compile it says compile database5. That is not my current database that I thought that I loaded!

It is database5 and that is why I am getting all of this errors from a previous working version of the db which in my case is database5.

So how do I change what compile debug-compile from database5 to me current db?

That is the issue. I want do not care a whit about database5, I care about the current db.

So how do I get it to change the debug-compile command and not compile database5, but instead compile the current db that I loaded, the current db?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[pbaldy]

I think it's working on the current database, but I think I've seen that the original name never changes where you're seeing it. You probably also see it at the top of the Project Explorer window in the VB editor. Did you rename the db from Database5 to Division_Dashboard?

[pbaldy]

I'm talking about here by the way.

[Lou_Reed]

No I did not so I guess I will try it. Change the name in the way that you said.

Thanks.

Respectfully,


Lou reed

[Lou_Reed]

What is the command to bring up the windows/screen in your last post? That is what I think that I need?

Respectfully,

Lou Reed

[pbaldy]

On mine it shows by default. If you're not seeing it:

View/Project Explorer

I don't think you can change the name, just be aware than when you change the name of a database, the original name is kept in that area. I've noticed it but never worried about it enough to look into changing it.

[pbaldy]

Actually you can change it. If you right-click on that top line and select Database5 Properties, you can change the name shown.

[John_G]

To change the name you see in "compile xxxxx", You need to open any code module. Then, from the menu, select Tools - xxxxx Properties. You can change the Project Name in the following screen. So, when you see Database5, it is in fact referring to the Current database, because that is the name in the Properties.

When you do a compile, MS Access will attempt to compile ALL the code in the current database, not just the module you are in. This applies even to closed forms or reports. If you have disused or obsolete code with an error in it, you will continue to get compilation errors until you fix or delete the code.

[Lou_Reed]

I did change the name of the database to debug. In the source code window click Tools then Project and change it there.

It had no effect.

As you can see in the database when you click debug-compile it stills goes back to the old useless
db that I do not want to debug. I want the new one to debug. It does say debug Division-Dashboard however. But so what? It
still acts the same way. There is just a new name.

I know that you said you cannot change the name of the db and maybe this proves it. I just want to debug the current code
not some outdated code.

Any help appreciated. Thanks in advance.


Respectfully,

Lou Reed

[Lou_Reed]

The only thing that I cans see to do is to start over on this form and leave the source code behind. It may still be used to copy and pastes, but only if unavoidable.

How can I copy a file without copying the source code?

R, Lou Reed

[pbaldy]

I'm not sure you can. The form is part of the file, and the code is part of the form. I think you'd have to delete the code after copying.

[Lou_Reed]

That is what I did and it worked. I cannot say if it has not any other effect, but it stays on the correct code when I click debug-compile.

I removed the old outdated code just cut it out.

Thanks for you help. This VBA stuff can really bog you down! I have proof.

Respectfully,

Lou Reed