Search results

Good day Folks, I have written code in the On Current event of my form as follows: Dim CurrentDate As Date Dim NextReviewDate As Date Dim NewReviewDate As Date CurrentDate = Me!txtCurrentDate.Value NextReviewDate = DateAdd("yyyy", 1, Me!txtCurrentDate.Value) NewReviewDate =...

Good day, I have a form name Internal Audits (frmInternalAudits) that I have created to track when SOP's (Standard Operating Procedure) are due to be audited. I have the following fields: txtAuditSubject (Short text field) txtCurrentDate (Date field [ddmmyyyy]) txtNextReviewDate (Date field...

Okay folks, thanks for your responses, perhaps my attempt at pinching some code from an older project isn't the correct way to go, so what I am trying to achieve is when I click the button on my frmFrontEnd form say for example the button the opens the frmEmployees form, I want the frmFrontEnd...

Apologies I forgot to put the error message, When the button is click the on click event highlights the following bit of code: Exit_cmdopenFrontEnd_Click and a pop up dialog box with the following message appears: Dialogue box Title: Microsoft Visual Basic for Applications a yellow...

I have the following forms : frmFrontEnd frmEmployees frmInternalAudits frmSOPs In the on click event I want to: for example on clicking the button on my frmFrontEnd form to open my frmEmployees form, that on the frmEmployees form opening the frmFrontEnd form closes. I tried this but it kept...