Registered: May 2001
Location: Prague, Czech Republic
Any MS Access Buffs?
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 shit 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?
May-23-2002 15:24
tranceaholic
chus & Ceballos addict
Registered: Mar 2002
Location: behind the decks
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.
May-23-2002 16:02
Renegade
____________/
Registered: May 2001
Location: Prague, Czech Republic
Thanks mate, appreciate it.
So how would I go about, say, creating a macro to open up a particular table/query etc?
May-23-2002 16:33
tranceaholic
chus & Ceballos addict
Registered: Mar 2002
Location: behind the decks
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.
May-23-2002 16:52
_greggy_
SuperLoutre
Registered: Oct 2001
Location: Dans une rivière, telle une loutre
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.
___________________
NikklassTeam trip blog
basse qui tabasse ... apéro qui fracasse
basse qui tabasse ... ti ponch de Guada qui tabasse aussi
Like we say in France, tonight you don't send woods, you send the forest !
Any MS Access Buffs?
