DoCmd.SelectObject acTable, , True

[Marcel Stoop]

Hi Everyone

Within my Access application I use -DoCmd.SelectObject acTable, , True- ,
to open the Datebase Screen.

1) Is it possible to open the Database screen as a mimimized form
2) Is it posible to disable the MinMaxButtons on the Database screen

Thanks for the help

 

[Dirk Goldgar]

Hi Everyone

Within my Access application I use -DoCmd.SelectObject acTable, ,
True- , to open the Datebase Screen.

1) Is it possible to open the Database screen as a mimimized form

You could probably just execute

DoCmd.Minimize

immediately after your call to DoCmd.SelectObject

2) Is it posible to disable the MinMaxButtons on the Database screen

I don't know about this one. Why do you want to do this? What's the
point of opening but minimizing the database window?

 

[Marcel Stoop]

The Idea behind it:

In some part of my code I use -DoCmd.RunCommand acCmdLinkTables- to call the
Screen for linking tables.
This only works, when the database screen is visible.
But, I do not want the user to play with or see this screen. That is the
reason why I want to open it in minimized form, and to disable the min/max
Buttons on this screen.

Cheers
Marcel

 

[Dirk Goldgar]

The Idea behind it:

In some part of my code I use -DoCmd.RunCommand acCmdLinkTables- to
call the Screen for linking tables.
This only works, when the database screen is visible.
But, I do not want the user to play with or see this screen. That is
the reason why I want to open it in minimized form, and to disable
the min/max Buttons on this screen.

Hmm. Do you need the full functionality of the wizard? You can relink
tables without running it at all; see this link for an example:

http://www.mvps.org/access/tables/tbl0009.htm
Tables: Relink Access tables from code

 

[Marcel Stoop]

Thanks for the Link.

I do not really need to relink tables. The user have to add sometimes some
new Links.

 

[Dirk Goldgar]

Thanks for the Link.

I do not really need to relink tables. The user have to add sometimes
some new Links.

If you have to, you can reproduce the entire functionality of the Linked
Table Manager in your own code: displaying the Windows File Open dialog
as needed for the user to choose the back-end database (if it's
different from the database used by existing linked tables), using DAO
methods to open that database and make a list of the tables in it,
presenting that list to the user in a list box on a form, then either
using TransferDatabase to link the tables the user selectst, or using
DAO to create linked TableDef objects for those tables. It's not
exactly trivial, but it's not terribly complicated, either.

 

[Marcel Stoop]

Thanks for the Help.
I will try reproduce the functionality of the linked table manager

Cheers
Marel