Cancel appointment

[ictcrystal]

Hi

I wanted to know how i could create a form that cancels an appointment i guess through a query..

can someone give me some advice please


Thank you




ps i have posted this on another forum but have no replies

[Ruegen]

Hi

I wanted to know how i could create a form that cancels an appointment i guess through a query..

can someone give me some advice please


Thank you


ps i have posted this on another forum but have no replies

When I do databases I want to know when something was cancelled and have a record of the booking but still have it cancelled.

I usually make a date field in the table and call it "Cancellation" (I attach the table name so the field will have "Booking_CancellationDate" because I have several different tables, it helps later in programming)

Then I put a button on the form that when pressed (and I put a yes/no pop up question for the user) it puts a date in the field using VBA. e.g. me.CancellationDate = date()

Then whenever I query I make sure that the cancellation field is "null" - because if it isn't null then it is cancelled and has a date in it

This helps out because I know when it was cancelled