Search results

Yes, that is what I tried but it doesnt seem to work. I made a testfield on the report (not in a subform on the report), and tried some code behind that as well but it doesnt seem to work. Im lost with this :confused:

Im afraid I cant post it, its pretty big and company property etc. I`ll try to set a context though: the database is used to register different chemicals that are used in the company. For each of these chemicals, there is a need for a safetysheet. On that sheet there are pictures describing...

I just tried this: If Reports!SafetySheetReport![Query4 subform].Form!PH = 2 Then Me.PHtext.BackColor = vbRed End If but again, i dont understand why it isnt working :S

sorry for the confusion. I have a report, which consists of a few subforms. I dont know if this is the best way to make a report, but the report is based on a form on which I used to "convert to report" function on, and it seems to work pretty fine as a report. The field I want to change is on...

I tried that, but to no avail.

Hi all. I already tried most suggestions regarding coloring a textfield on a report if a certain condition is met. I`ll give a sample of the code that i am currently using. the field in question is in a subform on the form. I placed this code on the form's on open event. If Me.PH = "2" Then...

Hello all, I'm currently working on a form that shows product information. This is the problem I ran into: The form uses data from two tables: Table ProductLocations stores ProductName and ProductLocations. Products can be found at multiple locations. Table Product stores ProductName and...

Hello all, A small introduction first. I am a computerscience student, currently working as an intern at a brewery. My task is to add functions to an existing database, and "optimise" it where a I can. The database contains information about dangerous products stored at the company. Think about...