Search results

  1. M

    Calendar

    Hi arnelgp. Cancelled reservation are not not shown in the calendar...THANKS YOU!!! I will see if I can figure out the gap deal. Since the effect that your coding added is not the same as the one that I did Could you indicate where is it that you adjusted it? I belice the it is here...
  2. M

    Calendar

    Hi arnelgp. Thank you for the last db version. I am reviewing the calendar that is displayed when the date 12-Mar-2021 is entered and here is what I found: -As you mention, there seems to be some overlapping reservations, however when I look at the reservations table, the ones that overlap are...
  3. M

    Calendar

    Hi arnelgp. I've now tested the calendar and I have to say that it is very close to being perfect. Many, many thanks for your help so far. I have found a couple of things that need tweaking and I've tried to do some of the changes myself but I run into erros. 1) I forgot to mention earlier that...
  4. M

    Calendar

    This is great. I will be back in front of my computer later today and will test all this. Will the previous strategy to move the starting point of reservations towards the right side of the day “box” in the calendat still work? This would help much as a reservation can end and a new one begin...
  5. M

    Solved Date Picker value depending on another control

    Thanks everyone
  6. M

    Calendar

    Ok, so I have uploaded the holiday planner into a simplified version of my db so I could try to do this without risking the original data. Also attached I have an image of the tables as they are now. The row of three above is from my db and the three below are from the holiday planner. I know...
  7. M

    Calendar

    Wow. Thanks! This planner with your changes does exactly what I need. I am now going to attempt to merge it with my current database and its structure. If I can get this done it will be a huge help. My data in my db is stored in the same number of tables and they have the same relationships. The...
  8. M

    Calendar

    Yeap. It worked...This is what I ended up with: ' Modifying the .Left. The day width is 530. The staring point is moved to the right + 315 .Left = EMPLOYEE_COL_WIDTH + Abs(rs!DateStart > Me.CalendarStartDate) _ * DAY_WIDTH * DateDiff("d", Me.CalendarStartDate...
  9. M

    Calendar

    That database is indeed very close to what I am looking for. I think that I would only need to make two changes to it: -The first one would be to displace the starting and ending points 1/2 a day to the right as reservations count nights, not days. So I need to find the code that positions the...
  10. M

    Calendar

    I have been working on a reservations database that I have been building slowly for the last couple of years as I've had different needs. it is not perfect or even pretty but it does exactly what I need. Now, I am trying to create a calendar based on a couple of tables that contain the...
  11. M

    Solved Date Picker value depending on another control

    Question: This will only affect the new record that is being entered, but not the other ones in the same continuous form, correct?
  12. M

    Solved Date Picker value depending on another control

    Hi I have a continuous subform where I enter reservations. In this subform, I have a textbox "CheckInDate" where I enter the start date for the reservation using the date picker. Just below I have another textbox "CheckOutDate" where I enter the ending date of the reservation also using the...
  13. M

    Solved Combo Box rowsource from four different tables

    The Union Query did it nicely. Thank you very much! mafhob
  14. M

    Solved Combo Box rowsource from four different tables

    Hi. I have inherited a database that has several different tables (tblelectricians, tblplumbers, tblcarpenters,tblgardeners) and each of these tables has a field which includes names (electricianname, plumbername, carpentername, gardenername) I am building a form with a combobox and as...
  15. M

    Overlapping Reservations

    Got it working! Many thanks to everyone. Your help was invaluable. mafhobb
  16. M

    Overlapping Reservations

    OK, So if I want to validate the dates as I enter them, then I simply call for public function isoverlapped on before update for the new reservation? But how does this function account for the different properties? Then, if at some point I need to test al the reservations, I call for GetCross...
  17. M

    Overlapping Reservations

    Thanks! This is pretty close to what I was looking for. Question1: Is there a need to keep mModule on V02? What does it do? Question 2: Is there any way to only list the conflicting reservations in the query? I tested <>"" in the criteria and it worked. Any reason not to use this? Question 3: I...
  18. M

    Overlapping Reservations

    Hi JDraw. Thank you for the suggestion. Yes, I knew about this query; this one lists the reservations in a specific time period, but I already had that worked out. What I need is one to find reservations that overlap other reservations for each unique property. Any suggestions on that? mafhobb
  19. M

    Overlapping Reservations

    Hi. So I have a db where I collect reservations for a few properties and I need to find a way to test if a new reservation overlaps an existing one. ID PropertyName GuestName CheckInDate CheckOutDate ReservationSource CleaningAfter Status 1 Son Bota Owners 03-03-21 07-03-21 5 No Active 7...
  20. M

    Update a second subform from a first subform through an event on the first subform

    I have a main form with some property info that contains one continuous subform. This subform is called "frmProjectSubform" and it contains a list of projects for that property. Now I want to add a second continuous subform "frmProjectHistorySubform" next to the first one to show the history...
Back
Top Bottom