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
|