By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Access 97 -- how to get to VBA code?

P: n/a
Hi -- I have an Access 97 application with lots of forms/reports/VBA
code. I am in charge of maintaining it even though this is not my area
of expertise (I'm normally a .NET programmer).

So .... I have gotten an old copy of Access 97 and installed it on a
old laptop after de-installing Access XP.

The problem is, I can't figure out how to get to the
reports/forms/code, etc. I bring up the mdb file, it asks me to log
in, I log in, and it shows the start page of the application.

There are lots of menu items, but I can't figure out which one to use
to get to the code. The one that looks promising, "View > Database
Objects" is greyed out.

How are you supposed to get to the code?

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
There is normally a set of min-max-close buttons in the upper
right-hand corner of the current form(not the app). Minning or closing
would reveal the db objects.

If you don't see them (or they're disabled), or any other visible
option for closing a form, the programmer may have disabled this
capability in code. If you have the dbo's login credentials you will
probably see something different when you start the app.

Also, are you sure you aren't running simply a run-time version of
Access?

Failing the above, you may want to create a new database and import all
the objects from the original and recompile the modules. (Open any
module and select Debug>Compile ALL modules from the menu bar.)

Bob

Nov 13 '05 #2

P: n/a
One more thing...

The old db contains an autoexec macro. That macro is responsible for
startup tasks, like opening the main form. Look at it and modify it
before it locks you out again.

Bob

Nov 13 '05 #3

P: n/a
Hi Bob --

Where would I find the autoexec macro?

I do have the developer's login -- but I don't know if it's the dbo.
How do you find that? (Sorry, I am Access newbie pretty much!)

There are not any min/max buttons, just close.

Yes, it's not just a run-time version. I have been able to open this
in Access 2003 (with huge difficulty) and I have seen the code .. but I
can't change it in 2003.

I will try creating a new DB and importing -- thanks.

Cynthia

Nov 13 '05 #4

P: n/a
Hey, I found the code!

I had to go in and "unhide" it .. I had seen that, but I thought it
referred to the main form of the app, not the tables, forms, etc. But
when I "unhid" it, everything appeared! Yay!

Sheesh .. how confusing!

Nov 13 '05 #5

P: n/a
Hey, CD!

You've probably already figured this out:

1. dbo (as in sql server) is the owner, the person with all the
permissions.

2. The macros are found under the Macro tab, along side Tables,
Queries, etc.

I understand your frustration. I've been pushing Access as far as I
can since 1992, but now it's time to move everything to .net and sql.
It's still very useful, though, for experimenting.

Bob

Nov 13 '05 #6

P: n/a
It sounds like it was meant to be, the original developer seems to have done
a few things to confuse a newby who's trying to break in.

--
Terry Kreft

"CynthiaD" <cy***********@earthlink.net> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Hey, I found the code!

I had to go in and "unhide" it .. I had seen that, but I thought it
referred to the main form of the app, not the tables, forms, etc. But
when I "unhid" it, everything appeared! Yay!

Sheesh .. how confusing!

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.