Access Triggers/Named Macro for Database -- 3

Closed Posted May 8, 2014 Paid on delivery
Closed

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.

Database Administration Database Programming Microsoft Access MySQL SQL

Project ID: #5915530

About the project

5 proposals Remote project Active Jun 14, 2014

5 freelancers are bidding on average $17/hour for this job

customizedata

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

$16 USD / hour
(108 Reviews)
5.9
khanhtd

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 exp More

$15 USD / hour
(1 Review)
0.8
sagram000

Expert in Microsoft Access and Visual Basic and PDA programming Exeperience of 10 years. before any bid please provide some info

$16 USD / hour
(0 Reviews)
0.0
officedesk

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.

$16 USD / hour
(0 Reviews)
0.0
kesavannil

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.

$22 USD / hour
(0 Reviews)
0.0