Recent content by Galstar

If that was the case then: Me.OrderBy = SortedBy desc would work, and it does not. The SortedBy value = [Last Name]

I have this code executing upon Open report procedure. All vales are coming from a form. it sorts by default Asc so of course that works. But the sorting by desc is not working. Anyone have a reason why? ***Code Starts Here****** Dim SortedBy As String SortedBy = [Forms]![Reports]![Sort]...

I figured it out I found out that the Special Keys had been unckecked in the Startup. This prevents it from stopping on breakpoints among other things. Thanx for helping though

I have several objects on the form that allows me to print reports. One object shold allow me to run the report but with a different query due to the math. How if open/runnign report from button can i chaneg the recordsource of the report? Private Sub PTReport_Click() On Error GoTo...

Strange one for me. My VBA no longer stops at breakpoints. If I go into code behind my froms and click a line fo rit to stop an drun the form. Nothing it runs the code but never stops(breaks) Why? what did I turn off??

Okay, I want to have a parameter that allows me to select "<" or ">" I have a box on a form so I can pass the info to the report. Why will this not work?? IIf([Forms]![Reports]![Math]="Less",<Date()-[Forms]![Reports]![ptExpireDays],>Date()-[Forms]![Reports]![ptExpireDays]) so if the use...