User Profile

Collapse

Profile Sidebar

Collapse
jahanara
jahanara
Last Activity: Mar 4 '10, 04:40 PM
Joined: Mar 3 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jahanara
    replied to prevent bookin while the car is on hire
    in Access
    hey thanks for the reply, i tried using the above but it still dont work.. is it possible i can do it as a query?
    See more | Go to post

      Leave a comment:

    • jahanara
      started a topic prevent bookin while the car is on hire
      in Access

      prevent bookin while the car is on hire

      hey,
      i am building a system for car hiring company. the tables are as follows

      tbl: client details
      tbl: Car Details
      tbl: Hire

      hire table contains the following fields
      Client ID
      Car ID
      Hire ID
      Start Date
      End Date

      i want to know when creating the form how do i build the beforeupdate expression so when i try booking a car that is ALREADY on hire for...
      See more | Go to post
      • jahanara
        started a topic using beforeupdate event to prevent booking betweet start date and end date
        in Visual Basic

        using beforeupdate event to prevent booking betweet start date and end date

        hey,
        i am building a system for car hiring company. the tables are as follows

        tbl: client details
        tbl: Car Details
        tbl: Hire

        hire table contains the following fields
        Client ID
        Car ID
        Hire ID
        Start Date
        End Date

        i want to know when creating the form how do i build the beforeupdate expression so when i try booking a car that is ALREADY on hire for...
        See more | Go to post
        No activity results to display
        Show More
        Working...