Access 2003

[the undefy]

S'up Gals and Gents,

I got Access 2003 and need to know how can i reference a button from my main menu straight to my table? If you could find point me to relative information that also would be highly appreciated.

My sincere apologize for this noobish question.

Kind Regards,
Don Defy

 

[Atomic Shrimp]

I don't understand the question - Do you mean that you want a button on your form to open a table?

If so, create a form based on the table, then either set up your button to run a macro containing the OpenForm command, or build a bit of VBA code containing DoCmd.OpenForm "your form name here"

Don't let your users interact directly with a table, always present it in a form.

 

[gemma-the-husky]

a) what sort of menu is it - a standard access switchboard?
this has no facilities to open tables

because
b) you shouldnt do it anyway
you should have a form bound to the table - and use/open the form.

 

[the undefy]

OK, I'm pretty bad at this ^^

SO
I have my info in Tables.

How do i bound a form to a table?

Once its bound.

How do i assign a button that, once you click it, it opens up the info assigned to the form.

i have 9 tables. One for each button. would i need 9 forms as well?

If you could point me i n the right direction would be great! i tried Google it but couldn't fin anything :S

Thank for braking it down for me

 

[DCrake]

I take it you have not used Access before. I suggest you have alook at the Northwind sample database that comes with Access for inspriation.

David

 

[the undefy]

You Sir are absolutely right, never used it! But i cant run executables since i am using a work PC and is not for access 2000 only?. But if you can point me to relative reading material i would highly appreciate it! Something in the lines of How buttons work in access or How do i bound a form to a table kinda stuff.

Thank you

 

[DCrake]

Try
http://support.microsoft.com/

 

[Atomic Shrimp]

The simplest way to bind a table to a form is to use the form wizard to create a form based on your table. You won't get one that does everything you want that way, or looks exactly as you want it, but it will give you a working form to tinker with and scrutinise - and if you mess it up, just delete it and make another.

 

[Lightwave]

This looks pretty good...

http://office.microsoft.com/en-us/access/HP051876411033.aspx