Search results

So I have a report which pulls data from a table (tblreservations) via a query. SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.CleaningComments, tblReservations.Status...

Hi. I have a db with a report that contains a number of labels. On the onload event of the report the label caption is updated: Me.lblToday.Caption = WeekdayName((Weekday(Date, 2))) & ", " & Date There are two ways that I use this db. The first one is by opening a form and going from there...

I have a listbox (SearchResults) on the form "FindGuest" that uses the following rowsource: SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.ReservationDate, tblReservations.Status...

On a form I have a combobox pulling its values from a table (tblResOrigin). The table has two fields (ID and ResOrigin) and on the combobox the bound column is the first one (ID, a number) but it is not visible and the visible text is the second column (ResOrigin, a string). This is the...

I have a form (frmMain) with a continuous subform (frmReservations) that contains reservations with dates (CheckInDate) both past and future. FrmReservations (the subform) is sorted by date (which is needed), but when it is loaded, it always selectec and displays the reservation with the...

So I mave a form called "frmPropertyHistory" with a textbox "findGuest". When I enter a string in this textbox, another form opens "frmFindGuest" with a listbox "SearchResults" displaying the matcing results. This is the query in the listbox Row Source: "SELECT [qryFindGuest].[ID]...

I have a report with a query as source. This query contains a checkbox field from a table (on the table it is set up as Yes/No, default=No). In the query results, the checkboxes show up correctly (either marked or unmarked). On the report I also have a checkbox to show the results of this...

Hi. I have a report with a subreport that shows today's check ins. The subreport is really simple, showing just property, guest name and phone number. The source data is a query. SELECT tblReservations.[ID], tblReservations.[PropertyName], tblReservations.[GuestName]...

I have a table with a list of projects and a related table with the project history. I am now working on a simple query to bring up all projects and their last history comment. SELECT tblProject.PropertyName, tblProject.ProjectName, tblProject.Status, tblProject.Involved...

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

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

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

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

So I have this form "frmProjectHistory" with a subform "frmMaterialsUseSubform". There is a combobox on the subform called "cmbMaterialsUsed" with a row source: SELECT [tblMaterials].[ID], tblMaterials.[Material] FROM tblMaterials; On this same subform there is a button that opens a continuous...

Hi. I am getting odd query results and I don't know why. I have a table (tblMaterials) that is a simple list of materials with a cost. Then I have another table (tblMaterialsUse) that is linked to properties so I can keep track of what materials are used for each property. At a table level this...

I have a report with several subreports. I have a subtotal sum on each subreport and on the main report an extended sum of all subtotals. When the sum of a subreport's subtotal is null or = 0 (It displays 0.00), the extended total on the main report displays a "#Type" error, however if I...

Hi. I have a report with a number of subreports. These subreports get their data from a query. How can I detect if one those queries returns no results so I can hide the subreport on the report? mafhobb

So I have a simple query to get sales results based on properties and then a grand total: This is my SQL: SELECT tblReservations.PropertyName, Sum(tblReservations.ResAmount) AS SumOfResAmount, DSum("ResAmount","tblreservations") AS Expr1 FROM tblReservations GROUP BY...

Hi. I have a simple query with the criteria based on a value in a field: =[Forms]![frmDocumentParameters]![cmbCleanerSelected] This works fine when I have data in the combobox. However, what I need is for the query to return all records if the combobox is empty. How do I do this? mafhobb