A Little confused

[A real begineer]

I have an application which is under evelopment in the final stages of testing. The other day I was requested to make a cut down version for another purpose. So I thought I would simply copy the other database and delete the bits it doesn't need.

I found that the modules aren't working, so I thought it was something to do with the same tags being used as names on the same form names. So I deleted the form references and redid them in an attempt to fix that problem.

However, after all that it still did not fix the problem. When I ran the code the minute it came to a Round statement the debug would fire. Saying the object is not available. I don't understand why.

 

[pcs]

a guess...

are both versions of your database running under a2k? i don't think the Round function is available in earlier versions.

hth
al

 

[DES]

You have probably messed up on one of the references.

Here is what happens. If in database A you add a control to a form for example then Access automatically sets a reference to it's ocx, dll, whatever.

Now if you copy that database or even move it to another machine the database has a reference to the ocx, dll, whatever and if that ocx etc is not in the exact same spot on the new machine or is not available in the new database then you start getting debug errors all over the place on stupid little pieces of code. This is because the objects library is no longer available to access.

So to correct the problem, you need to get into the coding window and then go up to the Tools menu bar and check the Reference option. A new window will open up with the objects that the database is referencing being at the top of the list. You will see from there if it says that something is missing.

Uncheck the missing one and scroll throught the list to find the one which is available on this system.