Form Dependencies

[Juan4412]

I have a form, that has several buttons that do some behind the scenes imports, queries etc. etc. What would be the easiest way for me to find out what all this form is dependent on, so I could copy it over to another "new" database (as well as the queries and dependencies) and not loose any of the functions of the form?

[ketbdnetbp]

Not sure of A2007 but, in A2003, select form, etc. in db window, then, go to VIEW Menu, Select: Object Dependencies. There are Radio Buttons where you can choose: Objects that depend on me or Objects I depend on. That selection will determine what items/objects show up on the list.

Hope this helps,

Jim

[Juan4412]

And this will tell me what all I need to copy over as well? What about looking at the VB behind the scenes? I don't feel like this would tell me what the dependencies are, but just throwing it out there for another perspective on that.

[boblarson]

I don't believe you can blindly follow the list though. And no, it won't tell you anything about the VBA.

[Juan4412]

bob, What do you mean "blindly" follow the list?

[boblarson]

bob, What do you mean "blindly" follow the list?

I'm not completely sure that everything will be listed.

What you can do is download the free V-Tools and use its TOTAL DEEP SEARCH tool to look for the form name which should give you a much more in depth listing of where the form name is, which would indicate its use somewhere.

[Juan4412]

I have never heard of this tool before, but it looks like it would do what I am needing it to! I will report back tomorrow.

[Juan4412]

I can not get the V-Tools to install. They give me an error of unrecognized format, and I have SP2 installed, so the troubleshooting on the page doesn't help either??????

[ketbdnetbp]

Don't know if this will help at this point but, in addition to the Object Dependencies discussed previously, there is also a Documenter in A2003 that will show an [eventprocedure]/VBA. It is usually located on database toolbar, under Analyze, choose Documenter. Then, select object.

All the best,

Jim

[Juan4412]

ketbdnetbp ---- I am not following the instructions you were meaning for the documenter? Maybe I am just work out and overlooking but can you explain further?

[ketbdnetbp]

On the ribbon there is a TAB, called Database Tools, click, then choose, Database Documenter. Once selected, a form will appear. It is organized by objects, 1 tab for tables, forms, queries, reports, modules, etc.. Select the object type first by clicking the appropriate tab. Then, select the specific object(s) you want to be documented (checkbox to the left of it's name), click OK. A report will be displayed that lists, among other things, all properties for the selected object. Including, HasModule (VBA) and [EventProcedure] (VBA).

Therefore, going back to the original post, my thought was that you could use both reports (Object Dependencies and the Documenter) to accomplish your goal.

Hope that helps,

Jim

[boblarson]

I can not get the V-Tools to install. They give me an error of unrecognized format, and I have SP2 installed, so the troubleshooting on the page doesn't help either??????

Did you download the right one for 2007? There are differing ones for different versions.

[Juan4412]

I did, I made sure it was for 2007.

[boblarson]

I did, I made sure it was for 2007.

I'm surprised because I installed it for 2007 and 2010 and it works great.

[khalid]

Did you download the right one for 2007? There are differing ones for different versions.

Can not Install the V-Tools 1.74: for Access-2010 on window 7, even if ms-access is opened as administratively by holding shift key and run as administrative...

Error Msg:
Seems that you have not enough permission to continue the current operation.

You should start Ms-Access as administrator with window vista or higher, this should be done even if you are logged in as administrator account.....you can run ms access... bla bla bla...