Hi Lucao,
The correct way to handle this is to detect the
fact the the item is booked out before any
changes are made to the data, and issue a warning
message before any data is changed.
My question is, why are you using Find and Replace
when the item is still booked out?
When looking for available equipment, only the
available machines should be listed.
What is your criteria for an 'Available Machine'?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, lucao_o <no_reply@...> wrote:
>
> Hi guys,
>
> I know that this is going to be a pathetic question, but I do not usually handle anything to do with my works Access 2000 Database.
>
> My boss wants a new error reporting tool that pops up a message saying that a machine is already booked out when trying to book it out to a client. I have used a Macro to create the message, however, the way that the forms are designed makes the message pop up when we are trying to return the item using a Ctrl F - Find and Replace.
>
> The database consits of 1 window that allows us to book out and return in the same form/subform.
>
> Could someone help me with some code that would replace this Macro.
>
> The Macro I have is -
>
> ([Forms]![Equipment lending Query 2]![Equipment lending Query 2 subform].[Form]![Return Date]) Is Null MsgBox
>
> I know this is not much to go on, but if anyone can help, I am able to send screen shots etc. I havent touched access in about 12 years and it sounded so simple.... But being such a simple database, its now becoming too complicated for me.
>
> In the end, I just want a message box to appear once. Then when OK is clicked I dont want it popping back up when Ctrl F is used to return the item.
>
> Thanks in advance.
>
Tidak ada komentar:
Posting Komentar