software

A database was written by a user who is no longer with the company. The
database has a startup form that makes it easy for the users to access the
necessary fill in forms. At the end of the month the current db
administrator (who is not Access savy) presses a command button on the start
up form and the monthly data from the database is exported into an excel
worksheet. (SO I THINK) There are no procedures defined in the properties of
the button. The only identification to the excel workbook is a hyperlink to
said excel workbook. What makes this even more mysterious for me (WHO does
use Access quite a bit) is that there are 7 worksheets within the workbook
and the data from Access goes to the right worksheet.

There are no macros written in excel that I can find and in access,
I've looked at the macros and there is nothing.
I've looked at the modules and there are none.
I've looked at each individual query, form and table and again....Nothing.

I'm going to post this in access help also because I don't know where to
find the answer.

Any advise would be GREATLY appreciated.

If you open the database and then press Alt plus F11, you should get into
VBE and there should be the project window in the upper left. In that
project window, the top level should show the name of your database and
under that should be quot;Microsoft Office Access Class Objectsquot;. If there is a
form listed under that, right click it and choose quot;Show Codequot;. Can you see
any subroutines this way?

Stevequot;Sondraquot; gt; wrote in message
...
gt;A database was written by a user who is no longer with the company. The
gt; database has a startup form that makes it easy for the users to access the
gt; necessary fill in forms. At the end of the month the current db
gt; administrator (who is not Access savy) presses a command button on the
gt; start
gt; up form and the monthly data from the database is exported into an excel
gt; worksheet. (SO I THINK) There are no procedures defined in the properties
gt; of
gt; the button. The only identification to the excel workbook is a hyperlink
gt; to
gt; said excel workbook. What makes this even more mysterious for me (WHO
gt; does
gt; use Access quite a bit) is that there are 7 worksheets within the workbook
gt; and the data from Access goes to the right worksheet.
gt;
gt; There are no macros written in excel that I can find and in access,
gt; I've looked at the macros and there is nothing.
gt; I've looked at the modules and there are none.
gt; I've looked at each individual query, form and table and again....Nothing.
gt;
gt; I'm going to post this in access help also because I don't know where to
gt; find the answer.
gt;
gt; Any advise would be GREATLY appreciated.
No, there is absolutely nothing.

quot;Steve Yandlquot; wrote:

gt; If you open the database and then press Alt plus F11, you should get into
gt; VBE and there should be the project window in the upper left. In that
gt; project window, the top level should show the name of your database and
gt; under that should be quot;Microsoft Office Access Class Objectsquot;. If there is a
gt; form listed under that, right click it and choose quot;Show Codequot;. Can you see
gt; any subroutines this way?
gt;
gt; Steve
gt;
gt;
gt; quot;Sondraquot; gt; wrote in message
gt; ...
gt; gt;A database was written by a user who is no longer with the company. The
gt; gt; database has a startup form that makes it easy for the users to access the
gt; gt; necessary fill in forms. At the end of the month the current db
gt; gt; administrator (who is not Access savy) presses a command button on the
gt; gt; start
gt; gt; up form and the monthly data from the database is exported into an excel
gt; gt; worksheet. (SO I THINK) There are no procedures defined in the properties
gt; gt; of
gt; gt; the button. The only identification to the excel workbook is a hyperlink
gt; gt; to
gt; gt; said excel workbook. What makes this even more mysterious for me (WHO
gt; gt; does
gt; gt; use Access quite a bit) is that there are 7 worksheets within the workbook
gt; gt; and the data from Access goes to the right worksheet.
gt; gt;
gt; gt; There are no macros written in excel that I can find and in access,
gt; gt; I've looked at the macros and there is nothing.
gt; gt; I've looked at the modules and there are none.
gt; gt; I've looked at each individual query, form and table and again....Nothing.
gt; gt;
gt; gt; I'm going to post this in access help also because I don't know where to
gt; gt; find the answer.
gt; gt;
gt; gt; Any advise would be GREATLY appreciated.
gt;
gt;
gt;

Can these things be hidden and password protected? Could that be a reason
Sondra's not seeing them?

quot;Steve Yandlquot; gt; wrote in message
...
gt; If you open the database and then press Alt plus F11, you should get into
gt; VBE and there should be the project window in the upper left. In that
gt; project window, the top level should show the name of your database and
gt; under that should be quot;Microsoft Office Access Class Objectsquot;. If there is
gt; a form listed under that, right click it and choose quot;Show Codequot;. Can you
gt; see any subroutines this way?
gt;
gt; Steve
gt;
gt;
gt; quot;Sondraquot; gt; wrote in message
gt; ...
gt;gt;A database was written by a user who is no longer with the company. The
gt;gt; database has a startup form that makes it easy for the users to access
gt;gt; the
gt;gt; necessary fill in forms. At the end of the month the current db
gt;gt; administrator (who is not Access savy) presses a command button on the
gt;gt; start
gt;gt; up form and the monthly data from the database is exported into an excel
gt;gt; worksheet. (SO I THINK) There are no procedures defined in the
gt;gt; properties of
gt;gt; the button. The only identification to the excel workbook is a hyperlink
gt;gt; to
gt;gt; said excel workbook. What makes this even more mysterious for me (WHO
gt;gt; does
gt;gt; use Access quite a bit) is that there are 7 worksheets within the
gt;gt; workbook
gt;gt; and the data from Access goes to the right worksheet.
gt;gt;
gt;gt; There are no macros written in excel that I can find and in access,
gt;gt; I've looked at the macros and there is nothing.
gt;gt; I've looked at the modules and there are none.
gt;gt; I've looked at each individual query, form and table and
gt;gt; again....Nothing.
gt;gt;
gt;gt; I'm going to post this in access help also because I don't know where to
gt;gt; find the answer.
gt;gt;
gt;gt; Any advise would be GREATLY appreciated.
gt;
gt;