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
|
|||
|
|||
Beginner query help please
I'm not sure why you are getting the error. I sometimes know some code will
produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#22
|
|||
|
|||
Beginner query help please
Hi, thanks I changed the options to break on unhandled errors, that
seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#23
|
|||
|
|||
Beginner query help please
I expect it will continue to work.
-- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#24
|
|||
|
|||
Beginner query help please
Hiiii,me again...
it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#25
|
|||
|
|||
Beginner query help please
Did you select a letter from the combo box?
-- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#26
|
|||
|
|||
Beginner query help please
no it is blank on both. Duane Hookom wrote: Did you select a letter from the combo box? -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#27
|
|||
|
|||
Beginner query help please
You must select a letter.
-- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... no it is blank on both. Duane Hookom wrote: Did you select a letter from the combo box? -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#28
|
|||
|
|||
Beginner query help please
But there are none in the combo box, as far as I can tell there should
be at least two, I made to new ones as well, however the box was still blank, In the related table there are 4. Duane Hookom wrote: You must select a letter. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... no it is blank on both. Duane Hookom wrote: Did you select a letter from the combo box? -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#29
|
|||
|
|||
Beginner query help please
Each letter record is associated with only one query. Look at your tables
and make sure that you have a record in zstblQBFLetters that is related to your current record in zstblQBFSource. If you don't have one then click the New Button to create a letter record that will be related to your query. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... But there are none in the combo box, as far as I can tell there should be at least two, I made to new ones as well, however the box was still blank, In the related table there are 4. Duane Hookom wrote: You must select a letter. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... no it is blank on both. Duane Hookom wrote: Did you select a letter from the combo box? -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |
#30
|
|||
|
|||
Beginner query help please
Ok, I feel like a right goose. apologies and many many thanks.
Iona Duane Hookom wrote: Each letter record is associated with only one query. Look at your tables and make sure that you have a record in zstblQBFLetters that is related to your current record in zstblQBFSource. If you don't have one then click the New Button to create a letter record that will be related to your query. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... But there are none in the combo box, as far as I can tell there should be at least two, I made to new ones as well, however the box was still blank, In the related table there are 4. Duane Hookom wrote: You must select a letter. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... no it is blank on both. Duane Hookom wrote: Did you select a letter from the combo box? -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hiiii,me again... it has continued to work fine, however I have two other small probs, they also occurr on the DH_QBF database as well as mine (sorry I do not understand enough to fix them myself ). 1. When I click on Send to Word Merge btn and then click send, I get error # 53, file not found, 2. When I click on Send to Merge Report, and then try to select(edit) a letter, I get Runtime error 3075, Syntax Error (missing operator) in query expression "ltrLTRID =" I'm very sorry to bother you with these, just that I do need them working, then I can also email you a copy with the outlook/email function. kind regards, Iona Duane Hookom wrote: I expect it will continue to work. -- Duane Hookom MS Access MVP "Iona" wrote in message oups.com... Hi, thanks I changed the options to break on unhandled errors, that seems to have done the trick.. I really don't understand... however will it keep on working like that? Duane Hookom wrote: I'm not sure why you are getting the error. I sometimes know some code will produce an error and use: On Error Resume Next This is only applied to a small section of code where I anticipate but want to ignore an error. I get unexpected error messages when I have my options set to break on all errors. -- Duane Hookom MS Access MVP "Iona" wrote in message ups.com... 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 |