If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
table to a form
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.... -- more pix @ http://members.toast.net/cbminfo/index.html |
#2
|
|||
|
|||
table to a form
Husky wrote:
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. -- Joseph Meehan Dia duit |
#3
|
|||
|
|||
table to a form
On Wed, 19 Oct 2005 15:39:32 GMT, "Joseph Meehan"
wrote: Husky wrote: 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. 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. -- more pix @ http://members.toast.net/cbminfo/index.html |
#4
|
|||
|
|||
table to a form
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. "Husky" wrote: 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.... -- more pix @ http://members.toast.net/cbminfo/index.html |
#5
|
|||
|
|||
table to a form
Husky wrote:
On Wed, 19 Oct 2005 15:39:32 GMT, "Joseph Meehan" wrote: Husky wrote: 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. 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. -- Joseph Meehan Dia duit |
#6
|
|||
|
|||
table to a form
On Wed, 19 Oct 2005 10:39:03 -0700, "FinRazel"
wrote: 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" wrote: 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.... -- more pix @ http://members.toast.net/cbminfo/index.html -- more pix @ http://members.toast.net/cbminfo/index.html |
#7
|
|||
|
|||
table to a form
On Wed, 19 Oct 2005 10:39:03 -0700, "FinRazel"
wrote: 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. -- more pix @ http://members.toast.net/cbminfo/index.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Combo Box NotInList - How To Add Data To Underlying Table | 10SNUT | Using Forms | 19 | July 8th, 2005 09:12 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |