Access Triggers/Named Macro for Database -- 3
$15-25 USD / hour
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.
Project ID: #5915530
About the project
5 freelancers are bidding on average $17/hour for this job
I think triggers are not for this type of work. Also, MS access does not provide any triggers, data macro is there to replicate trigger of MSQL server/Oracle etc. we can just write the code behind the button click e.g More
Expert in Microsoft Access and Visual Basic and PDA programming Exeperience of 10 years. before any bid please provide some info
Hi I can do this, it's very simple. I am proficient in MS access and your task is well understood and it would be done perfectly as per your requirement.
Hi, I have great experience in working with SQL. If project provided will be able to deliver on time with good code quality. Please feel free to mail me.