Search results

No, I do not believe it has to be an Option Group, but I'm not very familiar with Boolean and I could easily set up the Option Group to remain independently checked/unchecked, specific to each record. I'd happily take another route.

I have an Option Group object with "Yes" and "No" check boxes that automatically produce a value of 1 or 2 for the Option Group frame that they are in. The control source for the Option Group frame is [Support Required]. How can I get the Option Group to place "Yes" or "No" in the [Support...

I had a similar problem This is what worked for me in my report Private Sub cmdPreviewReport_Click() On Error GoTo Err_cmdPreviewReport_Click Dim frmCurrentForm As Form Set frmCurrentForm = Screen.ActiveForm DoCmd.RunCommand acCmdRefresh DoCmd.OpenReport "CEARequest_report"...

I figgured it out !!!!! I finally figured out how to Preview Report for ONLY the current record WITH its current subform records. I can't beleive it !!! This is what worked for me. Private Sub cmdPreviewReport_Click() On Error GoTo Err_cmdPreviewReport_Click Dim frmCurrentForm As Form...

I've used this same thing (just different object names) in another database to preview only the current record and it works fine. In this database, however, when I click the cmd button, I get an error message of "Data type mismatch in criteria expression". My report is "Report2", my field is...

Thanks Fornatian. It is Access 97 and that's good to know. Does that mean, however, that a newer version would be capable of doing this?

Changing text color of row in a query based on values I need to flag records in a query & it's table base on the results of an expression. This database has different Equipment at different Location with a DateTested compared to the current date to show the TimeSpan . For any record that has...

I did this and it works. Add a Text Box (which ever is best for you) to your report. Click Properties for that object and next to Control Source type something like this: =[City] & "," & [State] & "," & " " & [Zip] or whatever your field names are in the table. and when you preview the...

Nevermind on this one. I figured it out when I fixed another problem I posted. Thank You anyway.

Thank you very much to Fornatian for your help. I regret that I didn't get to use it though. As usual, after I have taken an issue & blown a huge bubble out of it, something simple occurs to me. I was using my subform as the source for the subreport object. So I corrected this issue by...

I have a form with a subform and a Report Preview cmd coded to open the report for only the current record. This is successful, however, the report shows the subform info for all the records. I've tried to tinker with the code to do the same for the subform as it does for the form (to show...

I have a "Request" form that includes an "Equipment" subform where the user can enter devices and their costs of items they want from inventory. The relationship of the two tables is by REQUEST# and the user can print their report based on this request#. Therefore, for each request, the...