Adding fields from a different query
in [Form]
|
From: Anne D. on 17 Nov 2009 11:36 I have a form built based on a main query. How do I add more fields on that form that come from a different query?
From: Jeff Boyce on 17 Nov 2009 11:59 Anne A couple possibilities... Change your first query to include the extra fields. Use your second query to "feed" a form, then embed that form as a subform on your main form. Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message news:4A0E2951-74EC-485F-8CA4-BB790865D42D(a)microsoft.com... >I have a form built based on a main query. How do I add more fields on that > form that come from a different query? >
From: Anne D. on 17 Nov 2009 15:24 My main table is maxed out for fields. I created the 2nd table/query so i could enter more categories. Now I need to enter these in the main form. Both tables are linked (table #2 linked to #1). I used the fields icon in design view to add the new fields but they are not there since the data is pulled from the table #1. How do I drop fields from table/query #2? "Jeff Boyce" wrote: > Anne > > A couple possibilities... > > Change your first query to include the extra fields. > > Use your second query to "feed" a form, then embed that form as a subform on > your main form. > > Good luck! > > Regards > > Jeff Boyce > Microsoft Access MVP > > -- > Disclaimer: This author may have received products and services mentioned > in this post. Mention and/or description of a product or service herein > does not constitute endorsement thereof. > > Any code or pseudocode included in this post is offered "as is", with no > guarantee as to suitability. > > You can thank the FTC of the USA for making this disclaimer > possible/necessary. > > "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message > news:4A0E2951-74EC-485F-8CA4-BB790865D42D(a)microsoft.com... > >I have a form built based on a main query. How do I add more fields on that > > form that come from a different query? > > > > > . >
From: KARL DEWEY on 17 Nov 2009 17:27 Sounds like you are creating a spreadsheet instead of a relational database. A well designed database should not run out of fields. You realize a form and queries will have the same limitations. But to join your two tables in a query, open in design view, select the second table, click on the field of first table that is used to link to the second table and drag to the corresponding field of the second table. -- Build a little, test a little. "Anne D." wrote: > > My main table is maxed out for fields. I created the 2nd table/query so i > could enter more categories. Now I need to enter these in the main form. Both > tables are linked (table #2 linked to #1). > I used the fields icon in design view to add the new fields but they are not > there since the data is pulled from the table #1. > How do I drop fields from table/query #2? > > "Jeff Boyce" wrote: > > > Anne > > > > A couple possibilities... > > > > Change your first query to include the extra fields. > > > > Use your second query to "feed" a form, then embed that form as a subform on > > your main form. > > > > Good luck! > > > > Regards > > > > Jeff Boyce > > Microsoft Access MVP > > > > -- > > Disclaimer: This author may have received products and services mentioned > > in this post. Mention and/or description of a product or service herein > > does not constitute endorsement thereof. > > > > Any code or pseudocode included in this post is offered "as is", with no > > guarantee as to suitability. > > > > You can thank the FTC of the USA for making this disclaimer > > possible/necessary. > > > > "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message > > news:4A0E2951-74EC-485F-8CA4-BB790865D42D(a)microsoft.com... > > >I have a form built based on a main query. How do I add more fields on that > > > form that come from a different query? > > > > > > > > > . > >
From: Jeff Boyce on 17 Nov 2009 17:56 I'm with Karl ... if you've 'maxed out' your fields, you have a spreadsheet, not a relational database table. Consider posting back a description of the data you're attempting to store in this table / these tables... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message news:20B50F49-821F-4D7E-A919-AA80A873C47D(a)microsoft.com... > > My main table is maxed out for fields. I created the 2nd table/query so i > could enter more categories. Now I need to enter these in the main form. > Both > tables are linked (table #2 linked to #1). > I used the fields icon in design view to add the new fields but they are > not > there since the data is pulled from the table #1. > How do I drop fields from table/query #2? > > "Jeff Boyce" wrote: > >> Anne >> >> A couple possibilities... >> >> Change your first query to include the extra fields. >> >> Use your second query to "feed" a form, then embed that form as a subform >> on >> your main form. >> >> Good luck! >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "Anne D." <AnneD(a)discussions.microsoft.com> wrote in message >> news:4A0E2951-74EC-485F-8CA4-BB790865D42D(a)microsoft.com... >> >I have a form built based on a main query. How do I add more fields on >> >that >> > form that come from a different query? >> > >> >> >> . >>
|
Next
|
Last
Pages: 1 2 Prev: Button for Open report by Wizard missing Docmd code. Next: Records Count Problem |