Search results

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 figured out why/when this happens, but I still need a solution. The checkboxes on the report show up in the report when there are no query results at all. When there are results, then the checkboxes appear correctly. So, how do I hide the boex when there are no query reults?

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

Ok. I expected to be able to just change the report source to a different query, but that does not seem to work. Perhaps it is the process that I follow that makes it impossible. So, I have the main report (rptTodayReport) and the subreport (rptTodayCheckInsSubrpt) near the top side of the...

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

Still the exact same error, and when accepting it, the message dissapears and all seems to be working well. Why would the "On Resize" sub be called anyway when closing a form?

Well, it is this simple code to open the Calendar form from frmDocumentParameters, whcih stays open in the background: Private Sub cmdOpenCalendar_Click() DoCmd.OpenForm "Calendar" End Sub This is the OnLoad event for Calendar Private Sub Form_Load() Debug.Print...

Thank you!

I don't understand how a closing form could "look for itself" when closing...this has to be code that comes from somewhere else.

Hi Pat. I agree with you...If I get to the point of having to do a new db version, then I'll try to redo this as you suggest. Thanks

...I am not sure how to move on from this...

[/CODE]

Like this? SELECT tblProject.PropertyName, tblProject.ProjectName, tblProject.Status, tblProject.Involved, Last(tblProjectHistory.CommentDate) AS LastOfCommentDate, Last(tblProjectHistory.HistoryComment) AS LastOfHistoryComment FROM tblProject LEFT JOIN tblProjectHistory ON tblProject.ProjectID...

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

Still the same error

Ok, so I found how to do this, but simple commenting out the code in the sub that did this. That said, I have another question: I added a "close" button on the calendar form. This is a simple Private Sub cmdClose_Click() DoCmd.Close acForm, "Calendar" End Sub but something unexpected...

Now that this is worked out, there are a couple of small things that need attention: -When double clicking on a reservation bar it is possible to edit the reservation GuestName. I've inadvertantly deleted a number of "GuestNames" with this. Can this double click option be deleted? - I am not...

This is what I've come up with. The first IF checks where each reservation begin and it compares it with the calendar. If it begins before the calendar star date then the begining of the bar is right at the start of the calendar, otherwise it starts at half the width plus 20 The second if does...

Starting points of the calendar bars: Since I want all the reservation's bars to begin at ((DAY_WIDTH \ 2) + 20) then I do not really need to have an IF to check this; I just need to make sure that all the .left for all reservations is at ((DAY_WIDTH \ 2) + 20). I just need to make sure that...

Ok, so this is what i believe that this code does: ' arnelgp ' The following line checks the current checkin date and compares if it is equal or earlier than the last reservation's checkout If current_ID = rs!id And rs!CheckInDate <= last_Date Then...