469,903 Members | 1,698 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Trapping Access Messages

When a user deletes a record from a table which has a link to another table
two messages appear.One that asks the user to confirm they want to delete
the record and another that involves the deleting of records in the linked
tables. is there any way to trap these messages to stop them appearing and
replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams
Nov 12 '05 #1
6 995

got to tools, options, edit find

there are three confirm boxes, untick them

"Tony Williams" <tw@tcp.invalid> wrote in message
news:c4**********@titan.btinternet.com...
When a user deletes a record from a table which has a link to another table two messages appear.One that asks the user to confirm they want to delete
the record and another that involves the deleting of records in the linked
tables. is there any way to trap these messages to stop them appearing and
replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams

Nov 12 '05 #2
Thanks Dave worked fine
Tony
"Dave" <e@mail.co.uk> wrote in message
news:c4**********@hercules.btinternet.com...

got to tools, options, edit find

there are three confirm boxes, untick them

"Tony Williams" <tw@tcp.invalid> wrote in message
news:c4**********@titan.btinternet.com...
When a user deletes a record from a table which has a link to another

table
two messages appear.One that asks the user to confirm they want to delete the record and another that involves the deleting of records in the linked tables. is there any way to trap these messages to stop them appearing and replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams


Nov 12 '05 #3
In article <c4**********@hercules.btinternet.com>, tw@tcp.invalid
says...
Thanks Dave worked fine
Tony
"Dave" <e@mail.co.uk> wrote in message
news:c4**********@hercules.btinternet.com...

got to tools, options, edit find

there are three confirm boxes, untick them

"Tony Williams" <tw@tcp.invalid> wrote in message
news:c4**********@titan.btinternet.com...
When a user deletes a record from a table which has a link to another

table
two messages appear.One that asks the user to confirm they want to delete the record and another that involves the deleting of records in the linked tables. is there any way to trap these messages to stop them appearing and replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams



Nov 12 '05 #4
I hate setting things globally like that. One thing is that you now
ASS-U-ME that this is the way you want things set up all the time for
all apps. Also you cannot contorl how other have any given option set.
use the DoCmd.SetWarnings command to disable and reenable the warnings.

In article <c4**********@hercules.btinternet.com>, tw@tcp.invalid
says...
Thanks Dave worked fine
Tony
"Dave" <e@mail.co.uk> wrote in message
news:c4**********@hercules.btinternet.com...

got to tools, options, edit find

there are three confirm boxes, untick them

"Tony Williams" <tw@tcp.invalid> wrote in message
news:c4**********@titan.btinternet.com...
When a user deletes a record from a table which has a link to another

table
two messages appear.One that asks the user to confirm they want to delete the record and another that involves the deleting of records in the linked tables. is there any way to trap these messages to stop them appearing and replace them with my own because the wording of the second message isn't
user friendly?
TIA
Tony Williams



Nov 12 '05 #5
Thanks Ima could you give me an example of the code for Doccmd.Setrwarnings
for my example. I agree it would be better to code just for this app.
Tony
"Ima Lostsoul" <me@myprovider.com> wrote in message
news:MP************************@netnews.comcast.ne t...
I hate setting things globally like that. One thing is that you now
ASS-U-ME that this is the way you want things set up all the time for
all apps. Also you cannot contorl how other have any given option set.
use the DoCmd.SetWarnings command to disable and reenable the warnings.

In article <c4**********@hercules.btinternet.com>, tw@tcp.invalid
says...
Thanks Dave worked fine
Tony
"Dave" <e@mail.co.uk> wrote in message
news:c4**********@hercules.btinternet.com...

got to tools, options, edit find

there are three confirm boxes, untick them

"Tony Williams" <tw@tcp.invalid> wrote in message
news:c4**********@titan.btinternet.com...
> When a user deletes a record from a table which has a link to another table
> two messages appear.One that asks the user to confirm they want to

delete
> the record and another that involves the deleting of records in the

linked
> tables. is there any way to trap these messages to stop them appearing
and
> replace them with my own because the wording of the second message

isn't > user friendly?
> TIA
> Tony Williams
>
>


Nov 12 '05 #6
In article <c4**********@titan.btinternet.com>, tw@tcp.invalid says...
Thanks Ima could you give me an example of the code for Doccmd.Setrwarnings
for my example. I agree it would be better to code just for this app.
Tony
"Ima Lostsoul" <me@myprovider.com> wrote in message
news:MP************************@netnews.comcast.ne t...
I hate setting things globally like that. One thing is that you now
ASS-U-ME that this is the way you want things set up all the time for
all apps. Also you cannot contorl how other have any given option set.
use the DoCmd.SetWarnings command to disable and reenable the warnings.

In article <c4**********@hercules.btinternet.com>, tw@tcp.invalid
says...
Thanks Dave worked fine
Tony
"Dave" <e@mail.co.uk> wrote in message
news:c4**********@hercules.btinternet.com...
>
> got to tools, options, edit find
>
> there are three confirm boxes, untick them
>
>
>
> "Tony Williams" <tw@tcp.invalid> wrote in message
> news:c4**********@titan.btinternet.com...
> > When a user deletes a record from a table which has a link to another > table
> > two messages appear.One that asks the user to confirm they want to
delete
> > the record and another that involves the deleting of records in the
linked
> > tables. is there any way to trap these messages to stop them appearing and
> > replace them with my own because the wording of the second message isn't > > user friendly?
> > TIA
> > Tony Williams
> >
> >
>
>


Private Sub bUpdateNewEmployees_Click()
On Error GoTo Err_bUpdateNewEmployees_Click

DoCmd.SetWarnings False

'Put code to run when user clicks the UpdateNewEmployee button here.

Exit_bUpdateNewEmployees_Click:
DoCmd.SetWarnings True
Exit Sub

Err_bUpdateNewEmployees_Click:
'put error routine here
Resume Exit_bUpdateNewEmployees_Click

End Sub
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Pete | last post: by
6 posts views Thread by Tony Williams | last post: by
13 posts views Thread by Thelma Lubkin | last post: by
2 posts views Thread by Captain Nemo | last post: by
42 posts views Thread by smerf | last post: by
4 posts views Thread by franc sutherland | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.