Search results

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

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

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

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

Thanks everyone

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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