Search results

  1. vegemite

    Updating another table from a form

    Thanks brains trust you guys are awesome! Sorry this is a side project so I do have large chunks of time off and then get back to it in bursts (which is a real limitation to learning) I am just coming back now. I will stop the limit to list and add a maintenance section instead. I do like that...
  2. vegemite

    Updating another table from a form

    Totally agree on second prompt thanks! Does the update just go in that code?
  3. vegemite

    Updating another table from a form

    This is similar to something I did beforehand but for a subconsultant (obviously, there is an else and endif etc.) In Directory there is a yes/no field SubConsultant - I just didnt know where to add that in the code below Yes person field is bound (it populates firstname and surname in the...
  4. vegemite

    Updating another table from a form

    I have a field in my form that will update a directory table if the name of the person is not already in the directory. How can I then update another field relevant to that person in the directory. So if I am adding Joe Bloggs but I also want to update a yes/no field that Joe Bloggs is a...
  5. vegemite

    Not in list error - 2455 run-time

    @June7 can I set the value with OpenArgs in my acFormAdd line? I did try but its not happy. I added a checkbox to the form directory DoCmd.OpenForm "frmDirectory", acNormal, , , acFormAdd, acDialog, CmbSubconsultant & Chr(165) & NewData, True Set Me.ChkSubbie = True
  6. vegemite

    Not in list error - 2455 run-time

    Aha. Its in the table as a yes/no field. I will add to the form.
  7. vegemite

    Not in list error - 2455 run-time

    Thanks @June7 I'll keep at it & tidy up at the same time :-)
  8. vegemite

    Not in list error - 2455 run-time

    So in my case Private Sub CmbSubconsultant_NotInList(NewData As String, Response As Integer) Response = acDataErrContinue 'Enable the user to choose if they want to add a new consultant If MsgBox("Consultant Name is not on list, would you like to add it?", vbYesNo + vbQuestion...
  9. vegemite

    Not in list error - 2455 run-time

    Thanks @June7 Attached. Form is JobManagement. Subconsultant is the subform
  10. vegemite

    Not in list error - 2455 run-time

    The form where the consultant is being entered into is a job form. The consultant's name is added to the directory if its not there (its supposed to). It works in the first instance that @arnelgp provided above (the code is in the job form,not the directory). The only diff with this is that the...
  11. vegemite

    Not in list error - 2455 run-time

    Rather than the subform?
  12. vegemite

    Not in list error - 2455 run-time

    Thanks so much for your help with the last one. Would there be a difference if I am using a subform for the same process? This is for a consultant working on the job - the new record would go to the same place (the directory). Ideally I update the record by getting it to record "yes" or 1 to tag...
  13. vegemite

    Not in list error - 2455 run-time

    Awesome thank you!!!
  14. vegemite

    Not in list error - 2455 run-time

    That worked but it popped up the "item not on the list again" then when I say no its in the spot I want it? Private Sub txtClientName_NotInList(NewData As String, Response As Integer) 'Enable the user to choose if they want to add a new client If MsgBox("Client Name is not on list...
  15. vegemite

    Not in list error - 2455 run-time

    I think I did try adding it where the endif is now & putting the endif at the end. Will try again. thanks,
  16. vegemite

    Not in list error - 2455 run-time

    Hi guys, I am grabbing some old code and I can see it working in the database I have grabbed it from but having issues with this instance. Once I enter the value, it prompts not in list as expected, I can add it then it loops back to not on list again. If I select no I don't want to add it I...
  17. vegemite

    Generating a project number based on other fields

    Clearly I am not as brilliant as you Plog. I did look at the example and still didn't understand. Thick but not rude.
  18. vegemite

    Generating a project number based on other fields

    Im also not sure what you mean about the variable sorry for being thick.
  19. vegemite

    Generating a project number based on other fields

    I need the financial year of the last job to determine if the numbering starts again. The job numbers are statenumber_financialyear. So if the last job was QLD2_2019 and its still 2019 the next job would be QLD3_2019 but if its now 2020 the job would be QLD1_2020
  20. vegemite

    Generating a project number based on other fields

    I wonder if I need to create a recordset or a group (of the current financial year) to run the Dmax on
Top Bottom