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
|
|||
|
|||
Sorry I missed this repsonse !!
strSql = CurrentDb.QueryDefs("ITAMembershipsDue") The above needs to be : strSql = CurrentDb.QueryDefs("ITAMembershipsDue").sql -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#12
|
|||
|
|||
Thanks! It's getting better! I can run my query which calls
Forms!DateToWordParam!FindDate. When I use the DateToWordParam form and enter the date and then click the merge button, I receive an error: No data was created for this merge, make sure the sql is correct (which it is, since it works from the query). Any idea why the merge code isn't liking the sql? Perhaps the code doesn't know what the date is yet when it runs the query, since it all is happening at once?... Thanks, Stephanie "Albert D.Kallal" wrote: Sorry I missed this repsonse !! strSql = CurrentDb.QueryDefs("ITAMembershipsDue") The above needs to be : strSql = CurrentDb.QueryDefs("ITAMembershipsDue").sql -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Albert Kallal | Chris | General Discussion | 4 | September 2nd, 2005 08:39 AM |
Albert Kallal Mail Merge Code | hughess7 | General Discussion | 6 | June 17th, 2005 04:35 PM |
Bring back "The Genius" Office Assistant (ie. Albert Einstein)!!! | Jeani | General Discussions | 1 | May 3rd, 2005 12:33 AM |
Msg to Albert D. Kallal - Help | Byron | General Discussion | 8 | September 27th, 2004 12:26 AM |
To Albert D. Kallal | John Michael | General Discussion | 9 | September 24th, 2004 05:38 AM |