table to a form

H

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....
 
H

Husky

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

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.
 
F

FinRazel

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.
 
H

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.
Click to expand...
I'll try that..
Tnx.
 
H

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];
Click to expand...

Worked like a charm. Tnx.
 
Top