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