Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I still think this is the wrong approach from a user friendly aspect because the OP suggests this scenario is likely:


    It seems that the dates are to be entered first, then choose the equipment, so I enter the 2 dates for which I need some particular equipment.
    Drop down the combo, my equipment isn't listed. OK, it's booked out? Or do I have absolute confidence that there's nothing wrong with the combo query?
    Now I move the dates forward 3 days. No luck.
    Move the dates forward 4 more days. No luck.
    Move the dates backward 4 days from the original. No luck
    Move the dates 2 weeks forward from original. No luck
    Move the dates ...
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  2. #17
    Lily21 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2021
    Location
    Canada, Montreal
    Posts
    21
    Quote Originally Posted by Micron View Post
    I still think this is the wrong approach from a user friendly aspect because the OP suggests this scenario is likely:
    It seems that the dates are to be entered first, then choose the equipment, so I enter the 2 dates for which I need some particular equipment.
    Drop down the combo, my equipment isn't listed. OK, it's booked out? Or do I have absolute confidence that there's nothing wrong with the combo query?
    Now I move the dates forward 3 days. No luck.
    Move the dates forward 4 more days. No luck.
    Move the dates backward 4 days from the original. No luck
    Move the dates 2 weeks forward from original. No luck
    Move the dates ...
    Hi,
    I change that, user enter the date before and the equipment after that.
    Also, I used this query :


    SELECT Équipement.Id, Équipement.Équipement
    FROM Équipement
    WHERE (Équipement.Id) Not In (SELECT id_équipement

    FROM Réservation_équipement

    WHERE (Date_Début_réservation <= [Forms]![Créer_Projet_Form]![Date_Début]
    AND Date_Fin_réservation >= [Forms]![Créer_Projet_Form]![Date_Début])

    OR (Date_Début_réservation >= [Forms]![Créer_Projet_Form]![Date_Début]
    AND Date_Début_réservation <= [Forms]![Créer_Projet_Form]![Date_Fin]));

    The things it's only work when I select 1 equipment, when I select more than 1 equipment, its doesnt work, how I can change that ?

  3. #18
    SamL is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Location
    NJ
    Posts
    20
    Why not add a checkbox field to the equipment table, called 'Available'. It should be updated by an update query that's run daily, based on the contents of the date range fields. If Available is true, then it should appear in the drop-down box for user choice. If it's false, it simply shouldn't appear in the drop-down box.

    Sam

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 12-02-2020, 07:35 AM
  2. Replies: 3
    Last Post: 08-13-2020, 02:47 PM
  3. Identify the first selected item from a list box
    By jcc285 in forum Programming
    Replies: 5
    Last Post: 04-29-2020, 12:18 PM
  4. Change Font Color of Selected List Box Item
    By buckwheat in forum Access
    Replies: 2
    Last Post: 06-03-2013, 03:46 PM
  5. Replies: 4
    Last Post: 07-27-2011, 09:52 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums