I need someone to create triggers in Access 2010 that will limit what the data can enter. For instance, there will be two rooms. The price of room 2 must be higher than the price of any room 1 (not the total, but the highest price of any room 1). Also, I need a trigger that gives an error when the user attempts to book a room from the same hotel within the conflicting dates with an existing room. The guest cannot make 2 bookings with overlapping dates. You can use VBA. I will pay you $15. Thank you.
Hello
I'm a software engineer with good knowledge in access database design.
I can do this with some methods.
please contact me to discuss about the solutions.
best regards
hossein
Your work could be done via Access VBA. I have lot experience in this due to my previous completed project of purchase orders management of my own store. I think I can help you get this project done quickly as your expectation.
I look forward to hearing from you.
Kind regards,
Khanh Tran.