A couple of how to's...

[mabyn]

I have a couple of "how do I's".
1. I need to attach a subform to a form. I would like to be able to access
the subform from the form but cannot figure out how to make "a button(?)" to
do that.
2. I keep alphabetizing a table I have by "Last Name". From this table I
created a form to input data into the table. I want to know if there is a way
to make my form update itself alphabetically. Right now I am having to arrow
through the names to find the one I want and they are in disarray.
3. Lastly, I need to print very large and, from what I read, that is
impossible in Access. Can someone explain to me how to export files to a
program that could do this? The fonts will need to be at least 100 point.

 

[John W. Vinson]

I have a couple of "how do I's".
1. I need to attach a subform to a form. I would like to be able to access
the subform from the form but cannot figure out how to make "a button(?)" to
do that.

The simplest solution is to actually use a subform! There is a Subform Control
in the toolbox, which creates a "box" on the mainform into which you put a
Form; it's linked to the mainform by a Master link Field and Child Link Field.
There are several ways to create this connection; if you have an existing
child form, simply drag it from the Forms window onto the main form in design
view.

2. I keep alphabetizing a table I have by "Last Name". From this table I
created a form to input data into the table. I want to know if there is a way
to make my form update itself alphabetically. Right now I am having to arrow
through the names to find the one I want and they are in disarray.

A table HAS NO ORDER. A table is just a big bin of records.

If you want to see records in alphabetical order on your form, simply base the
form - not on the table - but on a Query based on the table, with the name
field (or up to ten fields) sorted in the order you desire. A one-table query
like this will still be updateable and will let you easily enter new records.

You may also want to put a tool on the form to quickly jump to a desired
record rather than scrolling. To do so, use the Toolbox Wizard to add a combo
box; use the combo option "Use this combo box to find a record".

3. Lastly, I need to print very large and, from what I read, that is
impossible in Access. Can someone explain to me how to export files to a
program that could do this? The fonts will need to be at least 100 point.

You've read wrong; you can set the font to anything you like. The limitation
is that an Access Report is limited to 22" size in each direction. If you're
printing highway billboards, consider printing your report to a .pdf file and
using Adobe Acrobat - or some other suitable program - to scale up your
report.