|
Any MS Access Buffs?
|
View this Thread in Original format
| Renegade |
Just a quick question:
Have to do an assignment for uni, where you've basically got to set up a series of databases for an imaginery company. All I need to know is how to create a macro (or module or whatever does it) that allows me to create a kinda "menu" form at the front that allows you to access all the different tables/reports/queries etc. automatically.
Do you see what I mean?
Just a form that allows you to access all the other pages at the click of a button. I did all this at school about 2 years ago, so I know it can be done, trouble is I've forgotten how to do it.
So then. Any ideas? |
|
|
| tranceaholic |
| well basicly what u do is u have a form with different command buttons. then each button in its property set it up to open a certian macro that you create which opens a certain form. do it for each button. so when u click a button it will go to the macro which will open a form assigned to it. pm me if u want more details. |
|
|
| Renegade |
Thanks mate, appreciate it.
So how would I go about, say, creating a macro to open up a particular table/query etc? |
|
|
| tranceaholic |
| well when u create a macro..u will find an open form function or whatever. when u pick open form a property box will appear,write in it the name of the form u want to open and whatever else properties u would like to set. |
|
|
| _greggy_ |
Just a little question : which version of Ms Access are you using?
And a little help : If you want to execute a macro when the user open the database you must call it autoexec. |
|
|
|
|
