Search results for query: *

I have the following code in my report module as the report is generated with VBA based on the data on the form. ' Select Case Forms!frmScheduled!grpSort ' Case 1 'Name ' Me.GroupLevel(0).ControlSource = "ScheduleDate" ' Me.GroupLevel(1).ControlSource = "What" ' End...

Hi, I am confused ... i have a report where the detail section uses a procedure. basically, the part of the code I am getting a Run-Time error '3021'. No Current Record Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim strSQL As String Dim db As DAO.Database...

I was trying to search but it's not working so ... I would like to be able to suppress the entire Detail section of my report if there is no data? How would I do that and would the EventProcedure go in OnFormat or OnPrint?

I am having issues with opening a form with subforms in another way. Currently it is set to have the user start with the customer form. When the customer has been located in which a quote will be entered the user would then click on a button to open another form for data entry. The customer...

Hi there! I did a search first to see if there's been a post on this but was unsuccessful ... I am using the multiple column in my report. I have 3 columns across. So it shows every invoice in each column. Everything is great except now management wants each each invoice to repeat 3 times...