Recent content by Russie

Hi. I have a form that calls other forms, when it does this the other forms open behind my main form. I believe this to be to do with the 'Has Module' flag being set to 'yes' in the 'Other' tab of the properties window. Has anyone experienced this before? I've copied the form code sidewards...

Hi. Is it possible for a combo box to display columns from more than one table? Thanks.

Hi. I have tblInitialRiskAssessment linked in a 1:1 relationship with tblControlledRiskAssessment. I've created an edit form for tblInitialRiskAssessment but because it's linked to tblControlledRiskAssessment it won't let me save. I'm not changing any primary data, i'm only trying to edit...

Thanks Ace. When I clear the record source for the form and load it I get a #Name? error on all fields. Obviously because the control source for all fields are set it is trying to resolve the table name. What did I do wrong? Thanks.

Hi. This is probably a simple question but... When you have a form with a combo box on it that selects records how do you make all of the fields on the form display no data until a record is selected? Thanks. Russie

Hi Ken. I have referenced DAO 3.6. I've changed the code to DAO and I still get the same error. The error happens on the row below: rs.FindFirst "[RiskID] = " & Me.txtRiskID Could it be the data type of Me.txtRiskID that's the problem? txtRiskId is a text field. Regards. Russie

Hi. I'm using the below code to test for the presence of a record in tblControlledRiskAssessment: Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblControlledRiskAssessment") If rs.EOF = True Then MsgBox ("empty") Else rs.FindFirst...

This code isn't rocket science: Private Sub Form_Load() Dim varIndicator 'assign RiskID to risk number field Me.txtRiskID = varRiskNumber varIndicator = DLookup("[RiskIndicator]", "tblInitialRiskAssessment", "[RiskID] = '" & varRiskNumber & "'") Select Case varIndicator...

Hi. I have a form that is referenced by the RiskID ID variable when it boots. Some of the form header information is generated by using DLookup's. I have 2 indicators on my form that I would like to change the background attributes when the form loads. The attribute will depend on a value that...

Thanks for the help. The expression that I required is below. =DLookUp("[DescriptionOfImpact]","tblImpactScoresFinancial","[FinancialImpact] = " & (DLookUp("[FinancialImpact]","tblInitialRiskAssessment","[RiskID] = '" & [Forms]![frmSummaryBudget]![txtRiskID] & "'"))) Russie

Hi. I have three tables. 1. tblSummaryBudget 2. tblInitialRiskAssessment 3. tblImpactScoresFinancial On the summary budget form I have the RiskID field looking up from table 2 (tblInitialRiskAssessment). Is DLookup able to query tblInitialRiskAssessment for a ImpactFinancial value (an...

Hi. I'm developing a risk management program. I have a matrix of possible gradings, on the x axis is 'consequence' ranging from 'Insignificant' to 'Catastrophic' and on the y axis there is likelihood ranging from 'rare' to 'almost certain'. There are 25 boxes in the matrix (5 Likelihood *5...

Excellent Lupins. Thankyou Crowley.

Hi. I have a column in Excel which contains names in the following format: BLOGGS, Joe I would like to be able to split this list of names into two columns i.e. A B BLOGGS Joe Is this possible with the use of some code? Thanks. Russie

Hi. Does anyone know how I can call a sub in formB from formA? formB posts a journal, formA reconciles...I would like to be able to call sub ' reconcile(strReg) ' from formB. A star as usual for any workable answer. Many Thanks. Russie