Button to open a table!

Bob · Jul 13, 2005

How can I assign a button on my main menu to open a certain table, so I can
alter some data with out going through the from page
Thanks in advance.........Bob Vance

fredg · Jul 14, 2005

How can I assign a button on my main menu to open a certain table, so I can
alter some data with out going through the from page
Thanks in advance.........Bob Vance

DoCmd.OpenTable "TableName" will open a table.

However, you should NOT be altering data directly in a table.
Use a Form.
If you want the look of a table, open the form in datasheet view.

Bob · Jul 14, 2005

Is it Ok to add and delete from Datasheet View..Thanks Bob

Bob · Jul 14, 2005

Can I create a shortcut button on my form to Datasheet View? Thanks bob

Bob said:
Is it Ok to add and delete from Datasheet View..Thanks Bob

fredg · Jul 14, 2005

Bob said:
Can I create a shortcut button on my form to Datasheet View? Thanks bob

Bob said:

Is it Ok to add and delete from Datasheet View..Thanks Bob

Click to expand...

Form Datasheet View?

DoCmd.OpenForm "FormName", acFormDS

fredg · Jul 14, 2005

Is it Ok to add and delete from Datasheet View..Thanks Bob

Form Datasheet View?
Sure.

Bob · Jul 14, 2005

fredg said:
Form Datasheet View?

DoCmd.OpenForm "FormName", acFormDS

Sorry where do I enter this code into the button.....Thanks bob

Bob · Jul 15, 2005

Bob said:
Sorry where do I enter this code into the button.....Thanks bob

GREAT worked it out Code Builder and then entered the frm name, BRILLIANT
Thanks.....Bob