Open forms compact

[ocm]

Greetings,


1. When I open my forms, the access windows shows in the background. What settings do I need to change so the form open compact/smaller in size. (please see attached sample)

2. I've a split db and I would like to add a new field to existing db. I set up a test environment and would like to know the best practice adding the new field to the table and to the form. The form's record source is a table.

TIA

Regards,

[ranman256]

add new field by opening the backend, add the field.
then you can go back to the front end and add the fields to forms. (no need to relink)

you will always have the window background, so you can either
hide the db screen:
docmd.selectobject acTable, ,true
docmd.runcommand acCmdWindowHide

hide the ribbon:
docmd.showtoolbar "ribbon",actoolbarNo

maximize the form:
docmd.Maximize

[ocm]

Thanks,

Do I need to implement what you suggested in test and import it to production?

In the past my attempt doing so (add field in test & copy/paste in production) generated error. I read this might be due to current database ‘Name AutoCorrect Options’ were set to “On” and Access automatically rename the old object.

Should the Name AutoCorrect Option be turned off before I start creating the new field?


As for opening forms w/o background, do I apply the vba on the form’s on open event?

TIA

Regards,

[ocm]

Hi,


I’ve a split db with the back end on a server and copy of the front end on users’ desktop. I added a new field to the table and to the form. I then renamed the shortcut on my desktop as old and copied the updated front end on my desktop, did some testing so far so good.


1. I noticed few queries that I created in the past are missing when I opened the front end in design view. .
2. All my forms are now open large (stretching the whole monitor)

Any ideas?

My form’s record source is a table.

TIA


Regards,