Search results for query: *

Jarvo807, I also ran into this problem, with having several different sub-reports tied to the main report, which is filtered based parameters from a form. Using the Master/Child relationship can work, but if you're trying to pass a filter to the sub-reports, I had to open the sub-report up in...

AlexCuse, I had thought about just putting a default value ="NC" for no change that would eliminate the NZ problem. I want to store the changes so I can produce a report showing the complete record and requested changes, who requested the change, date of request, etc. Then have the requester...

AlexCuse, Thank you. It does prompt me to append the record, but won't append because of the Null values of the other fields (30). How do you overcome the Null values?

I have a Form which contains Data from Table1. Under each of the data fields textbox is an unbound text box. This is to allow me to identify changes. Example: Field1 = "Steve", txtField1 = "Mike". I want to Append/Insert txtField1 into Table2, which contains the same data fields and structure...

Remou, Once again I have to pass on my thanks. This worked perfectly. Steve

Problem: I have a form that generates an email to the system administrators. There is a lboAdminEmail that is populated by code and only contains email addresses of select individuals. I have a cmdButton that generates an email and puts the email addresses in the To: block. But only after I...

Remou, That did the trick. Not exactly my preferred method but it will work until I can come up with something else. Thanks again for the assistance. Steve

Remou, Thanks for taking the time to help and offer suggestions. I'm using Access 2003. We're you putting the filter code on the subreport, or having the mainreport pass the filter to the subreport? I've heard of opening the report in design,update the filter, save, and close it, but not...

Remou, Here is the code for on open event for the subreport. As you can see I've tried several different ways to pass the filter to the subreport Private Sub Report_Open(Cancel As Integer) Dim strFilter As String 'strFilter = Reports!CalledUMDMainReport.Filter 'Me.Filter = strFilter...

Remou, Thanks for the suggestion but when I try to change the record source I get the run-time error 2191 - You can't set the Record Source property in print preview or after printing has started. The subreport runs find on its own by changing the code to what you suggested, but it has...

I have a main form with several (8) combo boxes, which after making selections creates the strWhere clause for the main report. I also have two subReports that are in the MainReport used for providing totals (take to long to explain why). Anyhow the MainReport works great, the first subReport...