View VBA Code in Microsoft Access

How do you get to the VBA code running in Microsoft Access?

I have just inherited a new project that was written by someone else in Access, and when I go into what I believe is the code (I click VIEW then CODE), only a few lines show up in one module. Would it be anywhere else because I know for a fact there is more than one module?

I know this Access database is setup all screwy. The original developer has some sort of system where a whole bunch of "copies" of the database write to one main file. If that makes any sense to anyone could you please clarify that as well.

I wonder why he didn't just write the whole thing in VB with an Access back-end. This whole damn thing is written in Access and it pisses me off! :rolleyes:

Access VBA question moved to Office Development

Dumb question but... Have you looked for Macros within the db? (as opposed to Modules)

Quote:

---

Originally Posted by The_Grudge

I know this Access database is setup all screwy. The original developer has some sort of system where a whole bunch of "copies" of the database write to one main file. If that makes any sense to anyone could you please clarify that as well.

---

Humm...sounds like he may have used the 'Database Splitter'.
If this is the case then you would have two seperate DBs. One with the tables (and very little code) and one with the Queries, Forms and Reports(with lots of code). You may be only looking at half the application if you're viewing the backend (tables) database.

Also try View -> Project Explorer to get a treeview of all modules in the project when in the VBA IDE. Some might simply be closed.

In your main acccess db press Alt+F11 to open the VBA IDE. This one should have most of your code but your other linked dbs will have some code which you can access the same way if you open each db and view the VBA IDE.