Access Triggers/Named Macro for Database -- 3

$15-25 USD / hour

Closed

Posted

almost 10 years ago

$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.

Database Administration

Project ID: 5915530

About the project

5 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

5 freelancers are bidding on average $17 USD/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 booking that will check whether conflicting dates with an existing room or not

$16 USD in 1 day

4.7

(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 expectation. I look forward to hearing from you. Kind regards, Khanh Tran.

$15 USD in 5 days

5.0

(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 in 3 days

0.0

(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 in 3 days

0.0

(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 in 3 days