Search results

Thanks everyone for your input. I still can't determine what is wrong. See attached sample. This is very weird. Steps to reproduce error: 1.) Open frm_BillingReview 2.) Select Date of Service from the option group 3.) Select 1/3/2022 from the combo box 4.) Click the Get Data to Review button...

Thanks for responding. The names of the fields are: Client_Name, Date_Of_Service.

I know. This should be an easy one - except for the fact that my combo box is unbound. I have an option group that lets the user choose to search by name, date, therapy, payer etc. If they choose Name (or anything else) then the rowsource for the combo box is dynamically populated accordingly...

Sorry isladogs. I misinterpreted your post. You are correct.

How can I get the Report Footer to "precede" the Page Footer? I can't move it up in design mode.

I hope this isn't a dumb question but I have a report that consists of: Report Header Detail Page Footer Report Footer When I view or print the report the Report footer always displays before (above) the Page footer. Shouldn't the Report footer always be at the bottom? Can anyone please tell...

Thanks Pat! Much appreciated! I will study these events!

Thanks for the tip CJ_London!

Thanks Pat! Works perfectly now!

I have the following code in the On Print event of my report footer: Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) If Me.Page = 1 Then MsgBox Me.Page Me.[lbl_ClientName_Footer].Visible = False Me.[txt_ClientName_Footer].Visible = False Else...

MajP - I had to change your code to what's below. It seems to have solved my problem! Thanks to both of you for helping me out!!! If Application.CurrentProject.AllReports("N_Note").IsLoaded Then DoCmd.Close acReport, "N_Note" End If

I have a command button that, when clicked, opens a report. I feed it a unique Trans_Id so that it opens the report with the data that pertains to the form that the user is viewing. The first time I open the report and Trans_Id = 14 it opens the correct report. If I change the Trans_Id to 15 it...

Thank you sxschech and dbGuy for not being rude and presumptuous – and thank you to everyone else for responding to my post. If every moderator and generous contributor to this forum were to be assigned the same task we would all approach the task in our own unique way, utilizing our own unique...

Perfect! Thank you so much!!

DBguy - For some reason the datepart function doesn't recognize vbMonday. If it did I think this would solve my problem.

Plog - Thanks. I'll spend the next few months writing a treatise explaining the big picture so that, one day, you and I can have an abstract conversation about motives and methods of application development. Stay tuned!

No. If you can peak at my code it's very simple. I'm missing some logic somewhere. Didn't sleep well last night.

Thanks DBguy. Can you please elaborate?

See attached db. The Get_WeekNo() sub gives me the results I need - but there must be a more efficient way of accomplishing this that I just can't think of at the moment. I'm trying to update the TheWeekNo field to the proper week number. Each new week begins on a Monday. As I said the procedure...

Thank you so much!!!