Search results

This is what did it in the end:SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.CleaningComments, tblReservations.Status, tblReservations.PhoneNumber, tblReservations.CheckInContacted...

I've tried to adapt your sugegstion, but I am runnign into some issues. This is the query code: SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.CleaningComments, tblReservations.Status...

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

Nevermind. I found the option through the task scheduler!

This did it: Public Function SendRPTTodayReport() DoCmd.OpenReport "rptTodayReport", acViewPreview, , , acHidden DoCmd.OutputTo acOutputReport, "rptTodayReport", acFormatPDF, "\\Servidordatos\IFly\DB Public Data\Today Report\Today" & ".pdf", False, "", 0, acExportQualityPrint...

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

Thank you everyone. Gasman: Looking at the debuggin videos. arnelgp: From my last try, it was the single and double quotations and their location in the "Like ....." that was messed up. Thanks!

I think that I did, but I am not sure of the process/syntax. I basically did this: Debug.Print a = "SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.ReservationDate...

MsgBox Me.txtFindGuest MsgBox Forms!frmFindGuest!txtFindGuest.Value Me.SearchResults.RowSource = "SELECT tblReservations.ID, tblReservations.PropertyName, tblReservations.GuestName, tblReservations.CheckInDate, tblReservations.CheckOutDate, tblReservations.ReservationDate...

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

Thanks for the comments.

Thanks for the comments. I make sure that all reservations have the required data by validating the data when entered, so while not perfect, I should be covered.

I think that I solved it. I added a relationship between tblreservations and tblresorigin, joining ReservationSource and ResOrigin. This did not seem to create any issue as both fields had matching data. Then, I modified the query to this: SELECT tblReservations.ID...

Nope. I don't seem to be able to make this work either. Same results.

The Doc Man: So is the solution to have three queries, one for tblreservations, one for tblResOrigin and the a joint one to combine the two results?

Thanks, but I tried that earlier and when I do I get a bunch of results that are not what I am looking for. I believe that this is what The Doc Man was referring to as a "Cartesian JOIN"

I think that I understand much of what you are saying, however perhaps I did not explain the tables well. TblReservations does have a field that contains the reservation source. This is the filed ReservationSource on tblReservations. Unfortunatelly the data saved in it is the ID value of the...

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

Could you please clarify something for me? The main form where this subform is placed in is loaded when the database is opened and then the data in the subform is updated by changing the value of a combobox in the main form using the following code: DoCmd.SearchForRecord , "", acFirst...

Many thanks!