Recent content by oxicottin

Thank you for all the help.

Duane, Here is an updated version of were I'm at so far. Thanks, SoggyCashew.....https://files.engineering.com/getfile.aspx?folder=b9fc5666-d456-4353-bfd1-88a8c5a97c37&file=OperatorRate_V8-27-18.zip

I'm not sure what you mean "You shouldn't allow writing over an existing function area." What I'm thinking your saying is I should suggest the user to delete the record if they want to change Functional Areas, which is what I want to do. The issue is in my Before Update I tell them there is...

Duane that works perfectly! Two Questions, in the frmEmployeeFunctionsSubform there is a "Date Completed" text box. How can I automatically have it enter todays date when txtFunctionalAreaAchieved text box reaches lets say 6 of 6 or whatever requirement. Second, When I mack a selection change...

Duane, I fixed the locked and disabled text box. I figured out a work around on how to being only able to select one function Area and it not show up in the selection drop down again. I cant figure out for the life of me how to get it to say or even have a check next to...

Duane, I forgot to mention in my last post when I removed Requirements text from being saved and saved the FuncReqID instead, how do I get the text to show in the requirements text box now? Also, what the SQL for? I tried to put in a query and look at it in Design View but I get errors. By...

Duane, attached is the current version DB. I updated the table name to tblEmployeeRequirements I'm now storing the FuncReqID value in tblEmployeeRequirements instead of all that Requirements text. Removed requirements from the tblEmployeeRequirements table since im not storing the text...

Ok figured out the error, Its because I got rid of the field Requirements in the table tblRequirements/tblEmployeeRequirements and am now saving the FuncReqID value instead. How do I display the Requirements now in the frmRequirementsSubform? Its record source was the tblEmployeeRequirements...

Ok Im a weekend warrior and only do this for work projects to make my life easier so please bare with me. Ok, so I changed the table name and deleted Requirements and added FuncReqID field to the new named table tblEmployeeRequirements then I went into frmEmployeeFunctionsSubform and the cboArea...

Andrzejek, I'm not looking for anything to do with a required field, what I want to do is in my subform (frmEmployeeFunctionsSubform) there is a unbound textbox named (txtFunctionalAreaAchieved)and I just want to display whether the requirements associated with the Functional Area are completed...

Duane, can you give me an example? Thanks! Thanks, SoggyCashew.....

hello, Im trying to setup this DB but am having such a hard time. I have a subform (frmEmployeeFunctionsSubform) and next to each combo box (cboArea) I want to have a text box that says if the employee completed all the requirements for the functional area it will show "completed" and if not...

I figured it out thanks.... Private Sub cboFunction_AfterUpdate() Dim mySQL As String mySQL = "SELECT tblFunctionRequirements.FuncID, tblFunctionRequirements.Requirements " & vbCrLf & _ "FROM tblFunctionRequirements " & vbCrLf & _ "WHERE...

Hello, I wanted to have my forms Record source based off a selection from my combo box (cboFunction). I can create a query and open the form and make the selection in the combo box and the correct data comes up but I don't know how to execute it in VBA on my form? Below is the querys SQL... What...

https://files.engineering.com/getfile.aspx?folder=4770ba36-abf7-4889-93cc-1523e992aef9&file=Flow.pdf