Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oxicottin
  • Order by date
  1. oxicottin

    Update a text box using query

    Thank you for all the help.
  2. oxicottin

    Update a text box using query

    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
  3. oxicottin

    Update a text box using query

    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...
  4. oxicottin

    Update a text box using query

    ...to the table tblEmployeeRequirements. Here is my before update of the combo box. Private Sub cboArea_BeforeUpdate(Cancel As Integer) If DCount("*", "tblEmployeeFunctions", "[FuncID]=" & Me![cboArea] & _ " AND [EmpID]=" & Me.Parent![cboEmployee]) > 0 Then MsgBox "You can not...
  5. oxicottin

    Update a text box using query

    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...
  6. oxicottin

    Update a text box using query

    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...
  7. oxicottin

    Update a text box using query

    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...
  8. oxicottin

    Update a text box using query

    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...
  9. oxicottin

    Update a text box using query

    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...
  10. oxicottin

    Update a text box using query

    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...
  11. oxicottin

    Update a text box using query

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

    Update a text box using query

    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...
  13. oxicottin

    Base foms Record source off combo box selection

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

    Base foms Record source off combo box selection

    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...
  15. oxicottin

    Creating tables and relationships for new database

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

    Creating tables and relationships for new database

    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...
  17. oxicottin

    Broken References when switching back and forth in MS Access 07-16

    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...
  18. oxicottin

    Broken References when switching back and forth in MS Access 07-16

    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 =...
  19. oxicottin

    Broken References when switching back and forth in MS Access 07-16

    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...

Part and Inventory Search

Back
Top