|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Need report to only select the "yes" based on monthI have a table that shows the company name, start date, id number and a check
box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance If you base your report on a query, in that query you can indicate that you
only want records with a check mark (yes) by adding "Yes" to the selection criterion under that field (in the query). Regards Jeff Boyce Microsoft Office/Access MVP Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >I have a table that shows the company name, start date, id number and a >check > box (yes/no) fields. My report currently allows me to select the month I > want to report on but I need for it to only select those records in that > month that have a check mark (yes) in the field. I hope you understand > what > I am trying to say. Thanks in advance I changed my query to include the Yes/No field and ran the query and got the
results I needed and then I included that field on my report to ensure that it was only picking up the "yes" companies and it did so I took that field back out of the report as it is needless to see a column with the word "yes" for every company. Thank you for all your help! Show quoteHide quote "Jeff Boyce" wrote: > If you base your report on a query, in that query you can indicate that you > only want records with a check mark (yes) by adding "Yes" to the selection > criterion under that field (in the query). > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >I have a table that shows the company name, start date, id number and a > >check > > box (yes/no) fields. My report currently allows me to select the month I > > want to report on but I need for it to only select those records in that > > month that have a check mark (yes) in the field. I hope you understand > > what > > I am trying to say. Thanks in advance > > > How are you currently selecting the Month? Are you modifying a query,
applying a filter, or using a parameter in a query? You need to filter the check box based on whether it is checked (True or -1) or unchecked (False or 0). If you care to share what you are doing then someone can help you further with how to expand that technique. Also, please tell us the name of the check box field. '==================================================== John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '==================================================== Hedwig14 wrote: Show quoteHide quote > I have a table that shows the company name, start date, id number and a check > box (yes/no) fields. My report currently allows me to select the month I > want to report on but I need for it to only select those records in that > month that have a check mark (yes) in the field. I hope you understand what > I am trying to say. Thanks in advance Your table appears to not be correct! Please explain what you want your
database to do to clarify before you continue and run into more problems. You might have to undo then revise previous thinds in the database. Steve san***@penn.com Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > > I have a table that shows the company name, start date, id number and a > check > box (yes/no) fields. My report currently allows me to select the month I > want to report on but I need for it to only select those records in that > month that have a check mark (yes) in the field. I hope you understand > what > I am trying to say. Thanks in advance Stevie, can you actually read?
The OP is asking about adding an extra restriction to the query that defines the report. There was no indication that there was anything wrong with the table. To the OP: You are able to select records based on month, so your report should be based on a query. Can you post the query so we can show you how to modify it to include a restriction based on the check mark field. John... Visio MVP Show quoteHide quote "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > Your table appears to not be correct! Please explain what you want your > database to do to clarify before you continue and run into more problems. > You might have to undo then revise previous thinds in the database. > > Steve > san***@penn.com > > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >> >> I have a table that shows the company name, start date, id number and a >> check >> box (yes/no) fields. My report currently allows me to select the month I >> want to report on but I need for it to only select those records in that >> month that have a check mark (yes) in the field. I hope you understand >> what >> I am trying to say. Thanks in advance > > Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but
only a harasser. He flaunts that he is an MVP but notice it is not in Access. You mention your table has a field for company name. Correct table design would have a company table with CompanyID and CompanyName. Your table then would have CompanyID rather than company name. Your table would still appear to be incorrect so as previously requested please explain what you want your database to do to clarify so your table design can be further analyzed. Steve san***@penn.com Show quoteHide quote "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > > Stevie, can you actually read? > > The OP is asking about adding an extra restriction to the query that > defines the report. There was no indication that there was anything wrong > with the table. > > To the OP: You are able to select records based on month, so your report > should be based on a query. Can you post the query so we can show you how > to modify it to include a restriction based on the check mark field. > > John... Visio MVP > > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >> Your table appears to not be correct! Please explain what you want your >> database to do to clarify before you continue and run into more problems. >> You might have to undo then revise previous thinds in the database. >> >> Steve >> san***@penn.com >> >> >> >> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >>> >>> I have a table that shows the company name, start date, id number and a >>> check >>> box (yes/no) fields. My report currently allows me to select the month >>> I >>> want to report on but I need for it to only select those records in that >>> month that have a check mark (yes) in the field. I hope you understand >>> what >>> I am trying to say. Thanks in advance >> >> > > My report is based on a query and my table does have a CompanyName as well as
CompanyID...I just didn't mention all the fields in my table as I figured it was not relevant to the question that I needed to be answered. I'm not sure if you still need me to post the query since I have the results that I need. Let me know. Show quoteHide quote "Steve" wrote: > Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup but > only a harasser. He flaunts that he is an MVP but notice it is not in > Access. > > You mention your table has a field for company name. Correct table design > would have a company table with CompanyID and CompanyName. Your table then > would have CompanyID rather than company name. Your table would still appear > to be incorrect so as previously requested please explain what you want your > database to do to clarify so your table design can be further analyzed. > > Steve > san***@penn.com > > > > "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > > > > Stevie, can you actually read? > > > > The OP is asking about adding an extra restriction to the query that > > defines the report. There was no indication that there was anything wrong > > with the table. > > > > To the OP: You are able to select records based on month, so your report > > should be based on a query. Can you post the query so we can show you how > > to modify it to include a restriction based on the check mark field. > > > > John... Visio MVP > > > > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > >> Your table appears to not be correct! Please explain what you want your > >> database to do to clarify before you continue and run into more problems. > >> You might have to undo then revise previous thinds in the database. > >> > >> Steve > >> san***@penn.com > >> > >> > >> > >> > >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >>> > >>> I have a table that shows the company name, start date, id number and a > >>> check > >>> box (yes/no) fields. My report currently allows me to select the month > >>> I > >>> want to report on but I need for it to only select those records in that > >>> month that have a check mark (yes) in the field. I hope you understand > >>> what > >>> I am trying to say. Thanks in advance > >> > >> > > > > > > > So you were able to add the extra condition to your report?
Steve is our local troll who ignores the questions asked and tries to convince posters that they need his help (for a reasonable fee). If you had responded, he would have found some way of indicating that your tables needed rework and he was the only one who can do it. John... Visio MVP Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > My report is based on a query and my table does have a CompanyName as well > as > CompanyID...I just didn't mention all the fields in my table as I figured > it > was not relevant to the question that I needed to be answered. I'm not > sure > if you still need me to post the query since I have the results that I > need. > Let me know. > > "Steve" wrote: > >> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup >> but >> only a harasser. He flaunts that he is an MVP but notice it is not in >> Access. >> >> You mention your table has a field for company name. Correct table design >> would have a company table with CompanyID and CompanyName. Your table >> then >> would have CompanyID rather than company name. Your table would still >> appear >> to be incorrect so as previously requested please explain what you want >> your >> database to do to clarify so your table design can be further analyzed. >> >> Steve >> san***@penn.com >> >> >> >> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >> > >> > Stevie, can you actually read? >> > >> > The OP is asking about adding an extra restriction to the query that >> > defines the report. There was no indication that there was anything >> > wrong >> > with the table. >> > >> > To the OP: You are able to select records based on month, so your >> > report >> > should be based on a query. Can you post the query so we can show you >> > how >> > to modify it to include a restriction based on the check mark field. >> > >> > John... Visio MVP >> > >> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >> > in >> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >> >> Your table appears to not be correct! Please explain what you want >> >> your >> >> database to do to clarify before you continue and run into more >> >> problems. >> >> You might have to undo then revise previous thinds in the database. >> >> >> >> Steve >> >> san***@penn.com >> >> >> >> >> >> >> >> >> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >> >>> >> >>> I have a table that shows the company name, start date, id number and >> >>> a >> >>> check >> >>> box (yes/no) fields. My report currently allows me to select the >> >>> month >> >>> I >> >>> want to report on but I need for it to only select those records in >> >>> that >> >>> month that have a check mark (yes) in the field. I hope you >> >>> understand >> >>> what >> >>> I am trying to say. Thanks in advance >> >> >> >> >> > >> > >> >> >> Once again you got a response from the IGNORANT stalker! He flaunts that he
is an MVP but notice it is not in Access. Look at your thread and you will see he provided no help in trying to solve your problem. Ignore the ignorant SOB. Many times in problems posted to the newsgroup, the underlying problem is misdesign of tables. A poster will ask how to do something and most ti,es an answer can be found. However the misdesign of the tables still persists and sooner or later another problem will arise. At his point the misdesign of the tables becomes obvious and a redesign ensues. The redesign then makes a redo of the solution to the first question necessary. If you post your relevant tables in the form of: TblCompany CompanyID CompanyName with a little explanation of your database, I will be glad to give you an evaluation of the design of your tabls. Steve sam***@penn.com Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > > My report is based on a query and my table does have a CompanyName as well > as > CompanyID...I just didn't mention all the fields in my table as I figured > it > was not relevant to the question that I needed to be answered. I'm not > sure > if you still need me to post the query since I have the results that I > need. > Let me know. > > "Steve" wrote: > >> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup >> but >> only a harasser. He flaunts that he is an MVP but notice it is not in >> Access. >> >> You mention your table has a field for company name. Correct table design >> would have a company table with CompanyID and CompanyName. Your table >> then >> would have CompanyID rather than company name. Your table would still >> appear >> to be incorrect so as previously requested please explain what you want >> your >> database to do to clarify so your table design can be further analyzed. >> >> Steve >> san***@penn.com >> >> >> >> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >> > >> > Stevie, can you actually read? >> > >> > The OP is asking about adding an extra restriction to the query that >> > defines the report. There was no indication that there was anything >> > wrong >> > with the table. >> > >> > To the OP: You are able to select records based on month, so your >> > report >> > should be based on a query. Can you post the query so we can show you >> > how >> > to modify it to include a restriction based on the check mark field. >> > >> > John... Visio MVP >> > >> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >> > in >> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >> >> Your table appears to not be correct! Please explain what you want >> >> your >> >> database to do to clarify before you continue and run into more >> >> problems. >> >> You might have to undo then revise previous thinds in the database. >> >> >> >> Steve >> >> san***@penn.com >> >> >> >> >> >> >> >> >> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >> >>> >> >>> I have a table that shows the company name, start date, id number and >> >>> a >> >>> check >> >>> box (yes/no) fields. My report currently allows me to select the >> >>> month >> >>> I >> >>> want to report on but I need for it to only select those records in >> >>> that >> >>> month that have a check mark (yes) in the field. I hope you >> >>> understand >> >>> what >> >>> I am trying to say. Thanks in advance >> >> >> >> >> > >> > >> >> >> Give it up steve, you are just digging your own hole deeper.
So how much will you charge to redesign his "tabls"? John... Visio MVP Show quoteHide quote "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > Once again you got a response from the IGNORANT stalker! He flaunts that > he is an MVP but notice it is not in Access. Look at your thread and you > will see he provided no help in trying to solve your problem. Ignore the > ignorant SOB. > > Many times in problems posted to the newsgroup, the underlying problem is > misdesign of tables. A poster will ask how to do something and most ti,es > an answer can be found. However the misdesign of the tables still persists > and sooner or later another problem will arise. At his point the misdesign > of the tables becomes obvious and a redesign ensues. The redesign then > makes a redo of the solution to the first question necessary. > > If you post your relevant tables in the form of: > TblCompany > CompanyID > CompanyName > > with a little explanation of your database, I will be glad to give you an > evaluation of the design of your tabls. > > Steve > sam***@penn.com > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... >> >> My report is based on a query and my table does have a CompanyName as >> well as >> CompanyID...I just didn't mention all the fields in my table as I figured >> it >> was not relevant to the question that I needed to be answered. I'm not >> sure >> if you still need me to post the query since I have the results that I >> need. >> Let me know. >> >> "Steve" wrote: >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup >>> but >>> only a harasser. He flaunts that he is an MVP but notice it is not in >>> Access. >>> >>> You mention your table has a field for company name. Correct table >>> design >>> would have a company table with CompanyID and CompanyName. Your table >>> then >>> would have CompanyID rather than company name. Your table would still >>> appear >>> to be incorrect so as previously requested please explain what you want >>> your >>> database to do to clarify so your table design can be further analyzed. >>> >>> Steve >>> san***@penn.com >>> >>> >>> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >>> > >>> > Stevie, can you actually read? >>> > >>> > The OP is asking about adding an extra restriction to the query that >>> > defines the report. There was no indication that there was anything >>> > wrong >>> > with the table. >>> > >>> > To the OP: You are able to select records based on month, so your >>> > report >>> > should be based on a query. Can you post the query so we can show you >>> > how >>> > to modify it to include a restriction based on the check mark field. >>> > >>> > John... Visio MVP >>> > >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >>> > in >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >>> >> Your table appears to not be correct! Please explain what you want >>> >> your >>> >> database to do to clarify before you continue and run into more >>> >> problems. >>> >> You might have to undo then revise previous thinds in the database. >>> >> >>> >> Steve >>> >> san***@penn.com >>> >> >>> >> >>> >> >>> >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >>> >>> >>> >>> I have a table that shows the company name, start date, id number >>> >>> and a >>> >>> check >>> >>> box (yes/no) fields. My report currently allows me to select the >>> >>> month >>> >>> I >>> >>> want to report on but I need for it to only select those records in >>> >>> that >>> >>> month that have a check mark (yes) in the field. I hope you >>> >>> understand >>> >>> what >>> >>> I am trying to say. Thanks in advance >>> >> >>> >> >>> > >>> > >>> >>> >>> > > Steve wrote:
Show quoteHide quote > Once again you got a response from the IGNORANT stalker! He flaunts that he John is a respected professional with what amounts to an award from > is an MVP but notice it is not in Access. Look at your thread and you will > see he provided no help in trying to solve your problem. Ignore the ignorant > SOB. > > Many times in problems posted to the newsgroup, the underlying problem is > misdesign of tables. A poster will ask how to do something and most ti,es an > answer can be found. However the misdesign of the tables still persists and > sooner or later another problem will arise. At his point the misdesign of > the tables becomes obvious and a redesign ensues. The redesign then makes a > redo of the solution to the first question necessary. > > If you post your relevant tables in the form of: > TblCompany > CompanyID > CompanyName > > with a little explanation of your database, I will be glad to give you an > evaluation of the design of your tabls. > > Steve > sam***@penn.com > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... >> My report is based on a query and my table does have a CompanyName as well >> as >> CompanyID...I just didn't mention all the fields in my table as I figured >> it >> was not relevant to the question that I needed to be answered. I'm not >> sure >> if you still need me to post the query since I have the results that I >> need. >> Let me know. >> >> "Steve" wrote: >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup >>> but >>> only a harasser. He flaunts that he is an MVP but notice it is not in >>> Access. >>> >>> You mention your table has a field for company name. Correct table design >>> would have a company table with CompanyID and CompanyName. Your table >>> then >>> would have CompanyID rather than company name. Your table would still >>> appear >>> to be incorrect so as previously requested please explain what you want >>> your >>> database to do to clarify so your table design can be further analyzed. >>> >>> Steve >>> san***@penn.com >>> >>> >>> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >>>> Stevie, can you actually read? >>>> >>>> The OP is asking about adding an extra restriction to the query that >>>> defines the report. There was no indication that there was anything >>>> wrong >>>> with the table. >>>> >>>> To the OP: You are able to select records based on month, so your >>>> report >>>> should be based on a query. Can you post the query so we can show you >>>> how >>>> to modify it to include a restriction based on the check mark field. >>>> >>>> John... Visio MVP >>>> >>>> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >>>> in >>>> message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >>>>> Your table appears to not be correct! Please explain what you want >>>>> your >>>>> database to do to clarify before you continue and run into more >>>>> problems. >>>>> You might have to undo then revise previous thinds in the database. >>>>> >>>>> Steve >>>>> san***@penn.com >>>>> >>>>> >>>>> >>>>> >>>>> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >>>>> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >>>>>> I have a table that shows the company name, start date, id number and >>>>>> a >>>>>> check >>>>>> box (yes/no) fields. My report currently allows me to select the >>>>>> month >>>>>> I >>>>>> want to report on but I need for it to only select those records in >>>>>> that >>>>>> month that have a check mark (yes) in the field. I hope you >>>>>> understand >>>>>> what >>>>>> I am trying to say. Thanks in advance >>>>> >>>> >>> >>> > > Microsoft. Steve evidently isn't, and has given some very questionable advice here. John offers his advice without asking for payment. Steve is constantly touting for paid work, to the great annoyance of the volunteers here. So, do you want an expert's advice, for free, or do you want Steve's offer? Your choice. Phil, London Easier to just ask for clarification than presume you know...
Regards Jeff Boyce Microsoft Office/Access MVP Show quoteHide quote "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > Once again you got a response from the IGNORANT stalker! He flaunts that > he is an MVP but notice it is not in Access. Look at your thread and you > will see he provided no help in trying to solve your problem. Ignore the > ignorant SOB. > > Many times in problems posted to the newsgroup, the underlying problem is > misdesign of tables. A poster will ask how to do something and most ti,es > an answer can be found. However the misdesign of the tables still persists > and sooner or later another problem will arise. At his point the misdesign > of the tables becomes obvious and a redesign ensues. The redesign then > makes a redo of the solution to the first question necessary. > > If you post your relevant tables in the form of: > TblCompany > CompanyID > CompanyName > > with a little explanation of your database, I will be glad to give you an > evaluation of the design of your tabls. > > Steve > sam***@penn.com > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... >> >> My report is based on a query and my table does have a CompanyName as >> well as >> CompanyID...I just didn't mention all the fields in my table as I figured >> it >> was not relevant to the question that I needed to be answered. I'm not >> sure >> if you still need me to post the query since I have the results that I >> need. >> Let me know. >> >> "Steve" wrote: >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup >>> but >>> only a harasser. He flaunts that he is an MVP but notice it is not in >>> Access. >>> >>> You mention your table has a field for company name. Correct table >>> design >>> would have a company table with CompanyID and CompanyName. Your table >>> then >>> would have CompanyID rather than company name. Your table would still >>> appear >>> to be incorrect so as previously requested please explain what you want >>> your >>> database to do to clarify so your table design can be further analyzed. >>> >>> Steve >>> san***@penn.com >>> >>> >>> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >>> > >>> > Stevie, can you actually read? >>> > >>> > The OP is asking about adding an extra restriction to the query that >>> > defines the report. There was no indication that there was anything >>> > wrong >>> > with the table. >>> > >>> > To the OP: You are able to select records based on month, so your >>> > report >>> > should be based on a query. Can you post the query so we can show you >>> > how >>> > to modify it to include a restriction based on the check mark field. >>> > >>> > John... Visio MVP >>> > >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >>> > in >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >>> >> Your table appears to not be correct! Please explain what you want >>> >> your >>> >> database to do to clarify before you continue and run into more >>> >> problems. >>> >> You might have to undo then revise previous thinds in the database. >>> >> >>> >> Steve >>> >> san***@penn.com >>> >> >>> >> >>> >> >>> >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >>> >>> >>> >>> I have a table that shows the company name, start date, id number >>> >>> and a >>> >>> check >>> >>> box (yes/no) fields. My report currently allows me to select the >>> >>> month >>> >>> I >>> >>> want to report on but I need for it to only select those records in >>> >>> that >>> >>> month that have a check mark (yes) in the field. I hope you >>> >>> understand >>> >>> what >>> >>> I am trying to say. Thanks in advance >>> >> >>> >> >>> > >>> > >>> >>> >>> > > I agree Jeff and I would sooner have all the information to avoid problems
later as these companies are constantly being updated and such. So here goes: Report is based on qryCompanies which is based on Companies as my table. Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and numbers as identifiers or file numbers), Owned (Yes/No). QryCompanies = Fields are Companies.* and CompanyName (descending) using the Table Companies. On my form the label (Owned) has the Checkbox so this is the one that I would like for the report to only show if it is checked as we are only interested in those companies that are owned. I hope this will help clear things up and guide the correct answer. Show quoteHide quote "Jeff Boyce" wrote: > Easier to just ask for clarification than presume you know... > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > > Once again you got a response from the IGNORANT stalker! He flaunts that > > he is an MVP but notice it is not in Access. Look at your thread and you > > will see he provided no help in trying to solve your problem. Ignore the > > ignorant SOB. > > > > Many times in problems posted to the newsgroup, the underlying problem is > > misdesign of tables. A poster will ask how to do something and most ti,es > > an answer can be found. However the misdesign of the tables still persists > > and sooner or later another problem will arise. At his point the misdesign > > of the tables becomes obvious and a redesign ensues. The redesign then > > makes a redo of the solution to the first question necessary. > > > > If you post your relevant tables in the form of: > > TblCompany > > CompanyID > > CompanyName > > > > with a little explanation of your database, I will be glad to give you an > > evaluation of the design of your tabls. > > > > Steve > > sam***@penn.com > > > > > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > >> > >> My report is based on a query and my table does have a CompanyName as > >> well as > >> CompanyID...I just didn't mention all the fields in my table as I figured > >> it > >> was not relevant to the question that I needed to be answered. I'm not > >> sure > >> if you still need me to post the query since I have the results that I > >> need. > >> Let me know. > >> > >> "Steve" wrote: > >> > >>> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup > >>> but > >>> only a harasser. He flaunts that he is an MVP but notice it is not in > >>> Access. > >>> > >>> You mention your table has a field for company name. Correct table > >>> design > >>> would have a company table with CompanyID and CompanyName. Your table > >>> then > >>> would have CompanyID rather than company name. Your table would still > >>> appear > >>> to be incorrect so as previously requested please explain what you want > >>> your > >>> database to do to clarify so your table design can be further analyzed. > >>> > >>> Steve > >>> san***@penn.com > >>> > >>> > >>> > >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > >>> > > >>> > Stevie, can you actually read? > >>> > > >>> > The OP is asking about adding an extra restriction to the query that > >>> > defines the report. There was no indication that there was anything > >>> > wrong > >>> > with the table. > >>> > > >>> > To the OP: You are able to select records based on month, so your > >>> > report > >>> > should be based on a query. Can you post the query so we can show you > >>> > how > >>> > to modify it to include a restriction based on the check mark field. > >>> > > >>> > John... Visio MVP > >>> > > >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote > >>> > in > >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > >>> >> Your table appears to not be correct! Please explain what you want > >>> >> your > >>> >> database to do to clarify before you continue and run into more > >>> >> problems. > >>> >> You might have to undo then revise previous thinds in the database. > >>> >> > >>> >> Steve > >>> >> san***@penn.com > >>> >> > >>> >> > >>> >> > >>> >> > >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >>> >>> > >>> >>> I have a table that shows the company name, start date, id number > >>> >>> and a > >>> >>> check > >>> >>> box (yes/no) fields. My report currently allows me to select the > >>> >>> month > >>> >>> I > >>> >>> want to report on but I need for it to only select those records in > >>> >>> that > >>> >>> month that have a check mark (yes) in the field. I hope you > >>> >>> understand > >>> >>> what > >>> >>> I am trying to say. Thanks in advance > >>> >> > >>> >> > >>> > > >>> > > >>> > >>> > >>> > > > > > > > Just to expand as well, I use an opening form called frmReportMonthDue which
uses a combo box to select the month with a value list and row source of "January"; "February"; etc. Once you select the month based on the BusinessDate it opens the Report (rptCompanyList). This is the report that I need to have it filter to only list those owned companies that have the checkbox. Show quoteHide quote "Hedwig14" wrote: > I agree Jeff and I would sooner have all the information to avoid problems > later as these companies are constantly being updated and such. So here goes: > Report is based on qryCompanies which is based on Companies as my table. > > Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters and > numbers as identifiers or file numbers), Owned (Yes/No). > > QryCompanies = Fields are Companies.* and CompanyName (descending) using the > Table Companies. > > On my form the label (Owned) has the Checkbox so this is the one that I > would like for the report to only show if it is checked as we are only > interested in those companies that are owned. > > I hope this will help clear things up and guide the correct answer. > > "Jeff Boyce" wrote: > > > Easier to just ask for clarification than presume you know... > > > > Regards > > > > Jeff Boyce > > Microsoft Office/Access MVP > > > > > > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > > message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > > > Once again you got a response from the IGNORANT stalker! He flaunts that > > > he is an MVP but notice it is not in Access. Look at your thread and you > > > will see he provided no help in trying to solve your problem. Ignore the > > > ignorant SOB. > > > > > > Many times in problems posted to the newsgroup, the underlying problem is > > > misdesign of tables. A poster will ask how to do something and most ti,es > > > an answer can be found. However the misdesign of the tables still persists > > > and sooner or later another problem will arise. At his point the misdesign > > > of the tables becomes obvious and a redesign ensues. The redesign then > > > makes a redo of the solution to the first question necessary. > > > > > > If you post your relevant tables in the form of: > > > TblCompany > > > CompanyID > > > CompanyName > > > > > > with a little explanation of your database, I will be glad to give you an > > > evaluation of the design of your tabls. > > > > > > Steve > > > sam***@penn.com > > > > > > > > > > > > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > > > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > > >> > > >> My report is based on a query and my table does have a CompanyName as > > >> well as > > >> CompanyID...I just didn't mention all the fields in my table as I figured > > >> it > > >> was not relevant to the question that I needed to be answered. I'm not > > >> sure > > >> if you still need me to post the query since I have the results that I > > >> need. > > >> Let me know. > > >> > > >> "Steve" wrote: > > >> > > >>> Ignore this IGNORANT stalker! He is not a contribitor to the newsgroup > > >>> but > > >>> only a harasser. He flaunts that he is an MVP but notice it is not in > > >>> Access. > > >>> > > >>> You mention your table has a field for company name. Correct table > > >>> design > > >>> would have a company table with CompanyID and CompanyName. Your table > > >>> then > > >>> would have CompanyID rather than company name. Your table would still > > >>> appear > > >>> to be incorrect so as previously requested please explain what you want > > >>> your > > >>> database to do to clarify so your table design can be further analyzed. > > >>> > > >>> Steve > > >>> san***@penn.com > > >>> > > >>> > > >>> > > >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > > >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > > >>> > > > >>> > Stevie, can you actually read? > > >>> > > > >>> > The OP is asking about adding an extra restriction to the query that > > >>> > defines the report. There was no indication that there was anything > > >>> > wrong > > >>> > with the table. > > >>> > > > >>> > To the OP: You are able to select records based on month, so your > > >>> > report > > >>> > should be based on a query. Can you post the query so we can show you > > >>> > how > > >>> > to modify it to include a restriction based on the check mark field. > > >>> > > > >>> > John... Visio MVP > > >>> > > > >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote > > >>> > in > > >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > > >>> >> Your table appears to not be correct! Please explain what you want > > >>> >> your > > >>> >> database to do to clarify before you continue and run into more > > >>> >> problems. > > >>> >> You might have to undo then revise previous thinds in the database. > > >>> >> > > >>> >> Steve > > >>> >> san***@penn.com > > >>> >> > > >>> >> > > >>> >> > > >>> >> > > >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > > >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > > >>> >>> > > >>> >>> I have a table that shows the company name, start date, id number > > >>> >>> and a > > >>> >>> check > > >>> >>> box (yes/no) fields. My report currently allows me to select the > > >>> >>> month > > >>> >>> I > > >>> >>> want to report on but I need for it to only select those records in > > >>> >>> that > > >>> >>> month that have a check mark (yes) in the field. I hope you > > >>> >>> understand > > >>> >>> what > > >>> >>> I am trying to say. Thanks in advance > > >>> >> > > >>> >> > > >>> > > > >>> > > > >>> > > >>> > > >>> > > > > > > > > > > > > Open the query QryCompanies in design view and add True to the Criteria row
for the field [Owned] John... Visio MVP Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:9F0B32C1-2F32-46DB-9845-9CAAAF32A0A0@microsoft.com... >I agree Jeff and I would sooner have all the information to avoid problems > later as these companies are constantly being updated and such. So here > goes: > Report is based on qryCompanies which is based on Companies as my table. > > Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters > and > numbers as identifiers or file numbers), Owned (Yes/No). > > QryCompanies = Fields are Companies.* and CompanyName (descending) using > the > Table Companies. > > On my form the label (Owned) has the Checkbox so this is the one that I > would like for the report to only show if it is checked as we are only > interested in those companies that are owned. > > I hope this will help clear things up and guide the correct answer. > > "Jeff Boyce" wrote: > >> Easier to just ask for clarification than presume you know... >> >> Regards >> >> Jeff Boyce >> Microsoft Office/Access MVP >> >> >> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... >> > Once again you got a response from the IGNORANT stalker! He flaunts >> > that >> > he is an MVP but notice it is not in Access. Look at your thread and >> > you >> > will see he provided no help in trying to solve your problem. Ignore >> > the >> > ignorant SOB. >> > >> > Many times in problems posted to the newsgroup, the underlying problem >> > is >> > misdesign of tables. A poster will ask how to do something and most >> > ti,es >> > an answer can be found. However the misdesign of the tables still >> > persists >> > and sooner or later another problem will arise. At his point the >> > misdesign >> > of the tables becomes obvious and a redesign ensues. The redesign then >> > makes a redo of the solution to the first question necessary. >> > >> > If you post your relevant tables in the form of: >> > TblCompany >> > CompanyID >> > CompanyName >> > >> > with a little explanation of your database, I will be glad to give you >> > an >> > evaluation of the design of your tabls. >> > >> > Steve >> > sam***@penn.com >> > >> > >> > >> > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... >> >> >> >> My report is based on a query and my table does have a CompanyName as >> >> well as >> >> CompanyID...I just didn't mention all the fields in my table as I >> >> figured >> >> it >> >> was not relevant to the question that I needed to be answered. I'm >> >> not >> >> sure >> >> if you still need me to post the query since I have the results that I >> >> need. >> >> Let me know. >> >> >> >> "Steve" wrote: >> >> >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the >> >>> newsgroup >> >>> but >> >>> only a harasser. He flaunts that he is an MVP but notice it is not in >> >>> Access. >> >>> >> >>> You mention your table has a field for company name. Correct table >> >>> design >> >>> would have a company table with CompanyID and CompanyName. Your table >> >>> then >> >>> would have CompanyID rather than company name. Your table would still >> >>> appear >> >>> to be incorrect so as previously requested please explain what you >> >>> want >> >>> your >> >>> database to do to clarify so your table design can be further >> >>> analyzed. >> >>> >> >>> Steve >> >>> san***@penn.com >> >>> >> >>> >> >>> >> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >> >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >> >>> > >> >>> > Stevie, can you actually read? >> >>> > >> >>> > The OP is asking about adding an extra restriction to the query >> >>> > that >> >>> > defines the report. There was no indication that there was anything >> >>> > wrong >> >>> > with the table. >> >>> > >> >>> > To the OP: You are able to select records based on month, so your >> >>> > report >> >>> > should be based on a query. Can you post the query so we can show >> >>> > you >> >>> > how >> >>> > to modify it to include a restriction based on the check mark >> >>> > field. >> >>> > >> >>> > John... Visio MVP >> >>> > >> >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> >> >>> > wrote >> >>> > in >> >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >> >>> >> Your table appears to not be correct! Please explain what you want >> >>> >> your >> >>> >> database to do to clarify before you continue and run into more >> >>> >> problems. >> >>> >> You might have to undo then revise previous thinds in the >> >>> >> database. >> >>> >> >> >>> >> Steve >> >>> >> san***@penn.com >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >> >>> >>> >> >>> >>> I have a table that shows the company name, start date, id number >> >>> >>> and a >> >>> >>> check >> >>> >>> box (yes/no) fields. My report currently allows me to select the >> >>> >>> month >> >>> >>> I >> >>> >>> want to report on but I need for it to only select those records >> >>> >>> in >> >>> >>> that >> >>> >>> month that have a check mark (yes) in the field. I hope you >> >>> >>> understand >> >>> >>> what >> >>> >>> I am trying to say. Thanks in advance >> >>> >> >> >>> >> >> >>> > >> >>> > >> >>> >> >>> >> >>> >> > >> > >> >> >> Unfortunately, I am getting the problem that happened when I first did the
same thing but I added Yes and not True which is that the check box on my form grays out and does not allow me to edit although the report gives me the results that I am looking for. I added the field to my query and added True to the criteria and ran the query which ran fine and the report did what I needed but I have to be able to have the checkbox on my form editable at all times thus to allowing the report to change if a company is removed or no longer owned. Am I supposed to change something on my form with the checkbox as well? Show quoteHide quote "John... Visio MVP" wrote: > Open the query QryCompanies in design view and add True to the Criteria row > for the field [Owned] > > John... Visio MVP > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:9F0B32C1-2F32-46DB-9845-9CAAAF32A0A0@microsoft.com... > >I agree Jeff and I would sooner have all the information to avoid problems > > later as these companies are constantly being updated and such. So here > > goes: > > Report is based on qryCompanies which is based on Companies as my table. > > > > Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName > > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters > > and > > numbers as identifiers or file numbers), Owned (Yes/No). > > > > QryCompanies = Fields are Companies.* and CompanyName (descending) using > > the > > Table Companies. > > > > On my form the label (Owned) has the Checkbox so this is the one that I > > would like for the report to only show if it is checked as we are only > > interested in those companies that are owned. > > > > I hope this will help clear things up and guide the correct answer. > > > > "Jeff Boyce" wrote: > > > >> Easier to just ask for clarification than presume you know... > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Office/Access MVP > >> > >> > >> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > >> > Once again you got a response from the IGNORANT stalker! He flaunts > >> > that > >> > he is an MVP but notice it is not in Access. Look at your thread and > >> > you > >> > will see he provided no help in trying to solve your problem. Ignore > >> > the > >> > ignorant SOB. > >> > > >> > Many times in problems posted to the newsgroup, the underlying problem > >> > is > >> > misdesign of tables. A poster will ask how to do something and most > >> > ti,es > >> > an answer can be found. However the misdesign of the tables still > >> > persists > >> > and sooner or later another problem will arise. At his point the > >> > misdesign > >> > of the tables becomes obvious and a redesign ensues. The redesign then > >> > makes a redo of the solution to the first question necessary. > >> > > >> > If you post your relevant tables in the form of: > >> > TblCompany > >> > CompanyID > >> > CompanyName > >> > > >> > with a little explanation of your database, I will be glad to give you > >> > an > >> > evaluation of the design of your tabls. > >> > > >> > Steve > >> > sam***@penn.com > >> > > >> > > >> > > >> > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > >> >> > >> >> My report is based on a query and my table does have a CompanyName as > >> >> well as > >> >> CompanyID...I just didn't mention all the fields in my table as I > >> >> figured > >> >> it > >> >> was not relevant to the question that I needed to be answered. I'm > >> >> not > >> >> sure > >> >> if you still need me to post the query since I have the results that I > >> >> need. > >> >> Let me know. > >> >> > >> >> "Steve" wrote: > >> >> > >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the > >> >>> newsgroup > >> >>> but > >> >>> only a harasser. He flaunts that he is an MVP but notice it is not in > >> >>> Access. > >> >>> > >> >>> You mention your table has a field for company name. Correct table > >> >>> design > >> >>> would have a company table with CompanyID and CompanyName. Your table > >> >>> then > >> >>> would have CompanyID rather than company name. Your table would still > >> >>> appear > >> >>> to be incorrect so as previously requested please explain what you > >> >>> want > >> >>> your > >> >>> database to do to clarify so your table design can be further > >> >>> analyzed. > >> >>> > >> >>> Steve > >> >>> san***@penn.com > >> >>> > >> >>> > >> >>> > >> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > >> >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > >> >>> > > >> >>> > Stevie, can you actually read? > >> >>> > > >> >>> > The OP is asking about adding an extra restriction to the query > >> >>> > that > >> >>> > defines the report. There was no indication that there was anything > >> >>> > wrong > >> >>> > with the table. > >> >>> > > >> >>> > To the OP: You are able to select records based on month, so your > >> >>> > report > >> >>> > should be based on a query. Can you post the query so we can show > >> >>> > you > >> >>> > how > >> >>> > to modify it to include a restriction based on the check mark > >> >>> > field. > >> >>> > > >> >>> > John... Visio MVP > >> >>> > > >> >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> > >> >>> > wrote > >> >>> > in > >> >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > >> >>> >> Your table appears to not be correct! Please explain what you want > >> >>> >> your > >> >>> >> database to do to clarify before you continue and run into more > >> >>> >> problems. > >> >>> >> You might have to undo then revise previous thinds in the > >> >>> >> database. > >> >>> >> > >> >>> >> Steve > >> >>> >> san***@penn.com > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >> >>> >>> > >> >>> >>> I have a table that shows the company name, start date, id number > >> >>> >>> and a > >> >>> >>> check > >> >>> >>> box (yes/no) fields. My report currently allows me to select the > >> >>> >>> month > >> >>> >>> I > >> >>> >>> want to report on but I need for it to only select those records > >> >>> >>> in > >> >>> >>> that > >> >>> >>> month that have a check mark (yes) in the field. I hope you > >> >>> >>> understand > >> >>> >>> what > >> >>> >>> I am trying to say. Thanks in advance > >> >>> >> > >> >>> >> > >> >>> > > >> >>> > > >> >>> > >> >>> > >> >>> > >> > > >> > > >> > >> > >> > > > Sorry for the delay, things have been a bit busy.
Can you clarify something? If you create a query with the Owned field, it should be editable, but you will have to refresh the query to update the table. So, is the form you are talking about the one used to crate the report or the report itself? John... Visio MVP Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:38FCF2A6-B8F0-46B4-A1DB-F7369E857805@microsoft.com... > Unfortunately, I am getting the problem that happened when I first did the > same thing but I added Yes and not True which is that the check box on my > form grays out and does not allow me to edit although the report gives me > the > results that I am looking for. I added the field to my query and added > True > to the criteria and ran the query which ran fine and the report did what I > needed but I have to be able to have the checkbox on my form editable at > all > times thus to allowing the report to change if a company is removed or no > longer owned. Am I supposed to change something on my form with the > checkbox > as well? > > "John... Visio MVP" wrote: > >> Open the query QryCompanies in design view and add True to the Criteria >> row >> for the field [Owned] >> >> John... Visio MVP >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> news:9F0B32C1-2F32-46DB-9845-9CAAAF32A0A0@microsoft.com... >> >I agree Jeff and I would sooner have all the information to avoid >> >problems >> > later as these companies are constantly being updated and such. So >> > here >> > goes: >> > Report is based on qryCompanies which is based on Companies as my >> > table. >> > >> > Table = Field Names of CompanyID (Autonumber - Primary Key), >> > CompanyName >> > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use >> > letters >> > and >> > numbers as identifiers or file numbers), Owned (Yes/No). >> > >> > QryCompanies = Fields are Companies.* and CompanyName (descending) >> > using >> > the >> > Table Companies. >> > >> > On my form the label (Owned) has the Checkbox so this is the one that I >> > would like for the report to only show if it is checked as we are only >> > interested in those companies that are owned. >> > >> > I hope this will help clear things up and guide the correct answer. >> > >> > "Jeff Boyce" wrote: >> > >> >> Easier to just ask for clarification than presume you know... >> >> >> >> Regards >> >> >> >> Jeff Boyce >> >> Microsoft Office/Access MVP >> >> >> >> >> >> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote >> >> in >> >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... >> >> > Once again you got a response from the IGNORANT stalker! He flaunts >> >> > that >> >> > he is an MVP but notice it is not in Access. Look at your thread and >> >> > you >> >> > will see he provided no help in trying to solve your problem. Ignore >> >> > the >> >> > ignorant SOB. >> >> > >> >> > Many times in problems posted to the newsgroup, the underlying >> >> > problem >> >> > is >> >> > misdesign of tables. A poster will ask how to do something and most >> >> > ti,es >> >> > an answer can be found. However the misdesign of the tables still >> >> > persists >> >> > and sooner or later another problem will arise. At his point the >> >> > misdesign >> >> > of the tables becomes obvious and a redesign ensues. The redesign >> >> > then >> >> > makes a redo of the solution to the first question necessary. >> >> > >> >> > If you post your relevant tables in the form of: >> >> > TblCompany >> >> > CompanyID >> >> > CompanyName >> >> > >> >> > with a little explanation of your database, I will be glad to give >> >> > you >> >> > an >> >> > evaluation of the design of your tabls. >> >> > >> >> > Steve >> >> > sam***@penn.com >> >> > >> >> > >> >> > >> >> > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message >> >> > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... >> >> >> >> >> >> My report is based on a query and my table does have a CompanyName >> >> >> as >> >> >> well as >> >> >> CompanyID...I just didn't mention all the fields in my table as I >> >> >> figured >> >> >> it >> >> >> was not relevant to the question that I needed to be answered. I'm >> >> >> not >> >> >> sure >> >> >> if you still need me to post the query since I have the results >> >> >> that I >> >> >> need. >> >> >> Let me know. >> >> >> >> >> >> "Steve" wrote: >> >> >> >> >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the >> >> >>> newsgroup >> >> >>> but >> >> >>> only a harasser. He flaunts that he is an MVP but notice it is not >> >> >>> in >> >> >>> Access. >> >> >>> >> >> >>> You mention your table has a field for company name. Correct table >> >> >>> design >> >> >>> would have a company table with CompanyID and CompanyName. Your >> >> >>> table >> >> >>> then >> >> >>> would have CompanyID rather than company name. Your table would >> >> >>> still >> >> >>> appear >> >> >>> to be incorrect so as previously requested please explain what you >> >> >>> want >> >> >>> your >> >> >>> database to do to clarify so your table design can be further >> >> >>> analyzed. >> >> >>> >> >> >>> Steve >> >> >>> san***@penn.com >> >> >>> >> >> >>> >> >> >>> >> >> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message >> >> >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... >> >> >>> > >> >> >>> > Stevie, can you actually read? >> >> >>> > >> >> >>> > The OP is asking about adding an extra restriction to the query >> >> >>> > that >> >> >>> > defines the report. There was no indication that there was >> >> >>> > anything >> >> >>> > wrong >> >> >>> > with the table. >> >> >>> > >> >> >>> > To the OP: You are able to select records based on month, so >> >> >>> > your >> >> >>> > report >> >> >>> > should be based on a query. Can you post the query so we can >> >> >>> > show >> >> >>> > you >> >> >>> > how >> >> >>> > to modify it to include a restriction based on the check mark >> >> >>> > field. >> >> >>> > >> >> >>> > John... Visio MVP >> >> >>> > >> >> >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> >> >> >>> > wrote >> >> >>> > in >> >> >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... >> >> >>> >> Your table appears to not be correct! Please explain what you >> >> >>> >> want >> >> >>> >> your >> >> >>> >> database to do to clarify before you continue and run into more >> >> >>> >> problems. >> >> >>> >> You might have to undo then revise previous thinds in the >> >> >>> >> database. >> >> >>> >> >> >> >>> >> Steve >> >> >>> >> san***@penn.com >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in >> >> >>> >> message >> >> >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... >> >> >>> >>> >> >> >>> >>> I have a table that shows the company name, start date, id >> >> >>> >>> number >> >> >>> >>> and a >> >> >>> >>> check >> >> >>> >>> box (yes/no) fields. My report currently allows me to select >> >> >>> >>> the >> >> >>> >>> month >> >> >>> >>> I >> >> >>> >>> want to report on but I need for it to only select those >> >> >>> >>> records >> >> >>> >>> in >> >> >>> >>> that >> >> >>> >>> month that have a check mark (yes) in the field. I hope you >> >> >>> >>> understand >> >> >>> >>> what >> >> >>> >>> I am trying to say. Thanks in advance >> >> >>> >> >> >> >>> >> >> >> >>> > >> >> >>> > >> >> >>> >> >> >>> >> >> >>> >> >> > >> >> > >> >> >> >> >> >> >> >> >> Sorry, I didn't originally see your response and posted independently. When
I create the query and then refress it does update and I get the required results on my report but it is now the form that isn't behaving correctly when I change the query to include "Owned". The form has the checkbox on it and when I put the "Owned" field into the query and go back to the form the checkbox is grayed out. The report runs correctly and gives the correct results but the form doesn't. Show quoteHide quote "John... Visio MVP" wrote: > Sorry for the delay, things have been a bit busy. > Can you clarify something? > If you create a query with the Owned field, it should be editable, but you > will have to refresh the query to update the table. So, is the form you are > talking about the one used to crate the report or the report itself? > > John... Visio MVP > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:38FCF2A6-B8F0-46B4-A1DB-F7369E857805@microsoft.com... > > Unfortunately, I am getting the problem that happened when I first did the > > same thing but I added Yes and not True which is that the check box on my > > form grays out and does not allow me to edit although the report gives me > > the > > results that I am looking for. I added the field to my query and added > > True > > to the criteria and ran the query which ran fine and the report did what I > > needed but I have to be able to have the checkbox on my form editable at > > all > > times thus to allowing the report to change if a company is removed or no > > longer owned. Am I supposed to change something on my form with the > > checkbox > > as well? > > > > "John... Visio MVP" wrote: > > > >> Open the query QryCompanies in design view and add True to the Criteria > >> row > >> for the field [Owned] > >> > >> John... Visio MVP > >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> news:9F0B32C1-2F32-46DB-9845-9CAAAF32A0A0@microsoft.com... > >> >I agree Jeff and I would sooner have all the information to avoid > >> >problems > >> > later as these companies are constantly being updated and such. So > >> > here > >> > goes: > >> > Report is based on qryCompanies which is based on Companies as my > >> > table. > >> > > >> > Table = Field Names of CompanyID (Autonumber - Primary Key), > >> > CompanyName > >> > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use > >> > letters > >> > and > >> > numbers as identifiers or file numbers), Owned (Yes/No). > >> > > >> > QryCompanies = Fields are Companies.* and CompanyName (descending) > >> > using > >> > the > >> > Table Companies. > >> > > >> > On my form the label (Owned) has the Checkbox so this is the one that I > >> > would like for the report to only show if it is checked as we are only > >> > interested in those companies that are owned. > >> > > >> > I hope this will help clear things up and guide the correct answer. > >> > > >> > "Jeff Boyce" wrote: > >> > > >> >> Easier to just ask for clarification than presume you know... > >> >> > >> >> Regards > >> >> > >> >> Jeff Boyce > >> >> Microsoft Office/Access MVP > >> >> > >> >> > >> >> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote > >> >> in > >> >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > >> >> > Once again you got a response from the IGNORANT stalker! He flaunts > >> >> > that > >> >> > he is an MVP but notice it is not in Access. Look at your thread and > >> >> > you > >> >> > will see he provided no help in trying to solve your problem. Ignore > >> >> > the > >> >> > ignorant SOB. > >> >> > > >> >> > Many times in problems posted to the newsgroup, the underlying > >> >> > problem > >> >> > is > >> >> > misdesign of tables. A poster will ask how to do something and most > >> >> > ti,es > >> >> > an answer can be found. However the misdesign of the tables still > >> >> > persists > >> >> > and sooner or later another problem will arise. At his point the > >> >> > misdesign > >> >> > of the tables becomes obvious and a redesign ensues. The redesign > >> >> > then > >> >> > makes a redo of the solution to the first question necessary. > >> >> > > >> >> > If you post your relevant tables in the form of: > >> >> > TblCompany > >> >> > CompanyID > >> >> > CompanyName > >> >> > > >> >> > with a little explanation of your database, I will be glad to give > >> >> > you > >> >> > an > >> >> > evaluation of the design of your tabls. > >> >> > > >> >> > Steve > >> >> > sam***@penn.com > >> >> > > >> >> > > >> >> > > >> >> > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> >> > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > >> >> >> > >> >> >> My report is based on a query and my table does have a CompanyName > >> >> >> as > >> >> >> well as > >> >> >> CompanyID...I just didn't mention all the fields in my table as I > >> >> >> figured > >> >> >> it > >> >> >> was not relevant to the question that I needed to be answered. I'm > >> >> >> not > >> >> >> sure > >> >> >> if you still need me to post the query since I have the results > >> >> >> that I > >> >> >> need. > >> >> >> Let me know. > >> >> >> > >> >> >> "Steve" wrote: > >> >> >> > >> >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the > >> >> >>> newsgroup > >> >> >>> but > >> >> >>> only a harasser. He flaunts that he is an MVP but notice it is not > >> >> >>> in > >> >> >>> Access. > >> >> >>> > >> >> >>> You mention your table has a field for company name. Correct table > >> >> >>> design > >> >> >>> would have a company table with CompanyID and CompanyName. Your > >> >> >>> table > >> >> >>> then > >> >> >>> would have CompanyID rather than company name. Your table would > >> >> >>> still > >> >> >>> appear > >> >> >>> to be incorrect so as previously requested please explain what you > >> >> >>> want > >> >> >>> your > >> >> >>> database to do to clarify so your table design can be further > >> >> >>> analyzed. > >> >> >>> > >> >> >>> Steve > >> >> >>> san***@penn.com > >> >> >>> > >> >> >>> > >> >> >>> > >> >> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > >> >> >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > >> >> >>> > > >> >> >>> > Stevie, can you actually read? > >> >> >>> > > >> >> >>> > The OP is asking about adding an extra restriction to the query > >> >> >>> > that > >> >> >>> > defines the report. There was no indication that there was > >> >> >>> > anything > >> >> >>> > wrong > >> >> >>> > with the table. > >> >> >>> > > >> >> >>> > To the OP: You are able to select records based on month, so > >> >> >>> > your > >> >> >>> > report > >> >> >>> > should be based on a query. Can you post the query so we can > >> >> >>> > show > >> >> >>> > you > >> >> >>> > how > >> >> >>> > to modify it to include a restriction based on the check mark > >> >> >>> > field. > >> >> >>> > > >> >> >>> > John... Visio MVP > >> >> >>> > > >> >> >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> > >> >> >>> > wrote > >> >> >>> > in > >> >> >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > >> >> >>> >> Your table appears to not be correct! Please explain what you > >> >> >>> >> want > >> >> >>> >> your > >> >> >>> >> database to do to clarify before you continue and run into more > >> >> >>> >> problems. > >> >> >>> >> You might have to undo then revise previous thinds in the > >> >> >>> >> database. > >> >> >>> >> > >> >> >>> >> Steve > >> >> >>> >> san***@penn.com > >> >> >>> >> > >> >> >>> >> > >> >> >>> >> > >> >> >>> >> > >> >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in > >> >> >>> >> message > >> >> >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >> >> >>> >>> > >> >> >>> >>> I have a table that shows the company name, start date, id > >> >> >>> >>> number > >> >> >>> >>> and a > >> >> >>> >>> check > >> >> >>> >>> box (yes/no) fields. My report currently allows me to select > >> >> >>> >>> the > >> >> >>> >>> month > >> >> >>> >>> I > >> >> >>> >>> want to report on but I need for it to only select those > >> >> >>> >>> records > >> >> >>> >>> in > >> >> >>> >>> that > >> >> >>> >>> month that have a check mark (yes) in the field. I hope you > >> >> >>> >>> understand > >> >> >>> >>> what > >> >> >>> >>> I am trying to say. Thanks in advance > >> >> >>> >> > >> >> >>> >> > >> >> >>> > > >> >> >>> > > >> >> >>> > >> >> >>> > >> >> >>> > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > > Unfortunately, I am getting the problem that happened when I first did the
same thing but I added Yes and not True which is that the check box on my form grays out and does not allow me to edit although the report gives me the results that I am looking for. I added the field to my query and added True to the criteria and ran the query which ran fine and the report did what I needed but I have to be able to have the checkbox on my form editable at all times thus to allowing the report to change if a company is removed or no longer owned. Am I supposed to change something on my form with the checkbox as well? Show quoteHide quote "John... Visio MVP" wrote: > Open the query QryCompanies in design view and add True to the Criteria row > for the field [Owned] > > John... Visio MVP > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > news:9F0B32C1-2F32-46DB-9845-9CAAAF32A0A0@microsoft.com... > >I agree Jeff and I would sooner have all the information to avoid problems > > later as these companies are constantly being updated and such. So here > > goes: > > Report is based on qryCompanies which is based on Companies as my table. > > > > Table = Field Names of CompanyID (Autonumber - Primary Key), CompanyName > > (Text), BusinessDate (Date/Time), BusinessNumber (Text as we use letters > > and > > numbers as identifiers or file numbers), Owned (Yes/No). > > > > QryCompanies = Fields are Companies.* and CompanyName (descending) using > > the > > Table Companies. > > > > On my form the label (Owned) has the Checkbox so this is the one that I > > would like for the report to only show if it is checked as we are only > > interested in those companies that are owned. > > > > I hope this will help clear things up and guide the correct answer. > > > > "Jeff Boyce" wrote: > > > >> Easier to just ask for clarification than presume you know... > >> > >> Regards > >> > >> Jeff Boyce > >> Microsoft Office/Access MVP > >> > >> > >> "Steve" <help_available_at_very_reasonable_ra***@contactme.com> wrote in > >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > >> > Once again you got a response from the IGNORANT stalker! He flaunts > >> > that > >> > he is an MVP but notice it is not in Access. Look at your thread and > >> > you > >> > will see he provided no help in trying to solve your problem. Ignore > >> > the > >> > ignorant SOB. > >> > > >> > Many times in problems posted to the newsgroup, the underlying problem > >> > is > >> > misdesign of tables. A poster will ask how to do something and most > >> > ti,es > >> > an answer can be found. However the misdesign of the tables still > >> > persists > >> > and sooner or later another problem will arise. At his point the > >> > misdesign > >> > of the tables becomes obvious and a redesign ensues. The redesign then > >> > makes a redo of the solution to the first question necessary. > >> > > >> > If you post your relevant tables in the form of: > >> > TblCompany > >> > CompanyID > >> > CompanyName > >> > > >> > with a little explanation of your database, I will be glad to give you > >> > an > >> > evaluation of the design of your tabls. > >> > > >> > Steve > >> > sam***@penn.com > >> > > >> > > >> > > >> > "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> > news:4D8B2F24-ADF8-4DA9-8C7A-01A3554D5440@microsoft.com... > >> >> > >> >> My report is based on a query and my table does have a CompanyName as > >> >> well as > >> >> CompanyID...I just didn't mention all the fields in my table as I > >> >> figured > >> >> it > >> >> was not relevant to the question that I needed to be answered. I'm > >> >> not > >> >> sure > >> >> if you still need me to post the query since I have the results that I > >> >> need. > >> >> Let me know. > >> >> > >> >> "Steve" wrote: > >> >> > >> >>> Ignore this IGNORANT stalker! He is not a contribitor to the > >> >>> newsgroup > >> >>> but > >> >>> only a harasser. He flaunts that he is an MVP but notice it is not in > >> >>> Access. > >> >>> > >> >>> You mention your table has a field for company name. Correct table > >> >>> design > >> >>> would have a company table with CompanyID and CompanyName. Your table > >> >>> then > >> >>> would have CompanyID rather than company name. Your table would still > >> >>> appear > >> >>> to be incorrect so as previously requested please explain what you > >> >>> want > >> >>> your > >> >>> database to do to clarify so your table design can be further > >> >>> analyzed. > >> >>> > >> >>> Steve > >> >>> san***@penn.com > >> >>> > >> >>> > >> >>> > >> >>> "John... Visio MVP" <lancu***@stonehenge.ca> wrote in message > >> >>> news:OUkym52$JHA.4376@TK2MSFTNGP04.phx.gbl... > >> >>> > > >> >>> > Stevie, can you actually read? > >> >>> > > >> >>> > The OP is asking about adding an extra restriction to the query > >> >>> > that > >> >>> > defines the report. There was no indication that there was anything > >> >>> > wrong > >> >>> > with the table. > >> >>> > > >> >>> > To the OP: You are able to select records based on month, so your > >> >>> > report > >> >>> > should be based on a query. Can you post the query so we can show > >> >>> > you > >> >>> > how > >> >>> > to modify it to include a restriction based on the check mark > >> >>> > field. > >> >>> > > >> >>> > John... Visio MVP > >> >>> > > >> >>> > "Steve" <help_available_at_very_reasonable_ra***@contactme.com> > >> >>> > wrote > >> >>> > in > >> >>> > message news:E42dnSkpW4Ygcs7XnZ2dnUVZ_iydnZ2d@earthlink.com... > >> >>> >> Your table appears to not be correct! Please explain what you want > >> >>> >> your > >> >>> >> database to do to clarify before you continue and run into more > >> >>> >> problems. > >> >>> >> You might have to undo then revise previous thinds in the > >> >>> >> database. > >> >>> >> > >> >>> >> Steve > >> >>> >> san***@penn.com > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message > >> >>> >> news:D05684F7-C8F8-4D0A-8B45-27917A8AF3C0@microsoft.com... > >> >>> >>> > >> >>> >>> I have a table that shows the company name, start date, id number > >> >>> >>> and a > >> >>> >>> check > >> >>> >>> box (yes/no) fields. My report currently allows me to select the > >> >>> >>> month > >> >>> >>> I > >> >>> >>> want to report on but I need for it to only select those records > >> >>> >>> in > >> >>> >>> that > >> >>> >>> month that have a check mark (yes) in the field. I hope you > >> >>> >>> understand > >> >>> >>> what > >> >>> >>> I am trying to say. Thanks in advance > >> >>> >> > >> >>> >> > >> >>> > > >> >>> > > >> >>> > >> >>> > >> >>> > >> > > >> > > >> > >> > >> > > > "Steve" <moron_available_at_very_reasonable_ra***@contactme.com> wrote in Yes, and that stalker is YOU.message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > Once again you got a response from the IGNORANT stalker! Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report? Show quoteHide quote "Keith Wilby" wrote: > "Steve" <moron_available_at_very_reasonable_ra***@contactme.com> wrote in > message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > > Once again you got a response from the IGNORANT stalker! > > Yes, and that stalker is YOU. > > Did you add the checkbox to the form?
Is the checkbox bound to any field? It should not be bound to any field or to any calculation. Check that the control's Locked property is NO and Enabled property is Yes. What do you want to happen if the checkbox is not checked? Do you want all the records or just records where the the value of the field is false? If you have set the checkbox up to be a triple-state checkbox then it can be checked (true), unchecked (false), or grayed out (Null)? If you use a triple-state checkbox on your criteria form, the criteria in the query would be something like the following to show just the owned or just the not owned or ALL the records. Triple-State property is found on the Data tab. Field: Owned Criteria: Forms![frmReportDue]![NameofCheckboxControl] or Forms![frmReportDue]![NameofCheckboxControl] is null You might try opening a new thread with just the problem you are having. That, hopefully will get you away from all the extraneous comments that are attached to this thread. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Hedwig14 wrote: Show quoteHide quote > Can someone answer my question as to why the checkbox is not editable when I > add the Owned field into the query and report? > > "Keith Wilby" wrote: > >> "Steve" <moron_available_at_very_reasonable_ra***@contactme.com> wrote in >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... >>> Once again you got a response from the IGNORANT stalker! >> Yes, and that stalker is YOU. >> >> I didn't have the checkbox set to be triple-state...once I did that and
selected the proper control source on the form everything worked out nicely! I didn't want to start a new thread as this seems to have been the final answer. Thank you and to all that assisted and it sure is nice to see you pounce out those preditors that try to take advantage of others like me when we are vulnerable! Cheers Show quoteHide quote "John Spencer MVP" wrote: > Did you add the checkbox to the form? > Is the checkbox bound to any field? It should not be bound to any field or to > any calculation. > > Check that the control's Locked property is NO and Enabled property is Yes. > > What do you want to happen if the checkbox is not checked? Do you want all > the records or just records where the the value of the field is false? > > If you have set the checkbox up to be a triple-state checkbox then it can be > checked (true), unchecked (false), or grayed out (Null)? > > If you use a triple-state checkbox on your criteria form, the criteria in the > query would be something like the following to show just the owned or just the > not owned or ALL the records. Triple-State property is found on the Data tab. > > Field: Owned > Criteria: Forms![frmReportDue]![NameofCheckboxControl] or > Forms![frmReportDue]![NameofCheckboxControl] is null > > You might try opening a new thread with just the problem you are having. > That, hopefully will get you away from all the extraneous comments that are > attached to this thread. > > John Spencer > Access MVP 2002-2005, 2007-2009 > The Hilltop Institute > University of Maryland Baltimore County > > Hedwig14 wrote: > > Can someone answer my question as to why the checkbox is not editable when I > > add the Owned field into the query and report? > > > > "Keith Wilby" wrote: > > > >> "Steve" <moron_available_at_very_reasonable_ra***@contactme.com> wrote in > >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... > >>> Once again you got a response from the IGNORANT stalker! > >> Yes, and that stalker is YOU. > >> > >> > I'm glad you worked it out.
John.. Visio MVP Show quoteHide quote "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message news:20E05FAC-A7AF-4361-A115-ECA554731E00@microsoft.com... >I didn't have the checkbox set to be triple-state...once I did that and > selected the proper control source on the form everything worked out > nicely! > I didn't want to start a new thread as this seems to have been the final > answer. Thank you and to all that assisted and it sure is nice to see you > pounce out those preditors that try to take advantage of others like me > when > we are vulnerable! Cheers > > "John Spencer MVP" wrote: > >> Did you add the checkbox to the form? >> Is the checkbox bound to any field? It should not be bound to any field >> or to >> any calculation. >> >> Check that the control's Locked property is NO and Enabled property is >> Yes. >> >> What do you want to happen if the checkbox is not checked? Do you want >> all >> the records or just records where the the value of the field is false? >> >> If you have set the checkbox up to be a triple-state checkbox then it can >> be >> checked (true), unchecked (false), or grayed out (Null)? >> >> If you use a triple-state checkbox on your criteria form, the criteria in >> the >> query would be something like the following to show just the owned or >> just the >> not owned or ALL the records. Triple-State property is found on the >> Data tab. >> >> Field: Owned >> Criteria: Forms![frmReportDue]![NameofCheckboxControl] or >> Forms![frmReportDue]![NameofCheckboxControl] is null >> >> You might try opening a new thread with just the problem you are having. >> That, hopefully will get you away from all the extraneous comments that >> are >> attached to this thread. >> >> John Spencer >> Access MVP 2002-2005, 2007-2009 >> The Hilltop Institute >> University of Maryland Baltimore County >> >> Hedwig14 wrote: >> > Can someone answer my question as to why the checkbox is not editable >> > when I >> > add the Owned field into the query and report? >> > >> > "Keith Wilby" wrote: >> > >> >> "Steve" <moron_available_at_very_reasonable_ra***@contactme.com> wrote >> >> in >> >> message news:d-idnZpp2tv-M8nXnZ2dnUVZ_uOdnZ2d@earthlink.com... >> >>> Once again you got a response from the IGNORANT stalker! >> >> Yes, and that stalker is YOU. >> >> >> >> >> "Hedwig14" <Hedwi***@discussions.microsoft.com> wrote in message I hope the "noise" doesn't put you off posting again, there are some very news:20E05FAC-A7AF-4361-A115-ECA554731E00@microsoft.com... > > I didn't have the checkbox set to be triple-state...once I did that and > selected the proper control source on the form everything worked out > nicely! > I didn't want to start a new thread as this seems to have been the final > answer. Thank you and to all that assisted and it sure is nice to see you > pounce out those preditors that try to take advantage of others like me > when > we are vulnerable! Cheers > knowledgeable and helpful people here who won't ask you for money. Keith. On Thu, 9 Jul 2009 09:14:01 -0700, Hedwig14
<Hedwi***@discussions.microsoft.com> wrote: >Can someone answer my question as to why the checkbox is not editable when I Probably because there's a problem with the Query being used as a>add the Owned field into the query and report? recordsource. If the Owned field is from a different table than that used before you added it the Join in the query may not be set up correctly. Perhaps you could post the SQL view of the Recordsource query. My apologies for your running into the ongoing dispute about Steve's soliciting. It has nothing to do with you or your question of course. -- John W. Vinson [MVP] Take a look at all my responses. I was merely questiuoning the OP's table
design and offering to look at what he had and make suggestions if necessary. Are you going to start standing up for Visio John like some of your MVP good old boys? Steve Show quoteHide quote "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message news:vohc555d54b5k21531de80smi5itp1smo1@4ax.com... > On Thu, 9 Jul 2009 09:14:01 -0700, Hedwig14 > <Hedwi***@discussions.microsoft.com> wrote: > >>Can someone answer my question as to why the checkbox is not editable when >>I >>add the Owned field into the query and report? > > Probably because there's a problem with the Query being used as a > recordsource. If the Owned field is from a different table than that used > before you added it the Join in the query may not be set up correctly. > Perhaps > you could post the SQL view of the Recordsource query. > > My apologies for your running into the ongoing dispute about Steve's > soliciting. It has nothing to do with you or your question of course. > > -- > > John W. Vinson [MVP] On Thu, 9 Jul 2009 20:01:16 -0400, "Steve"
<help_available_at_very_reasonable_ra***@contactme.com> wrote: >Take a look at all my responses. I was merely questiuoning the OP's table Calm down, Steve. I'm not defending or attacking either you or John, I'm>design and offering to look at what he had and make suggestions if >necessary. Are you going to start standing up for Visio John like some of >your MVP good old boys? regretting that the OP's reasonable post got sucked into the ongoing dispute. -- John W. Vinson [MVP]  
Other interesting topics
Divide One Field into 3 parts
Linking form information to specific tables repeat information in report (Access 2007) Report - how to print each page to new document. Conditional formatting based on the Row Source in another control. Time Conversion relationships Auto populate month & year How do i dicount a field in access like cost? IIf Statement used for Counting |
|||||||||||||||||||||||
