Search results

Hi arnelgp; It was a typo, should have been like attached screenshot. I want the indicator to be between the start and finish date of the financial table. Regards Tor Fey

Hi arnelgp; The table: tbl_financial_year has 3 records in it currently: Year_financial fin_year_start fin_year_end 17/18 01/04/2017 31/03/2017 18/19 01/04/2017 31/03/2017 19/20 01/04/2017 31/03/2017 But would be added to after the period 19/20 Kind Regards Tor Fey

Hi CJ_London; I have sorted it my self, went another way around it: fyear...

Hi CJ_London; Thank you for your reply, currently my query has only the following code for each quarter: Quarter1: IIf(DatePart("q",[tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=1 And Year([tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=2017,1,Null) How ever, i...

Good Morning All; I have some criteria in my query which shows a calendar year as follows: Quarter1: IIf(DatePart("q",[tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=1 And Year([tbl_tf_ben_interview]![TF_Ben_Date_Interview_under_Caution])=2017,1,Null) But what I need to do is...

Good Morning; I’m looking for help with text validation, what I need to do is ensure a field meets certain criteria before the user can continue. The Filed needs to start with two letters and end in one of three letters, so for example: MA12345678A The end letter will only ever be the fixed...

Hi Minty; This is now working as you suggested; thank you, but...... it is showing data for quarter1, quarter3 and quarter4; but in actual fact I just need it to show data for the quarters that fall within the specific date ranges. Is there a way to stop this? Kind Regards Tor Fey

Morning All; I have attempted to write the query as per attached screenshot, but it doesn't display any data. Regards Tor Fey:banghead:

Good Morning plog; Is there no way to write it as an expression in the query? For example: quarter1: between ([date] "01/04/2017") & ([date] "30/06/2017") Kind Regards Tor Fey

Good Afternoon All; Is it possible to run a query on a date field with different criteria in one query? I have a date filed in my main table which needs to work on the following date criteria in a report: 01/04/2017 to 30/06/2017 - Quarter 1 01/07/2017 to 30/09/2017 - Quarter 2 01/10/2017...

Afternoon all; Thanks for all your help on this, I think it is finally sorted. Kind Regards Tor Fey

Hi Ridders; I have found the issue with my code, this bit of my code isn't working and causing the issue: If Me.RiskGrand <= 154 Then If MsgBox("You are about to finalise this record as a Low Risk. You will be unable to edit it" & vbCrLf & vbCrLf & "Do you want to continue?", vbQuestion...

Hi Ridders; Think I spoke to soon, still getting the error :( Regards Tor Fey

Hi ridders; Thanks for the pointers, seems to have cracked my issue. Kind Regards Tor Fey

Hi kevlray Where do the End ifs go in that code then? I'm not very great with VBA and has always been a struggle. Regards Tor Fey

Good Afternoon all; I am getting an a Compile Error: 'Block If Without End If' in the below code :banghead:: Private Sub Processbutton_Click() If Me.RiskGrand = 0 Then MsgBox "The Case has not been risk tested yet", vbExclamation, "RISK ASSESSMENT REQUIRED" Exit Sub End If If Me.RiskGrand <=...

Good Morning All; I have a form called: frm_tf_ben_change_risk bound to a table called: tbl_TF_Ben_RiskScore. On the form I have created a button which I want to use to update a field from my form field: TF_Ben_Risk_Points to a field in another table called: TBL_TF_Ben_Main, to a field called...

Hi Minty; That's excellent, the issue has been resolved; thanks so much for your help :) Kind Regards Tor Fey

Hi Minty; With or Without the code: Cancel =True the code errors as follows: 'Compile Error: Block if without End If' Kind Regards Tor Fey

Good Morning All; Is it possible to have a YES/NO msgbox display if a field on a form is equal to a certain value? On my form; I have a close button with the following code that works fine: DoCmd.Close acForm, "frm_TF_Ben_Main" Forms!frm_tf_menu!mycaseis.RequeryWhat I would like to...