By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Trapping Access Messages

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a

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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.