Recent content by mafhobb

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?