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 |
#21
|
|||
|
|||
Need report to only select the "yes" based on month
"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ... Once again you got a response from the IGNORANT stalker! Yes, and that stalker is YOU. |
#22
|
|||
|
|||
Need report to only select the "yes" based on month
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_rates@contactm e.com wrote in message ... Once again you got a response from the IGNORANT stalker! Yes, and that stalker is YOU. |
#23
|
|||
|
|||
Need report to only select the "yes" based on month
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" wrote in message ... 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" wrote in message ... 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_rates@contactme .com wrote in message ... 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 "Hedwig14" wrote in message ... 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 "John... Visio MVP" wrote in message ... 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_rates@contactme .com wrote in message m... 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 "Hedwig14" wrote in message news 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 |
#24
|
|||
|
|||
Need report to only select the "yes" based on month
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. "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" wrote in message ... 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" wrote in message ... 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_rates@contactme .com wrote in message ... 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 "Hedwig14" wrote in message ... 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 "John... Visio MVP" wrote in message ... 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_rates@contactme .com wrote in message m... 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 "Hedwig14" wrote in message news 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 |
#25
|
|||
|
|||
Need report to only select the "yes" based on month
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_rates@contactm e.com wrote in message ... Once again you got a response from the IGNORANT stalker! Yes, and that stalker is YOU. |
#26
|
|||
|
|||
Need report to only select the "yes" based on month
On Thu, 9 Jul 2009 09:14:01 -0700, 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? 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] |
#27
|
|||
|
|||
Need report to only select the "yes" based on month
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_rates@contactm e.com wrote in message ... Once again you got a response from the IGNORANT stalker! Yes, and that stalker is YOU. |
#28
|
|||
|
|||
Need report to only select the "yes" based on month
I'm glad you worked it out.
John.. Visio MVP "Hedwig14" wrote in message ... 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_rates@contactm e.com wrote in message ... Once again you got a response from the IGNORANT stalker! Yes, and that stalker is YOU. |
#29
|
|||
|
|||
Need report to only select the "yes" based on month
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 "John W. Vinson" wrote in message ... On Thu, 9 Jul 2009 09:14:01 -0700, 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? 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] |
#30
|
|||
|
|||
Need report to only select the "yes" based on month
On Thu, 9 Jul 2009 20:01:16 -0400, "Steve"
help_available_at_very_reasonable_rates@contactme .com wrote: 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? Calm down, Steve. I'm not defending or attacking either you or John, I'm regretting that the OP's reasonable post got sucked into the ongoing dispute. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|