microsoft+access+training+course - Command to move to the Table objects window

Resolved · Low Priority · Version Standard

Command to move to the Table objects window

Iain has attended:
Access VBA course

by - delegate Iain [3 posts] (2008 Jan 8 Tue, 13:36) Reply

Hi!

I've got a button on a form to close the form and I'd like to make it move to the Tables window when I click on it.

I tried...

DoCmd.GoToControl (Tables)

and

Dim db As Database
Set db = CurrentDb()

db.objects.Tables.SetFocus

...but neither worked.

Any ideas?

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Command to move to the Table objects window

by - trainer Carlos gold contributer [479 posts] (2008 Feb 6 Wed, 16:47) Reply

Hi Iain

I have looked at this and consulted with some collegues and the general opinion is you cannot use code to go to a specific view of the database.

This may be due to to the fact that in most Access databases the tables are hiden from the user.

Sorry if I couldn't help more

Carlos

RE: Command to move to the Table objects window

by - delegate Iain [3 posts] (2008 Apr 3 Thu, 10:40) Reply

Carlos

I found the code that can do this in the Northwind db, so thought I'd post it in case its of use.

Private Sub cmdGoToTablesWindow_Click()

DoCmd.Close
DoCmd.SelectObject acTable, "Core", True

End Sub

...where "Core" is the name of one of your tables. I presume it will work for forms, reports etc.

Iain

· How to Find a Third-Party Venue for Microsoft Access Training
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Tips for designing databases in Microsoft Access
· Innovation with Microsoft Access
· How To Find Good Access Database Courses In London

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Rate this page: