Search results

Hi thanks for your replies, I just tried your suggestion Bob and I received the same error box. this is my code: Option Compare Database Private Sub Report_Open(Cancel As Integer) Me.Text7.Visible = False Me.Text10.Visible = False Me.Text12.Visible = False Me.Label8.Visible = False...

here is the screenshot of the error message

THank you all, and sorry for not responding sooner, its been a very hard weekend for me unfortunately. This code doesnt work for me, it fails on the same section (highlighted yellow): Private Sub Report_Open(Cancel As Integer) Me.Text7.Visible = False Me.Text10.Visible = False...

Hello I am attaching a screenshot of my code and the design view of the sub_report. I am not sure why it is not working? I am trying to accomplish this: the textbox named Application has a control source of Application. if the result is LAN, then I want it to hide a textbox and a label while...

Hello everybody, I am attaching my db in zip format. I have a man_email filter on, enter angelina.alba@man.com or jose.iglesias@man.com for testing, they are the best testing options. I have 3 subreports in my report. I am trying to make sure they display their information separately...

thanks for the help guys, im going to try and implement your methods

Hello I have a table I am trying to run a query from. One of my columns name is "Sports" the data in this column has over 15 sports, showing multiple times, because this table is for athletes and what sports do they play. In my query I want to do an if statement to display A for Soccer, B...

Yes, jasriel I have been thinking of your suggestion but I do not think I can do it this way. I would need for one report to open up fully with all the information I need. Unless I can have several reports display in 1 report it would be good, but having to close in order for the next report...

"First are you wanting all of the SubReports to be on the same Report? " yes. I have 6 subreports in the detail section of my REPORT. I wish for the 6 subreports to report their information one after the other, in order. meaning, subreport A(the first one) displays its information, then...

Hello, I have a few subreports in 1 report, all located in the detail section of the report. My question is, is there some kind of properties that will make the reports display their data separate from each other? Allow me to clarify, I wish for the first subreport to display its...

I have about 5-6 different applications which I need to do the same I have done with those 2 subreports. Each application will need to be displayed in a slightly different format like the two i showed. I am not sure how to do this without subreports? any example you may supply me would be...

Hi all, I am trying to design a report with various subreports, but having issues. Can someone please look at the database I am attaching and help me fix my mistakes. Ideally, the first subreport (SOCCER) should display once, and together. The 2nd subreport (FOOTBALL) should display once and...

Now, that it is understood what I am trying to accomplish. My real problem is that, I have a subreport in this report. imagine the textbox [APPLICATION] is in the subreport, while the labels are in the main report (not in the subreport). Can I still accomplish my goal with the...

thanks, I did this for my purposes: Me.Label53.Visible = False Me.Label85.Visible = False If Me.Application = "House" Then Me.Label53.Visible = True And Me.Label85.Visible = False Else Me.Label85.Visible = True And Me.Label53.Visible = False End If Because, my report is in DETAIL section and...

Hello, I cant figure this one out: I have a textbox with control source [APPLICATION], when I run/execute the report, depending on the persons name and etc etc, the application will display either: house, hospital, or car. At the same time I have 2 labels: Label1 and Label2. Nothing is...