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 6 1052
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
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
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
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
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 > >
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Pete |
last post by:
I'm trying to improve my code so that when I open a recordset object,
I can absolutely guarantee it is closed and is set = Nothing. I have
read some old threads and they all say to use the...
|
by: Paul |
last post by:
I have an Access 2000 database with a form that is giving me some
major headaches. When you open the form, it displays all records and
allows editing, but has AllowAdditions set to False so that...
|
by: Tony Williams |
last post by:
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...
|
by: Nathan Bloomfield |
last post by:
Hi there,
I am having difficulty with a piece of code which would work wonders
for my application if only the error trapping worked properly.
Basically, it works as follows:
- adds records...
|
by: Neil |
last post by:
Is there a way to trap an error generated in another app that is controlled
via automation? I have an Access 2000 app that opens Word 2000 and proceeds
to open a series of documents and, in each...
|
by: Thelma Lubkin |
last post by:
I use code extensively; I probably overuse it. But I've been using
error trapping very sparingly, and now I've been trapped by that.
A form that works for me on the system I'm using, apparently...
|
by: Joe Pacelli |
last post by:
Okay I'm trying to write an application to monitor a running process. Right
now I have a front end which allows the user to pick the programs they want
to monitor. The interval between how often I...
|
by: Captain Nemo |
last post by:
I'm still using Office 2000 myself, but some of my clients have Office 2003.
I've recently added a piece of code to create an instance of Word, open a
document, fill in the blanks and become...
|
by: smerf |
last post by:
Using javascript, is there a way to trap an external page inside a frame?
I've seen scripts to break out of frames, but nothing to keep a page trapped
in a frame.
|
by: franc sutherland |
last post by:
Hello,
I am using Access 2003. I am having trouble trapping the "can't
append all the records in the append query" error message when
appending data to a query from a table which is linked to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |