Hi Lucao,
Did you fix the problem?
Did you understand my previous reply?
We need more information to be able to suggest a fix.
If you can upload a copy of your database to the
Group Files 2_AssistanceNeeded folder then we can
give you a better response to your problem.
(Nothing confidential and suitably compressed andzipped)
to save space.
Regards, Clive(Williams).
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> 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