I
IntermediateLearner
Hi All
I am wondering if there is a way to disable Warning Messages on data access
pages (similar to how it can be done in macros)?
I have a small database that I have created that will primarily be accessed
by 1 or 2 users using DAP pages (as they don't and won't get Access proper).
It is a very simple book loan register with a table for the books, a table
for the source of the books (they are donated to our organisation) and a
table to record the in and outs when the books are borrowed.
Using the DAP's the users can enter a new book and enter who donated it.
They can then record when it was borrowed and when it was returned. and it
is here that my question relates to.
I started with a simple query that I wanted to use to show all the books on
loan (ie [Date Returned] is null) then created a DAP page that ran from this
query - which worked fine. but when I went to change the [Date Returned]
value in one of the records (ie to record that the book was returned) I got
an error msg to say that the new value no longer fits the criteria (which I
know it doesn't cause i just changed it.) The page then refreshes and does
not show the changed record(which is also right because the [date returned]
value is no longer NULL). - and after checking the tables I can confirm that
it does accept the change.
As I have some very novice users I would prefer not to confuse them with
this error message.
So - long story short ( I know too late) is there a way that I can disable
the error msg on the DAP and just have the new results displayed.
Thanks in advance for any help
I am wondering if there is a way to disable Warning Messages on data access
pages (similar to how it can be done in macros)?
I have a small database that I have created that will primarily be accessed
by 1 or 2 users using DAP pages (as they don't and won't get Access proper).
It is a very simple book loan register with a table for the books, a table
for the source of the books (they are donated to our organisation) and a
table to record the in and outs when the books are borrowed.
Using the DAP's the users can enter a new book and enter who donated it.
They can then record when it was borrowed and when it was returned. and it
is here that my question relates to.
I started with a simple query that I wanted to use to show all the books on
loan (ie [Date Returned] is null) then created a DAP page that ran from this
query - which worked fine. but when I went to change the [Date Returned]
value in one of the records (ie to record that the book was returned) I got
an error msg to say that the new value no longer fits the criteria (which I
know it doesn't cause i just changed it.) The page then refreshes and does
not show the changed record(which is also right because the [date returned]
value is no longer NULL). - and after checking the tables I can confirm that
it does accept the change.
As I have some very novice users I would prefer not to confuse them with
this error message.
So - long story short ( I know too late) is there a way that I can disable
the error msg on the DAP and just have the new results displayed.
Thanks in advance for any help