Recent content by Jim W

I have 2 subforms on a main form. I would like to compare the value in field 1 og subform 1 to field 1 of subform 2. I can't seem to get the conditional foramtting between the 2 subforms to work. Any ideas? Jim

I have a main form with 4 subforms. The subforms a setup in columns kinda like excel. Eack subform is displaying data. What I want to do in compare the data in subform 2, 3, 4 to the data in subform 1 and if different using the conditional format change the color of the fields. How do I code a...

The difference is that the command button I'm want to disable is on the form not the header or footer. Each record or form has the button. Jim

Its not a subform its a continuous form Jim

I have a continuous form setup that has a check box field (Yes / No) I also have a command buttom to preview data. How can I code the command button for each record so that is the check box = No then the command button is not visible. I had code in the on open but it seem to either make the...

Wayne - I'm looking for the second part of your replay. I'm trying to compare differences between configurations of system settings and the systems are a variable that users select from. So I want the report output to look like this -------- System--System2 Config 1--setting--Setting...

Is it possible to format the detail part of a report into a column? If so how? Jim

I hope I can explain what my problem is here. I have a make table query that changes the system / Systems when it runs based on what users select. This part works fine. I then run a cross tab query on that table but the query has issues with the fact that the system keeps changing. I there a...

Ok I'm getting much closer to the end result but I'm having a problem with the report. When I layout the report based on the crossTab I have Config and System. I can't seem to get the System on the top of the column as below. -------System -- System2 <--- does not show up on the report Config1...

So then I need a second table that stores the config1 = configNum and so on Jim

What is the confignum field for? and why do I need that? Jim

I have a table which contains several configurations for equipment. I'm trying to write a query to sort the data for a simple conparison but am having great difficulties getting it to work. The data is stored in the format below. System Config1 Config2 Config3 Config4 etc. etc When I run my...

I can set the columns but can I change the layout for the second and 3rd columns. I doing a comparision report for a configurations so what the report look like now if I have it set to columns = 3 Setting 1 22 Setting 1 32 Setting 1 44 Setting 2 11 Setting 2 10 Setting 2...

Could somene tell me how to create a multiple column report? I'm trying to create a comparision report from a config table and I can't seem to figure out how to get the layout in columns. Thanks Jim

I have a cvs excel file with 8000 lines, I would like to try to input these fields into 1 table is this possible?