What is a module and how do I open one?

[Dave R.]

Hi, I am working within Access 2003 and have converted a database to Access
97 version for a coworker. When she opens it and attempts to open a form I
created, she gets the message something like "Access can't open the form.
the form contains data Access doesn't recognize".

Now when I converted it From 2003 to 97, it told me I was missing an Access
97 library. I have read the solution below, however I am not at all clear
how to "open a module" when I open the database in Access 97. Two questions:

1. What is a module and how can I open one? All I have in the database is
one table and one form which modifies the table; the "modules" tab contains
nothing.
2. There is a "references" tab when I open a module? I assume it will appear
once I open up a module, but for now the closest thing I see is
"releationships"...



Solution/Directons from Microsoft:

-Convert the Microsoft Access 2000 database to Microsoft Access 97. When you
receive a message that your computer is missing at least one of the Access
97 object libraries, click OK.
-Open the converted Access database in Microsoft Access 97.
-Open a module in the database.
-On the Tools menu, click References.
-In the Available References box, clear the check boxes next to any missing
references, and set a reference to the Microsoft DAO 3.51 Object Library.

 

[Douglas J Steele]

Actually, if there's no code in your database, you can get by with opening
the Debug window using Ctrl-G.

When you do that, the Tools menu will have an entry named References. Select
that menu entry, and you'll get into a dialog.

 

[Dave R.]

Thanks Doug. I actually do have some code in the form (I was using option
boxes with checkboxes and also had a reset button that nulled the option
box).

I tried to talk my coworker over the phone but when she pressed ctrl-g it
opened the debug window but she said there was no "references" in the Tool
menu.

If you have another idea on how this could be done, please let me know. I
may have to use list boxes with no code instead..

Thanks again.

 

[Douglas J. Steele]

"References" should be the first entry on the Tools menu. (By this, I mean
select the Tools menu, so that it expands, and the first entry in the
expanded menu will be References)