Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help running a form

Status
Not open for further replies.

stocto

Programmer
Mar 8, 2006
3
US
I am new working with VBA and Access, I am working with an application that has been developed by someone else, i want to run just one of the forms in particular (they have all been made in access) but everytime i try to run it,the system ask me to choose one of the macros that do task that i really dont want to realize (macros that has been designed into the system to realize specific tasks like backup for example) , all i want to do is run the form in the app and go step by step, any clue how could i do this?
Sandra
 
This isn't isn't really recommended as it's too easy to break somebody else work. However, if you've got no easily understood documentation and can't talk to the original developer:

1. Back up the original database.
2. Copy the database and work on that.
3. If there are linked tables copy the datafile (back end database) and these tables are linked to the copy. Similarly look for any other datasource links. It is essential to make sure the front end database copy you have made is not linked to live data.
4. IF YOU CANNOT 2 & 3 STOP. IT IS TOO RISKY TO GO ANY FURTHER.
5. Open up the database and go to the database window.
6. Have a look at the macros and what they do. Look for any references to running other macros.
7. Open the form you want to look at in design view. If the macros are referenced directly in the form Events their names should show there.
8. Open a any module and search for the macro name to determine if the macros are referenced any of the class or general modules.

If you've got this far you'll have a fair idea of what the original developer intended and you can decouple the macros from the form properties and code.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top