Repost - forgot the "New Question" thing...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,
I've poured over the ng again and was not able to find the answer to this. It seems that my changing some settings in this area doesn't do my users any good. I run action queries and record changes in my users' front end application. However, I don't want them to see that they are appending rows to my table - I understand that the confirmation email that I get when they enter a request is still going to request an Exchange profile and tell them they are sending me an email.

Is there any way to programatticaly set these options? I want to turn off all confirmations on this dialogue box.

Thank you very much in advance!
Derek Wittman
 
Derek Wittman said:
Good afternoon,
I've poured over the ng again and was not able to find the answer to this.
Click to expand...
It seems that my changing some settings in this area doesn't do my users any
good. I run action queries and record changes in my users' front end
application. However, I don't want them to see that they are appending rows
to my table

Up to the above point, your post makes sense.

Then:
- I understand that the confirmation email that I get when they enter a
Click to expand...
request is still going to request an Exchange profile

Huh? complete comparison break down here. Complete and bizarre statement?
How can you jump from a statement about a update query right into a exchange
profile and a email?

Hum, I need a glass of water...opps..lets talk about nuclear reactors? Are
these two related?

I guess you never grew up watching Sesame street. They use to have a great
song about:

.....one of these things is not like the other.....

Apparently you missed that part in your youth?

I can see a question about some update query..but then all of a sudden how
the heck did we get to Exchange profiles..and emails?

(and, you are wondering why no one is able to answer you question??). Fact
is, we are not mind readers.

Lets try and draw some connecting dots here!

If you don't want update queries to give confirmation dialogs, you can have
several choices.

You can turn off the confirmation dialogs for update queries like:

docmd.SetWarnings false
docmd.RunSQL "update tblCustomers set EmailSent = true"
docmd.setwarnings true

You can also in place of the above, use the current database, and just run
the sql as :

currentdb.Execute "your sql goes here"

or, you can use

currentdb.Execute "yourQueryNameGoesHere"

So, either of the above will turn off confirmation dialog boxes.

As for the email...and exchange profile....hum...I have no idea as to their
relation to the above issues.

In fact, I not sure what a query has to do with emails? How are they related
to each other?

Are you using outlook, or outlook express? (you are going to have to give
us dogs a few bones here to work on..as we can't guess the rest of your
setup..and how it relates to your question).
 
Perhaps you are looking for

DoCmd.SetWarnings False

'Execute your update query
DoCmd.SetWarnings True

But, that depends on how you are running your update queries - via a macro, via
vba code, manually?
 
Sorry... I'm really having a tough time with the new MS NG format - and it's affecting my continuity of thought - I struggle with this to begin with.

The change from the actions to the confirmation email... explanation: We're in Outlook 2000. My users (I don't know if it's from McAfee AV or Outlook) get a popup that tells them they will be sending an email. This does not seem to be something that can be turned off by docmd.setwarnings false.

Further...

Albert D. Kallal said:
It seems that my changing some settings in this area doesn't do my users any
good. I run action queries and record changes in my users' front end
application. However, I don't want them to see that they are appending rows
to my table

Up to the above point, your post makes sense.

Then:

request is still going to request an Exchange profile

Huh? complete comparison break down here. Complete and bizarre statement?
How can you jump from a statement about a update query right into a exchange
profile and a email?

Hum, I need a glass of water...opps..lets talk about nuclear reactors? Are
these two related?

I guess you never grew up watching Sesame street. They use to have a great
song about:

.....one of these things is not like the other.....

Apparently you missed that part in your youth?
Click to expand...

DW: I'm forever incomplete, Albert. How did I ever see past the age of 7?
I can see a question about some update query..but then all of a sudden how
the heck did we get to Exchange profiles..and emails?

(and, you are wondering why no one is able to answer you question??). Fact
is, we are not mind readers.

Lets try and draw some connecting dots here!

If you don't want update queries to give confirmation dialogs, you can have
several choices.

You can turn off the confirmation dialogs for update queries like:

docmd.SetWarnings false
docmd.RunSQL "update tblCustomers set EmailSent = true"
docmd.setwarnings true

You can also in place of the above, use the current database, and just run
the sql as :

currentdb.Execute "your sql goes here"

or, you can use

currentdb.Execute "yourQueryNameGoesHere"

So, either of the above will turn off confirmation dialog boxes.

As for the email...and exchange profile....hum...I have no idea as to their
relation to the above issues.

In fact, I not sure what a query has to do with emails? How are they related
to each other?

Are you using outlook, or outlook express? (you are going to have to give
us dogs a few bones here to work on..as we can't guess the rest of your
setup..and how it relates to your question).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn
Click to expand...
DW: I'm guessing I can docmd.setwarnings false OnOpen of my startup form as well?

Thank you for the help. I think that this clears up my question.

Derek Wittman
 
(e-mail address removed)...
Sorry... I'm really having a tough time with the new MS NG format - and
Click to expand...
it's affecting my continuity of thought - I struggle with this to begin
with.

That is not a problem (I was being a little sarcastic..and I apologize).
DW: I'm guessing I can docmd.setwarnings false OnOpen of my startup form
Click to expand...
as well?

That is actually a good idea...and you can / should turn them on in the
forms close event.

Also, your question about the Outlook...hum, if you are taking about the
"prompt" you get..then perhaps you can "set as default" profile in out look.
If you eliminate the startup prompt when outlook runs..then if you launch
the email system..you should be ok. However, with the new security
stuff..you can't get rid of that "another program is trying to use
outlook..do you want to allow...".

Good luck..and please do feel free to expand on your question!
 
Albert,
No worries on the sarcasm. I guess with the long list of sarcasms I've pulled in my life, someone was going to get a laugh out of me at my own expense. Might as well be someone trying to help me, right?

I never thought of setwarnings true at the close of the application. Of course, when I close the application, it's on a docmd.quit.

My email question pertained to the new security stuff. I guess there's nothing I can do about that.

Albert, that covers it. (BTW, if I was offended by sarcasm, you wouldn't have gotten a sarcastic retaliation back.)
 
Back
Top