?
Solved

VBA Code Dependency

Posted on 2009-04-16
4
Medium Priority
?
577 Views
Last Modified: 2012-05-06
I inherit a lot of Access VBA projects from others.  It can take a lot of time to figure out how subroutines and functions relate to each other.

Is there any freeware on reasonably price software that will analyze vba code and create an outline something like Access' object dependency?

I'll award points to the person who gives me one that works and is the least expensive compared to others that work.
0
Comment
Question by:vlvawter
  • 2
  • 2
4 Comments
 
LVL 75
ID: 24159430
It doesn't get any better or cheaper than this:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

I've been using F&R for 15 years 24x7x365

get it.

mx
0
 

Author Comment

by:vlvawter
ID: 24160272
I appreciate your suggestion, but this isn't what I want.  I did something that will give me a dependency layout.  From what I can tell, this won't do that.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 400 total points
ID: 24160340
Actually, you can run a cross reference report.  However, it does not drill down endlessly on dependencies.  This question has come up before, but no one has found a free or 'cheap' tool to do this.

You might find it here, but the tools are a bit more pricey, but otherwise excellent:

http://www.fmsinc.com/Products/index.html

mx
0
 

Author Closing Comment

by:vlvawter
ID: 31571034
Well, I waited a few more days for a possible answer; so, I'll give the points to you.  If freeware or inexpensive shareware isn't there, then it isn't there.  Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question