table to a form

[Husky]

Still working on my DVD case form format. Anything to make it about 190 megs
smaller.

Did a work table and form this weekend of just the titles to see if I could
just use the table that exists and split things into separate tables instead of
all the data in the one DVD table That has titles, actress names, actor names.
image, dvdID, comments, left_sidebar, right_sidebar, tower, case_color.

I already realize the images are probably 90% of the db's size. Maybe there's a
way to get access 2003 to compress these images further ?
But for now getting the titles set up is the priority.

table titles - 900+ entries
form - room for 7 titles

The form design was like this
title 1 control source title table title
title 2 control source title table title
title 3 control source title table title
title 4 control source title table title
title 5 control source title table title
title 6 control source title table title
title 7 control source title table title

But they were all pulling their titles from the same title table. When I
entered a new name from the table into title 2, it changed all 7 titles to the
new entry.

How do I take and use just the single title table on a form and have more than
one title in 7 different text boxes ?

Just use Rocky 1, Rocky 2, Rocky 3, Rocky 4, Rocky 5 as the title examples in
the table.
how can I get rocky 1 in text box title 1, rocky 2, in text box title 2 etc....

 

[Joseph Meehan]

Still working on my DVD case form format. Anything to make it about
190 megs smaller.

Did a work table and form this weekend of just the titles to see if I
could just use the table that exists and split things into separate
tables instead of all the data in the one DVD table That has titles,
actress names, actor names. image, dvdID, comments, left_sidebar,
right_sidebar, tower, case_color.

I already realize the images are probably 90% of the db's size. Maybe
there's a way to get access 2003 to compress these images further ?
But for now getting the titles set up is the priority.

table titles - 900+ entries
form - room for 7 titles

The form design was like this
title 1 control source title table title
title 2 control source title table title
title 3 control source title table title
title 4 control source title table title
title 5 control source title table title
title 6 control source title table title
title 7 control source title table title

But they were all pulling their titles from the same title table.
When I entered a new name from the table into title 2, it changed all
7 titles to the new entry.

How do I take and use just the single title table on a form and have
more than one title in 7 different text boxes ?

Just use Rocky 1, Rocky 2, Rocky 3, Rocky 4, Rocky 5 as the title
examples in the table.
how can I get rocky 1 in text box title 1, rocky 2, in text box title
2 etc....

I think what you want is a datasheet view. Look at the form properties.

 

[Husky]

I think what you want is a datasheet view. Look at the form properties.

I haven't actually looked at the data sheet view. But the form is a CUSTOM
design I made to print DVD case labels.
What I need is how to use 1 table for 7 different text boxes on a form that
pull their data from that one table. And do it without filling all 7 text boxes
with the same title.

 

[Guest]

Create a new table in Design View. The table should have seven fields of
type TEXT, labeled title(1-7). For each field, go to the Lookup tab within
the field properties. Set the Row Source Type property to Table/Query. In
the Row Source property box, paste:

SELECT TitleTable.Title FROM TitleTable ORDER BY [Title];

where TitleTable is the name of the Table containing your titles
and Title is the name of the field within TitleTable containing your titles.

This allows seven different fields to reference one field in a different
table independently.

Build your form from the fields in this table.

 

[Joseph Meehan]

I haven't actually looked at the data sheet view. But the form is a
CUSTOM design I made to print DVD case labels.
What I need is how to use 1 table for 7 different text boxes on a
form that pull their data from that one table. And do it without
filling all 7 text boxes with the same title.

How about seven fields label1 label2 ... label5?

What you are describing is not really the same data, but rather five
different bits of data about the same object (a CD Title) and good design
would mean five fields for the five tracks.

 

[Husky]

Create a new table in Design View. The table should have seven fields of
type TEXT, labeled title(1-7). For each field, go to the Lookup tab within
the field properties. Set the Row Source Type property to Table/Query. In
the Row Source property box, paste:

SELECT TitleTable.Title FROM TitleTable ORDER BY [Title];

where TitleTable is the name of the Table containing your titles
and Title is the name of the field within TitleTable containing your titles.

This allows seven different fields to reference one field in a different
table independently.

Build your form from the fields in this table.

I'll try that..
Tnx.

 

[Husky]

Create a new table in Design View. The table should have seven fields of
type TEXT, labeled title(1-7). For each field, go to the Lookup tab within
the field properties. Set the Row Source Type property to Table/Query. In
the Row Source property box, paste:

SELECT TitleTable.Title FROM TitleTable ORDER BY [Title];

Worked like a charm. Tnx.