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 |
#11
|
|||
|
|||
Beginner query help please
I was think more along the lines of using "automation" to open an Outlook
email for each record in the result and inserting values into the Subject and Body. I'll let you do the copy and paste ;-) -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... 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 |
#12
|
|||
|
|||
Beginner query help please
Duane! All right, All right.... stop nagging me! I've done it, just one
tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = ..Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#13
|
|||
|
|||
Beginner query help please
actually, you know what else might be nice, would be a little drop down
combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs etc etc (for attachments and for files to insert), is this a nice little prefab windows job? Or does it all need to be programmed in the exhausting way (sorry could probably figure it out myself, but btwn work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired. :-) hmm... just remembered that this would be a open file dialog box, is this easy to pop into an access form? cheers Iona wrote: Duane! All right, All right.... stop nagging me! I've done it, just one tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = .Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#14
|
|||
|
|||
Beginner query help please
There are some nice functions at http://www.mvps.org/access/api/index.html
for browsing for a file or folder and retrieving the network ID. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... actually, you know what else might be nice, would be a little drop down combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs etc etc (for attachments and for files to insert), is this a nice little prefab windows job? Or does it all need to be programmed in the exhausting way (sorry could probably figure it out myself, but btwn work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired. :-) hmm... just remembered that this would be a open file dialog box, is this easy to pop into an access form? cheers Iona wrote: Duane! All right, All right.... stop nagging me! I've done it, just one tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = .Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#15
|
|||
|
|||
Beginner query help please
thanks Duane, have a look there, just very unsure as how to actually
contact said form to api. aside from that do you have any idea regarding the insert as text (into body of email) command? (as in post 12).. the email feature is actually working really well!, i just want to refine it a little and it'll be hunkydory! cheers iona Duane Hookom wrote: There are some nice functions at http://www.mvps.org/access/api/index.html for browsing for a file or folder and retrieving the network ID. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... actually, you know what else might be nice, would be a little drop down combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs etc etc (for attachments and for files to insert), is this a nice little prefab windows job? Or does it all need to be programmed in the exhausting way (sorry could probably figure it out myself, but btwn work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired. :-) hmm... just remembered that this would be a open file dialog box, is this easy to pop into an access form? cheers Iona wrote: Duane! All right, All right.... stop nagging me! I've done it, just one tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = .Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#16
|
|||
|
|||
Beginner query help please
I haven't used the insert as text command. You might want to start a new
thread since you seem to have gone beyond my experience with this and I don't have much time to "play" with it. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... thanks Duane, have a look there, just very unsure as how to actually contact said form to api. aside from that do you have any idea regarding the insert as text (into body of email) command? (as in post 12).. the email feature is actually working really well!, i just want to refine it a little and it'll be hunkydory! cheers iona Duane Hookom wrote: There are some nice functions at http://www.mvps.org/access/api/index.html for browsing for a file or folder and retrieving the network ID. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... actually, you know what else might be nice, would be a little drop down combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs etc etc (for attachments and for files to insert), is this a nice little prefab windows job? Or does it all need to be programmed in the exhausting way (sorry could probably figure it out myself, but btwn work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired. :-) hmm... just remembered that this would be a open file dialog box, is this easy to pop into an access form? cheers Iona wrote: Duane! All right, All right.... stop nagging me! I've done it, just one tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = .Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#17
|
|||
|
|||
Beginner query help please
Ok, thanks for all your help Duane, have just done this in .Outlook
forum. I'll keep you posted. cheers honor Duane Hookom wrote: I haven't used the insert as text command. You might want to start a new thread since you seem to have gone beyond my experience with this and I don't have much time to "play" with it. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... thanks Duane, have a look there, just very unsure as how to actually contact said form to api. aside from that do you have any idea regarding the insert as text (into body of email) command? (as in post 12).. the email feature is actually working really well!, i just want to refine it a little and it'll be hunkydory! cheers iona Duane Hookom wrote: There are some nice functions at http://www.mvps.org/access/api/index.html for browsing for a file or folder and retrieving the network ID. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... actually, you know what else might be nice, would be a little drop down combo box thingy, that gave you common paths eg; C:\, Desktop, My Docs etc etc (for attachments and for files to insert), is this a nice little prefab windows job? Or does it all need to be programmed in the exhausting way (sorry could probably figure it out myself, but btwn work/kids/work/cleaning/etc etc etc ad nauseum I'm a bit to tired. :-) hmm... just remembered that this would be a open file dialog box, is this easy to pop into an access form? cheers Iona wrote: Duane! All right, All right.... stop nagging me! I've done it, just one tiny snag.. I would like to utelise outlook 2003's insert as text facility, primarily to be able to insert an html file into the email body, however an stuck on actual code syntax.. I imagine it would be vaguely similar to this: If (IsNull(Forms!frmMail!AttachmentPath)) Then Else Set objOutlookAttach = .Attachments.Add((Forms!frmMail!AttachmentPath), olByValue, 1) End If but with a .insertastext(Forms!blahblahblah) kinda command. Anyhelp with syntax here would be very much appreciated. kind regards Iona wrote: 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 |
#18
|
|||
|
|||
Beginner query help please
Hi Duane, OMG, i've actually done it, so with it you can use the query
output to send mass email, and you can select an attachment or a file to insert into the body of an email. Sounds so simple, but argh, anyway it works, would you like a copy of the code/etc, you can probably polish it somewhat i'm sure. kind regards iona |
#19
|
|||
|
|||
Beginner query help please
Congrats! I would love to get a copy of the file. You can compact then zip
it and send to duane AT hookom DOT net -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi Duane, OMG, i've actually done it, so with it you can use the query output to send mass email, and you can select an attachment or a file to insert into the body of an email. Sounds so simple, but argh, anyway it works, would you like a copy of the code/etc, you can probably polish it somewhat i'm sure. kind regards iona |
#20
|
|||
|
|||
Beginner query help please
Hi Duane, before I send it to you I am encountering an error message
when I run a search.... 'run time error: 3014 Object MyQuery already exists. so the from MyQuery appears to be either not overwriting or deleting on close.... any pointers? ps do i send you the whole db or just the relevant forms/tables? God sorry I am still so new to this. chers Iona Duane Hookom wrote: Congrats! I would love to get a copy of the file. You can compact then zip it and send to duane AT hookom DOT net -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi Duane, OMG, i've actually done it, so with it you can use the query output to send mass email, and you can select an attachment or a file to insert into the body of an email. Sounds so simple, but argh, anyway it works, would you like a copy of the code/etc, you can probably polish it somewhat i'm sure. kind regards iona |
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 |