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
  #31  
Old August 1st, 2006, 10:14 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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







  #32  
Old August 2nd, 2006, 02:19 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

Is your code set to break on all errors or break on all un-handled errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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









  #33  
Old August 2nd, 2006, 03:38 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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








  #34  
Old August 2nd, 2006, 04:57 AM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

Set the code to break on all errors and find the line that causes the error.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled
errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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










  #35  
Old August 2nd, 2006, 07:22 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please



Hi here is the code and surrounding code

Case 8
' Commented out 7/10/2003 by Duane Hookom - Nestle US -
Nutrition Division
FixExtension
strFile = Me.txtFileName
Dim strNewFile As String
strNewFile = Left(strFile, InStr(strFile, ".") - 1) & ".DOC"
DoCmd.TransferText acExportDelim, , "myquery", strFile,
Me.chkIncludeHeadings


---- Kill strNewFile (problem line)


Name strFile As strNewFile
If Me.chkAutoStart Then
Dim oApp As Object 'New Word.Application
Dim oDoc As Object 'New Word.Document
Set oApp = CreateObject("Word.Application")
oApp.Visible = True


thanks again


Duane Hookom wrote:
Set the code to break on all errors and find the line that causes the error.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled
errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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









  #36  
Old August 2nd, 2006, 07:26 AM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please


sorry just a bit more info

the line Kill strNewFile has the value: c:\MyQBF.DOC

ta


Iona wrote:
Hi here is the code and surrounding code

Case 8
' Commented out 7/10/2003 by Duane Hookom - Nestle US -
Nutrition Division
FixExtension
strFile = Me.txtFileName
Dim strNewFile As String
strNewFile = Left(strFile, InStr(strFile, ".") - 1) & ".DOC"
DoCmd.TransferText acExportDelim, , "myquery", strFile,
Me.chkIncludeHeadings


---- Kill strNewFile (problem line)


Name strFile As strNewFile
If Me.chkAutoStart Then
Dim oApp As Object 'New Word.Application
Dim oDoc As Object 'New Word.Document
Set oApp = CreateObject("Word.Application")
oApp.Visible = True


thanks again


Duane Hookom wrote:
Set the code to break on all errors and find the line that causes the error.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled
errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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









  #37  
Old August 2nd, 2006, 12:53 PM posted to microsoft.public.access.queries
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Beginner query help please

You can try use:
If Len(Dir(strNewFile)) 0 Then
Kill strNewFile
End If


--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...


Hi here is the code and surrounding code

Case 8
' Commented out 7/10/2003 by Duane Hookom - Nestle US -
Nutrition Division
FixExtension
strFile = Me.txtFileName
Dim strNewFile As String
strNewFile = Left(strFile, InStr(strFile, ".") - 1) & ".DOC"
DoCmd.TransferText acExportDelim, , "myquery", strFile,
Me.chkIncludeHeadings


---- Kill strNewFile (problem line)


Name strFile As strNewFile
If Me.chkAutoStart Then
Dim oApp As Object 'New Word.Application
Dim oDoc As Object 'New Word.Document
Set oApp = CreateObject("Word.Application")
oApp.Visible = True


thanks again


Duane Hookom wrote:
Set the code to break on all errors and find the line that causes the
error.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled
errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click
on
send.
:-)


Iona wrote:
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











  #38  
Old August 2nd, 2006, 10:14 PM posted to microsoft.public.access.queries
Iona
external usenet poster
 
Posts: 24
Default Beginner query help please

thanks heaps! its works fine (not that I know about work merge fields
etc but its all there),
cheers again


Iona wrote:
sorry just a bit more info

the line Kill strNewFile has the value: c:\MyQBF.DOC

ta


Iona wrote:
Hi here is the code and surrounding code

Case 8
' Commented out 7/10/2003 by Duane Hookom - Nestle US -
Nutrition Division
FixExtension
strFile = Me.txtFileName
Dim strNewFile As String
strNewFile = Left(strFile, InStr(strFile, ".") - 1) & ".DOC"
DoCmd.TransferText acExportDelim, , "myquery", strFile,
Me.chkIncludeHeadings


---- Kill strNewFile (problem line)


Name strFile As strNewFile
If Me.chkAutoStart Then
Dim oApp As Object 'New Word.Application
Dim oDoc As Object 'New Word.Document
Set oApp = CreateObject("Word.Application")
oApp.Visible = True


thanks again


Duane Hookom wrote:
Set the code to break on all errors and find the line that causes the error.

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
ups.com...
un-handled errors..


Duane Hookom wrote:
Is your code set to break on all errors or break on all un-handled
errors?

--
Duane Hookom
MS Access MVP

"Iona" wrote in message
oups.com...
how about the word merge error? I'm still getting that when I click on
send.
:-)


Iona wrote:
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 09:11 AM.


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