Movesize problem

[Mike-palmer]

I want to have my form open at the top left of the Database window so I'm using Movesize 0,0 in the "form open" event.

This works great until you try and eliminate the default tool bar to save space (I want to keep only the menu items). After movesize 0,0 the form ends up below where the toolbar would be so the form is not at the top left corner.

Any ideas on fixing this?

 

[ghudson]

Works for me with Access 97. Are you removing your tool bars and menu bars first, then using the DoCmd.MoveSize 0, 0 command?

 

[Mike-palmer]

I'm removing the toolbars manually, should I be doing it with VB?

 

[ghudson]

I would use VBA. Just use the ones you need...

' Turns off the Database toolbar.
DoCmd.ShowToolbar "Database", acToolbarNo
' Turns off the Relationship toolbar.
DoCmd.ShowToolbar "Relationship", acToolbarNo
' Turns off the Table Design toolbar.
DoCmd.ShowToolbar "Table Design", acToolbarNo
' Turns off the Table Datasheet toolbar.
DoCmd.ShowToolbar "Table Datasheet", acToolbarNo
' Turns off the Query Design toolbar.
DoCmd.ShowToolbar "Query Design", acToolbarNo
' Turns off the Query Datasheet toolbar.
DoCmd.ShowToolbar "Query Datasheet", acToolbarNo
' Turns off the Form Design toolbar.
DoCmd.ShowToolbar "Form Design", acToolbarNo
' Turns off the Form View toolbar.
DoCmd.ShowToolbar "Form View", acToolbarNo
' Turns off the Filter/Sort toolbar.
DoCmd.ShowToolbar "Filter/Sort", acToolbarNo
' Turns off the Report Design toolbar.
DoCmd.ShowToolbar "Report Design", acToolbarNo
' Turns off the Print Preview toolbar.
DoCmd.ShowToolbar "Print Preview", acToolbarNo
' Turns off the Toolbox toolbar.
DoCmd.ShowToolbar "Toolbox", acToolbarNo
' Turns off the Formatting (Form/Report) toolbar.
DoCmd.ShowToolbar "Formatting (Form/Report)", acToolbarNo
' Turns off the Formatting (Datasheet) toolbar.
DoCmd.ShowToolbar "Formatting (Datasheet)", acToolbarNo
' Turns off the Macro Design toolbar.
DoCmd.ShowToolbar "Macro Design", acToolbarNo
' Turns off the Visual Basic toolbar.
DoCmd.ShowToolbar "Visual Basic", acToolbarNo
' Turns off the Utility1 toolbar.
DoCmd.ShowToolbar "Utility 1", acToolbarNo
' Turns off the Utility2 toolbar.
DoCmd.ShowToolbar "Utility 2", acToolbarNo
' Turns off the Web toolbar.
DoCmd.ShowToolbar "Web", acToolbarNo
' Turns off the Source Code Control toolbar.
DoCmd.ShowToolbar "Source Code Control", acToolbarNo


HTH