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...
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...
Hello, I'm asked to create a database that will keep track of the progress of how many classifications an employee has done in a functional area for a position. Here is how it goes... There are 7 positions and lets say for OP 1 in the functional areas you learned under F1 some of the...
Do you guys have a easy to use auto updater for if I want to update the database? Right now I have the BE on server in a folder named VWI Backend and I have the FE in a folder named VWI FE and I have a master copy of the FE on my PC. Now lets say I want to update the BE and distribute how can I...
Majp, I couldn't get your example to work for the images, the below worked... Whats the diference?
Public Function GetCurrentPath() As String
'Gets path of current BE table txtVWI, Used all images
'Put images in with BE file
Dim strFullPath As String
strFullPath =...
Ok the split and putting the FE on the PC got rid of the reference issue now I have a different issue. My database uses images from a folder that was always with the database and now that the FE is on the desktops and the BE is separate I don't get images using the function below...
Public...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.