A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Beginner query help please



 
 
Thread Tools Display Modes
  #21  
Old July 28th, 2006, 03:30 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old July 30th, 2006, 09:36 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default 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  
Old July 31st, 2006, 05:26 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old August 1st, 2006, 12:56 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default 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  
Old August 1st, 2006, 04:02 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old August 1st, 2006, 09:25 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default 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  
Old August 1st, 2006, 09:47 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old August 1st, 2006, 09:53 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default 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  
Old August 1st, 2006, 10:01 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default 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  
Old August 1st, 2006, 10:10 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01: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


All times are GMT +1. The time now is 05:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.