Recent content by Archie1

Thanks for the suggestions. I will have a re-think

Hi I have a form (helped by you guys) which has the fields Risk Probability(RP) and Risk Impact (RI)(both are from TblRisks ) - My next field is Risk Evaluation (RE) I have an update query which updates RE depending the results of both RP & RI Eg If "likely" is selected from RP and "Moderate" is...

Hi -Just to test this out I made a "test " table and "test"update query The SQL is UPDATE TEST SET TEST.RE = "low" WHERE (((TEST.RP)="l") AND ((TEST.RI)="neg")) OR (((TEST.RP)="UL") AND ((TEST.RI)="MIN")); This works for the above outcomes so can I now add to this for outcomes that would...

I will have a go at that thank you

Hi -Is this possible please? I have a form FrmRisklevel It has fields Risk Probability and Risk Impact (both are from TblRisks and the fields are look ups from other tables) - My next field is Risk Evaluation My preference is Risk Evaluation will autopopulate based on the selection of the...

Thanks for your reply. Sorry, I do have 2 tables. TblContractor containing Contractor name and ID. TblRisks containing the yes/no fields

I have a "Risk Assessment" table with Contractor information and then a few yes/no fields. One or multiple fields could be = yes which would change with each risk assessment I would like a report to show the Contractor Info fields and then only the fields = yes and omit fields = no. Presuming...

Hi Again How would I go about adding a date parameter to my union query? My required end result is a report that would prompt me for the month ie "June"

Ahh ok I will have a re-think then

H I have the following tables:- Employees, Supervisors, Line Managers, Dept Managers. The tables store Appraisal information amongst other things. I want a query to extract Appraisal review dates from all the tables so I can then print it in a report to easily see who is due a review. I have...

I decided to start again and re-do the forms. I designed a blank form with a combobox to select the employee. I then dragged the subform and linked by leader ID. For some reason it worked. I can now select the employee from the combobox which autofills the form. I then click my new command...

Thanks for the advice! I am very new to Access and appreciate the help from you guys. I will have a go at that

Many thanks for your help. Its still not working. Error message "Compile Error -Expected:End of statement. The word "Reporting" is hilighted in that error. Ive checked the names of everything and its all correct. My method (form) is as follows - I created a form with a combobox to select from a...

Have just tried your code as follows but getting this error "Compile Error expected end of statement" and the word "reporting" from my subform name is hilighted? Private Sub Command20_Click() DoCmd.OpenReport "RptIDBE", acViewPreview, , "Leader ID =" & ME.Accident Reporting...

Thanks for your help. I have googled but cant find a lot. My combobox selection is called "leader ID" and not Employee ID as I originally quoted and My report is called RptIDBE. One post on google said I needed to have the name of the combobox in there? With the following (copied and pasted) its...