Search results

Hello Forum, Kindly assit me solve the following problem. i have read the posts on running totals but somehow i cant solve it right. i have a table with health facilities (A,B,C,D) . each health facility has data from several months (Jan, Feb, Mar etc). the table has 2 fields (New Patients) and...

Hello Forum, I would like to change the text color in a field depending on the value in the field called Results. The code I have entered is as below. Private Sub Report_Load() If [Results] = "POSITIVE" Then [Results].ForeColor = RGB(255, 0, 0) Else [Results].ForeColor = RGB(0, 0, 255) End If...

Hello Forum, kindly assist me solve the following problem. I have a Parameter form which provides various parameters to my queries. The Parameter Form has a Combo box with a list of 50 health facilities which the user can select according to their needs. There are instances when a user needs...

Hello Forum, I have been trying for several days to develope a form to supply parameters to a query and a report in my database. the sample code in the form's On open Event procedure as as below : Option Compare Database Private Sub Ok_Click() Me.Visible = False DoCmd.OpenQuery "711ARTData...

Hello guys, I have written the following expression in a Ms Querry. I have a table called 711PMTCTData which has a Look up field called MonthReported with Text as data type. the data entered in that field are the abbreviations (Jan, Feb, Mar upto Dec). I would like the expression to return in...