I am trying to add more than three conditional formatting conditions such that
If the Moisture values is > 3.5 it turns the text box = Red
is between 2.35 - 3.25 , the text box = Green
is > 3.25 and < 3.5 = Yellow
is < 2.35 and >2.10 = Yellow
is < 2.10 = Red
How...
tulikapuri
Last Activity: May 23 '07, 03:05 PM
Joined: Feb 15 '07
Location:
-
Conditional Formatting Error
-
it gives me runtime error '2465' that it cant determine the txtrange? -
I could do this successfully but its asking me for the txtrange, what should i enter here?Leave a comment:
-
Create charts in access with time, date and value
Friends ,
i want to chart the data from report for on daily, weekly and monthly basis and i have three variable i.e. time , date and Moisture.
Can someone guide me how to arroach this issue, its simply driving me nuts. -
I dont know, i am already running out in time becuase of the deadline of this project and i dont know how i can really sort it out now :(, nothing is working, i think we should have a provision in this wepage to exchange DB's as it will make life more easier.
Do u have any other email address where i can zip it to you becuase if you just review it once i am sure something will work out.
Thanks ,
Tulika...Leave a comment:
-
Yess, these are the SQL's for the tables Sand Lab Data, Friability of Green Sand and Loi Molding Sand.
What do i change the time and date variables as , and why do we need to change them, what relationships are required?Leave a comment:
-
How do i enter this format now, i opened the detail column and it doesnt show me correctly the build property, since i have seven different fields like moisture, temperature, GS, Compactibility etc. and all have different values, so what should i do now??...Leave a comment:
-
Table 1. Daily Sand Lab
Field Name; Field Type; PK/FK
ID ; Autonumber; PK
Date; Date/Time;
Time; Date/Time;
Unit; Text;
Operator ; Text;
Temp;. Text;
Mois. ; Text;
MB ; ...Leave a comment:
-
Thanks i got it right till here, but now since i have report with sub reports and each field had conditional formatting ,
First of all, can i look at the code for the three conditions i wrote , so that i get an e.g. of how to build the code.
Secondly, how do i do the conditional formatting for each and every single field?
For e.g. I have moisture values which should be green if its in the range 2.35...Leave a comment:
-
What is FK/PK?Leave a comment:
-
rabbit i followed your instructions in last post and have a form named frmName and have two textbox fields startdate and enddate , i have set the date criterion as Between [Forms]![frmName]![StartDate] And [Forms]![frmName]![EndDate] in all the individual queries.
1. now i open the form frmname
2. enter the startdate and enddate in form.
3. i have a command button on the form to open the main report
4. i use that...Leave a comment:
-
Can you please tell in more detail as to how can i get it done, actually i am new to access DB and dont know a lot of stuff.
I tried as desribed in your last post but i could not find the format () Event in report's detail section.
Thanks,Leave a comment:
-
I am trying to do the conditional formatting in a report where i have added some other sub reports aswell, so how do i write the code for tht now?...Leave a comment:
-
Okies i got you.
Thanks a lot Rabbit.
Ya helped me a lot :)...Leave a comment:
-
How do i get here, and how & where to write a code ?...Leave a comment:
-
yess thts right...Leave a comment:
-
Conditional Formatting ?
Can someone please guide me an easy way of having more than three conditional formatting conditions? -
I have tried this but it is not working too, i have changed the control source property in the form.
I have following fields, Date, Part Number, Good pieces, External Scrap, External Scrap % and Total Production.
Now i want external scrap % to be calculated by itself on this form when i enter the values, so i set the formula for external scrap % = ([External Scrap] / ([External Scrap] +[Good Pieces])) in the control...Leave a comment:
-
I have a query where i join all the tables i want in the report, i add the criterion in the date as Between #[Forms]![frmReports]![txtStartDate]# And
#[Forms]![frmReports]![txtEndDate], but when i generate the report , i dont use this query, i use individual reports which are based on different queries, becuase if i do it using the query the report doesnt come out in the format desired.
So i am making a report with subreports...Leave a comment:
-
SQL of query?Leave a comment:
No activity results to display
Leave a comment: