Search results

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

Thanks Bob! That worked! It opens on the left of the screen though. Is there any way I can have it be in the center of the screen?

I have a form (Popup = Yes, Modal = No). I have a command button on the form that opens a report. When the report opens - it opens behind the form. I can't close the form before opening the report because the report is dependent on a value of a field in the form (Honestly, I wouldn't want to...

Try: DoCmd.OpenForm "frmQuoteOverview", acNormal, , "

Thanks for the tip! Hadn't thought of that!

Moke123 - I use tags for that purpose all the time. But a control only has only one tag property. What do you mean by: My declarations are correct. You can check the value of the variable by using the vartype function. Thanks for the db.execute tip! Auntijack56 - I'm not sure I understand what...

All of the goals are now linked to the tasks. When a user clicks on a task lst_Goals presents only the goals associated with that task. If they doubleclick on a goal then they will have the option to delete it. If they doubleclick on a task they will have the option to delete it and all of its...