If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Beginner query help please
Hi, thanks in advance, I am very new to access 2003. I have a very
simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#2
|
|||
|
|||
Beginner query help please
I expect your table might not be normalized. We don't really know much about
your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#3
|
|||
|
|||
Beginner query help please
Hi, thanks, methinks you may be right.. Its basically just a contact
table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#4
|
|||
|
|||
Beginner query help please
ahh would I be after Query by forms?
Iona wrote: Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#5
|
|||
|
|||
Beginner query help please
There is a query by form applet at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#6
|
|||
|
|||
Beginner query help please
Wow, thankyou Duane, you just made my day. Have you thought about putting an outlook connection on it. Its a really excellent solution. Thanks again for you patience. Duane Hookom wrote: There is a query by form applet at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#7
|
|||
|
|||
Beginner query help please
I hadn't really thought about output to Outlook or email. Can you describe
what functionality this might provide? I would be interested in adding something if I could keep it fairly generic. Different email clients might use different code. BTW: You shouldn't use your real email address in postings to public news groups. You might be inviting tons of junk emails. You might want to mudge your email as something like: hmcgregor AT internode DOT net. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... Wow, thankyou Duane, you just made my day. Have you thought about putting an outlook connection on it. Its a really excellent solution. Thanks again for you patience. Duane Hookom wrote: There is a query by form applet at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#8
|
|||
|
|||
Beginner query help please
God, i'm such a gumby somedays, ta.
As for Outlook, the database I am creating is specifically for mass mailouts (via word mailmerge), and mass emails, so they want to search their database for everyone who wants say a holiday rental at xmas and email them all their e-brochure. kind regards Iona Duane Hookom wrote: I hadn't really thought about output to Outlook or email. Can you describe what functionality this might provide? I would be interested in adding something if I could keep it fairly generic. Different email clients might use different code. BTW: You shouldn't use your real email address in postings to public news groups. You might be inviting tons of junk emails. You might want to mudge your email as something like: hmcgregor AT internode DOT net. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... Wow, thankyou Duane, you just made my day. Have you thought about putting an outlook connection on it. Its a really excellent solution. Thanks again for you patience. Duane Hookom wrote: There is a query by form applet at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#9
|
|||
|
|||
Beginner query help please
You can output the merge report to Word. Beyond that, I would take a while
to update the application. I would accept code from someone else (hint, hint). -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... God, i'm such a gumby somedays, ta. As for Outlook, the database I am creating is specifically for mass mailouts (via word mailmerge), and mass emails, so they want to search their database for everyone who wants say a holiday rental at xmas and email them all their e-brochure. kind regards Iona Duane Hookom wrote: I hadn't really thought about output to Outlook or email. Can you describe what functionality this might provide? I would be interested in adding something if I could keep it fairly generic. Different email clients might use different code. BTW: You shouldn't use your real email address in postings to public news groups. You might be inviting tons of junk emails. You might want to mudge your email as something like: hmcgregor AT internode DOT net. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... Wow, thankyou Duane, you just made my day. Have you thought about putting an outlook connection on it. Its a really excellent solution. Thanks again for you patience. Duane Hookom wrote: There is a query by form applet at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
#10
|
|||
|
|||
Beginner query help please
Hi Again Daune,
I've been poking around Outlook and your programmes query output, I've noticed that if you (eg) select all the query output (in this case the Email field), Outlook 2003 will accept a simple copy and paste into the "To." text box, where it will automatically delimit all the entries. hint hint... nudge, nudge, could be simpler than you thoughtttt........??? cheers Duane Hookom wrote: You can output the merge report to Word. Beyond that, I would take a while to update the application. I would accept code from someone else (hint, hint). -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... God, i'm such a gumby somedays, ta. As for Outlook, the database I am creating is specifically for mass mailouts (via word mailmerge), and mass emails, so they want to search their database for everyone who wants say a holiday rental at xmas and email them all their e-brochure. kind regards Iona Duane Hookom wrote: I hadn't really thought about output to Outlook or email. Can you describe what functionality this might provide? I would be interested in adding something if I could keep it fairly generic. Different email clients might use different code. BTW: You shouldn't use your real email address in postings to public news groups. You might be inviting tons of junk emails. You might want to mudge your email as something like: hmcgregor AT internode DOT net. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... Wow, thankyou Duane, you just made my day. Have you thought about putting an outlook connection on it. Its a really excellent solution. Thanks again for you patience. Duane Hookom wrote: There is a query by form applet at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane which allows users to select fields and criteria. Results are displayed in a datasheet subform. Controls in most query solutions would not be ignored. They would be Null. You can create a criteria in a form like: WHERE ([FieldA] = Forms!frmYourForm!chkA or Forms!frmYourForm!chkA Is Null) I still think your table is probably un-normalized and could better be queried and maintained if you normalized. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks, methinks you may be right.. Its basically just a contact table, but a long one. I tried putting things into different tables and came up with a heap of 1 to 1 relationships and my books said that if thats the case then it probably all belongs in one table. The query is a standard parameter query done by the book. The controls on the form are those that match the data type, checkbox for yes/no, text where appropriate etc. I suspect the prob may just be that there are so many fields. The run button I got of the windows.access tutorial site. Sorry I am very much in WSIWYG land and don't know much more. So what i'm trying to do is have a form where the user can just click or enter data in the fields (controls) that they want to search by without them having to go into access and try and conjure up queries. So I want to display all the possible fields, let them select what they want, which feeds into a query and they get their data. Is it possible to set up a query from a form? (sort of on the fly) Or does the query need to be constructed first? does this clarify what I'm raving on about? Does access ignore controls left blank when they are linked to a parameter query? again thanks for any help here. cheers Duane Hookom wrote: I expect your table might not be normalized. We don't really know much about your table, your query, your controls on your form, your "run button",... -- Duane Hookom MS Access MVP wrote in message oups.com... Hi, thanks in advance, I am very new to access 2003. I have a very simple table which is quite long, many of the fields are checkboxes. I have created a parameter query and a form to go with it, however I am getting a "query too complex" type of message when I hit the run button. What I intended to create is a form with all the table fields on it, so the user can just click/fill in what they want the search criteria to be and ignore the rest. Is this possible, does access just ignore what is left blank/unclicked on a form/parameter query. Or is the problem just that i have too many fields? I would appreciate any help here pls. Cheers |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |