Hope it will help you
Add this in Your code
If Day(Me.DTPicker1.Value) >= Day(Now()) And Month(Me.DTPicker1.Value) >=
Month(Now()) And Year(Me.DTPicker1.Value) >= Year(Now()) Then
If Hour(Me.DTPicker2.Value) >= Hour(Now) &
Minute(Me.DTPicker2.Value) >= Minute(Now) Then
MsgBox "booking can not be Done", vbCritical
Exit Sub
End If
End If
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alisha malhotra
Sent: Thursday, August 04, 2011 9:59 PM
To: undisclosed-recipients:
Subject: $$Excel-Macros$$ Need help in Meeting room booking system
Hi,
I am just trying to make a training hall booking system.
If anyone try to book the training room or auditorium at the same date &
time or between that time then it should display the error message.
Second one thing is that if anyone try to delete or modify the entry then we
should get the alert/email with his information.
Please tell me how to do this?
Regards,
Alisha
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
