Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totally Stumped
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totally Stumped
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 "Microsoft Office Access Class Objects". If there is a form listed under that, right click it and choose "Show Code". Can you see any subroutines this way? Steve "Sondra" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totally Stumped
No, there is absolutely nothing.
"Steve Yandl" wrote: 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 "Microsoft Office Access Class Objects". If there is a form listed under that, right click it and choose "Show Code". Can you see any subroutines this way? Steve "Sondra" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totally Stumped
Can these things be hidden and password protected? Could that be a reason
Sondra's not seeing them? "Steve Yandl" wrote in message ... 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 "Microsoft Office Access Class Objects". If there is a form listed under that, right click it and choose "Show Code". Can you see any subroutines this way? Steve "Sondra" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Stumped by a lookup scenario | Excel Worksheet Functions | |||
Help!!! Pivot table from mac goes totally blank on pc. | Excel Discussion (Misc queries) | |||
Simple But Stumped | Excel Discussion (Misc queries) | |||
Stumped! Collecting values into one cell. | Excel Worksheet Functions |