Recent content by Jolland26

  1. J

    Solved Combo box not selecting record?

    Not to worry!! I've sorted it after really racking my brains! I am using a switchboard when the users access the database and the form was opening in add mode, not edit mode as I wanted. I knew it would be something silly! Thanks everyone for your help in the meantime.
  2. J

    Solved Combo box not selecting record?

    Thanks for your help guys. arnelgp I have already got a mcro behind the combo box from when I added the combo, I've included the screenshot of that. I did try your method but still no dice. What confuses me is I have a similar form in the same database that has the record source of a different...
  3. J

    Solved Combo box not selecting record?

    Hi guys, I have a database that I have secured by using a login form and disabling the ribbons etc when my users are logged in. On one of my forms I have a combo box that simply selects the primary key ID field and updates some text boxes with the information that has been input for that ID...
  4. J

    Button to add time to table

    It will rely on my users being truthful, but for the application that I am using it for it's not a huge problem if they don't press the button. I also do have a code that is logging what users are doing what in the database which they won't be able to see, so I can double check that they have...
  5. J

    Button to add time to table

    Thanks for your help Pat. I don't want to record how much time the user spends in the form itself, especially as they may have to add new information several times over several days. I would just like to know roughly how long between them first starting work on the Engineering Change, to when...
  6. J

    Button to add time to table

    No I'd just like to update each AllocationID with the time it was started and finished. Thanks very much for your help!
  7. J

    Button to add time to table

    I did it myself in a new database quickly with a new table and it worked! I think the reason it doesn't work in my original is because in the table I am using I haven't defined a primary key, but I'm unsure what I should define it as. I have 2 tables related to this one (which is called...
  8. J

    Button to add time to table

    I mean Date and Time. The control is bound to the field, but I want the field to only be updated when the user clicks the button as it's a form that will most likely have to be used more than once so the first time they use it they click the Start Time button and when they have finished using...
  9. J

    Button to add time to table

    I've just tried both deleting the control and adding a new one and creating a whole new form and neither of those things seemed to make any difference. I compile my code each time before saving and there are no errors there, so I'm really at a loss as to why it doesn't want to put the time into...
  10. J

    Button to add time to table

    I tried that first and that didn't do anything either, that's why I tried querying it to update my table but none of it seems to work.
  11. J

    Button to add time to table

    Yes I can, that's why it's so confusing to me that the command button won't update anything.
  12. J

    Button to add time to table

    I understand that, what I'm saying is neither the Update or Insert query put anything into the table and running the code without the query doesn't do anything either.
  13. J

    Button to add time to table

    I have checked and there's nothing going into the table either. I have saved the record already so there is one there, but the button just doesn't seem to add the time to either the textbox on the form or the field in the table.
  14. J

    Button to add time to table

    I've tried doing that, even if I leave the query out of it and just put the Me.txtStartTime = Now() it still doesn't do anything either.
  15. J

    Button to add time to table

    Hi everyone, Been a bit stuck on this for a couple days so thought I'd ask on here. I've added a button to my form for a start time for the form being filled out, and have another for the end time so my users/managers can produce a report about how long their engineering process is taking. I...
Top Bottom