Edit Table from Switchboard

[smarty84handsome]

Can someone tell me how do i create edit table button on switchboard ?

[ItsMe]

You are trying to edit one of the switchboard tables?

[smarty84handsome]

I am sorry i didn't understand your question but in the switchboard which i have create i am able to open form, open table, close switchboard however i don't have functionality to edit table from switchboard. I know it is not the right way to do it but at my work i am requested to create a button on switchboard in which upon clicking should allow user to add new information in table.

[June7]

Did you use switchboard wizard to create the form?

There's a good reason MS has deprecated the Switchboard wizard starting with Access 2007 - it's a royal pain. It's still there but have to work to find it.

[smarty84handsome]

Did you use switchboard wizard to create the form?

There's a good reason MS has deprecated the Switchboard wizard starting with Access 2007 - it's a royal pain. It's still there but have to work to find it.

Yes i used switchboard wizard to create the form however it didn't give me any option where i can edit the table from switchboard. I believe i will have to do some VB coding can someone help me here.

[ItsMe]

I had no idea that opening a table in edit view was ever an option

[ItsMe]

I believe i will have to do some VB coding can someone help me here.

I have done that before. You could change one of the switchboard options to do something else. Find an option you do not use and have it use a different method. Only problem is I don't have 2007, I only have 2003 and 2010

[June7]

Why would you want to allow user to work directly with table, either to enter data or edit design?

[smarty84handsome]

I have done that before. You could change one of the switchboard options to do something else. Find an option you do not use and have it use a different method. Only problem is I don't have 2007, I only have 2003 and 2010

In that case can you tell me the code for changing the option to edit table mode ?

[June7]

The VBA is:

DoCmd.OpenTable "Airports", acViewDesign

From what I can recall of switchboards, they usually call macros. Could create a macro that performs that action and call the macro from the switchboard table.

But WHY design view?

I recommend eliminating the switchboard and its table. Buttons with embedded macros would be preferable and I don't use macros.

[smarty84handsome]

I will try suggested option and post the outcome

[ItsMe]

In 2003 version the Switcboard uses constants and a select case. From there, it uses a standard Docmd.OpenForm, etc. Not too difficult to edit or even add an option to the select statement by adding a constant and placing the correct integer in your table for the argument.

[smarty84handsome]

The VBA is:

DoCmd.OpenTable "Airports", acViewDesign

From what I can recall of switchboards, they usually call macros. Could create a macro that performs that action and call the macro from the switchboard table.

But WHY design view?

I recommend eliminating the switchboard and its table. Buttons with embedded macros would be preferable and I don't use macros.

I was able to solve the task by using macros.