Search results

Please help me to solve the issue of Double Booking. Two consecutive booking cannot be done, even there is no booking. I am tired of trying all aspects. I am attaching the link of My app https://drive.google.com/drive/folders/1M_bXj4hHkMJrsEaxc7jDx8ef7GNHr7f8?usp=drive_link

Its not being uploded even after zip. I am forwardimng the link Please help me to solve the issue of Double Booking. Two consecutive booking cannot be done, even there is no booking. I am tired of trying all aspects...

hi every one, how to upload a acces application in the forum for your help

Thanks a lot sir, my work is done

Private Sub CMDEL_Click() 'On Error GoTo ErrorHandler Dim sql As String Dim rs As DAO.Recordset Dim ActID As Long ActID = Me.OccupantID.value sql = "SELECT * FROM RoomOccupations WHERE ([OccupantID] = " & ActID & "" Set rs = CurrentDb.OpenRecordset(sql) With rs If Not .BOF And Not .EOF...

thanks a lot ... got your point, checking the details

Hi Sir/Madam I have a Room Reservation database, CHECK CONSTRAINT has been applied to the RoomOccupations table to prevent double booking of the same room by intersecting ranges: However, I am facing a problem that every time I wants to book consecutive bookings , an error message of CHECK...

sir thank you very much.. i have utilized a combo as you have suggested and my work is done. have a great time

Thanks for the concerns sir! I am adding records for booking accommodation in a Guest House Booking Package. I am using Add Button to add records. But sometimes its so happen that single guest is given two guest rooms with different Booking ID (Auto No) making entries of all details is somehow...

is it possible to fetch a record from a table and post in the text box of the form, for adding adding records. if so hoe can be done

Thank a lot its working fine

dim D as an intger D=year(Date()) U1 = DCount("[OccupantID]", "[RoomOccupations]", "[DepartureDate] > Date() And [FY]=D") i want to count the records in the table RoomOccupations where Departuredate is greater than the current date and the year is current year. FY is a calculated filed from...

thanks got it

If anyone can expalin me how can i send message through watsaap, and what to install in the system

I have to convert a report which consist of only one page, but every time it convert gets a blank page. However, the first page contain the page number as 1 of 1 only. I could not resolve, please help

Sir I have two table Member table and Restaurant table. Now i want to append the records in the Restaurant table from a form having members and a few unbound text boxes which will have the same inputs for all members

Hi Respect Sir Can I append a table with the values from a continuous Form having records with criteria

Hi Sir How can i attachment of id or any document mendatory through validation rule VBA Code

Private Sub CMDSEARCH_Click() Dim SQL As String SQL = "SELECT MASTER.[AC_NO], MASTER.[EMP_NAME], MASTER.[DOR], MASTER.[PPO_NO]" _ & "FORM MASTER" _ & "WHERE [EMP_NAME] LIKE '*" & Me.TXTKEY & "*' " _ & "ORDER BY MASTER.[EMP_NAME]" Me.SUB_FORM_LIST.Form.RecordSource = SQL...