Search results

I am trying to color labels on a calendar-type form, based on a query. A table contains various reservations at a property with a number of check in and check out dates. I have a form with 93 labels (3 for each day) and I need to color them based on the check in and check out dates. With the...

All I am trying to do is to allow for holidays to end on a date and another holiday to start the same date that the first one ends. Or conversely, have a holiday that ends the same date that another one starts. This would basically do 90% of what I need. mafhobb

Ok, so this database is close to what I need so perhaps I can use it as a base. I have been tweaking some of the code, but I can't get something to work. The following code checks if there is an overlap between a new holiday that is being entered and an existing one. If there is an overlap...

I managed to make it work by adding "ptrsafe" after "declare" I am now checking how it works. mafhobb

Hi. Sorry for the late reply. Work got in the way. The error actually comes up with modfileselect. See attache dimage mafhobb

Unfortunately I have a 64-bit version and the db is in 32-bit

If it is the one that I downloaded, it does not work on 64 bit. Any idea where I can find a version that works on 64 but or how to convert it? mafhobb

mafhobb

Sure mafbus@gmail.com

Hello MickJav, I have been looking at some of the images and explanations that you posted on the Employee's example and it looks like it may be what I have been looking for, but when I download it from the databasedreams forum I get a "Needs to be updated to work on 64-bit system" error. How can...

Their system must be down as I get errors when trying to log in

Hi theDBguy, Thank you for this. It will be helpful, but the first step is to create a "linear" calendar similar to the images that I posted earlier. How do I go about creating such calendar? In simple terms, I assume that I need to create a form with the "dates" bar, showing the dates, then a...

Hello. I am going crazy with my excel sheets,...so I am looking for suggestions for a Access calendar-type database that would allow me to keep track of the guest reservations of a few properties. More than anything, I need to find something that allows me to display the reservations of the...

I am afraid that this is a bit over my level... -How can I include the Rooms table in the subform's recordsource if the recordsource is a query?SELECT RoomOccupations.* FROM RoomOccupations ORDER BY RoomOccupations.EntryDate; Mafhobb

Sure. The issue is in the form "Room Reservations" in the combobox under "Room" mafhobb

No, I have not used lookup on the table Yes, I have tried to adjust the column widths (and set the first one to 0) and the only result is that the first column (RoomNumber) disapeared, but the second column was still blank. Jut to make it clear, the combobox is working fine when I have it...

So I have this two-column combo box which uses a query as source. This is the query: PARAMETERS Forms!frmOccupants!sfcReservations!EntryDate DateTime, Forms!frmOccupants!sfcReservations!DepartureDate DateTime; SELECT RoomNumber, RoomName FROM Rooms WHERE NOT EXISTS (SELECT * FROM...

Anyone? Any suggestions as to where to look for info on this? mafhobb

Hello Sonic 8. I basically have a Homeaway calendar where Homeaway guests add reservations. I can synchronize this Homeaway calendar with AirBnb by simply sharing the calendar link (http://www.homeaway.co.uk/icalendar/5f5e24d025574d1d8e96b46185387b942.ics) I have another, similar link to sync...

Can an existing iCalendar on the web be synced with an Access calendar? Can it be interacted with? (see, create or edit appointments on both the web and access) mafhobb