Access Table List View

P

poly2

Is there any way to have an Access Table list appear automatically MAXIMIZED
when the table is open. I know I can do it manually and I do not know VBA.
 
R

Rick B

Tables are not really suposed to be user interfaces. The table is simply a
place to store the data. You should not be adding data or viewing the data
directly from your table.

If you wish to view/modify/add data, then you should be using a form or a
query. To produce data output, you should use a report. You will find that
all the controls for your objects are in the reports and forms. This is
where you should be doing all your user interface. Using a form or a
report, you can maximize, minimize, control input, format output, etc.

Rick B


poly2 said:
Is there any way to have an Access Table list appear automatically MAXIMIZED
when the table is open. I know I can do it manually and I do not know
Click to expand...
VBA.
 
T

tfossum

Rick B is correct that it does require a form. Here is probably the easiest
way to do it, without invoking VBA.

First create a macro and give it a sinlgle action of "Maximize", and then
save it as something like "mcrFormMax".

Next create your form. If you are satisfied with the appearance of working
within the native table you can create a "Datasheet" form. The easiest way to
do this is using the "New" button on the "Form" screen of the database
window. Save it and give it a name, for example "frmPollysNewForm".

Enter form design mode by single clicking on frmPollysForm in the database
window, and then clicking the "Design" button. You now have a graphical
representation of the form. Don't click on anything on the form! Go to
"Properties" in the "View" menu. You now have a pop-up window that contains
properties of the form. Select the "Event" tab from the properties pop-up.
One of the events is called "On Load". From the drop-down to the right select
the "mcrFormMax" macro you created earlier.

Close the form itself and save changes. The next time you open the form it
should maximize on its own. Please let me know if you need more detailed
instructions, or if this has worked.

FYI - The macro you created can now be used by any other forms.
 
Top