Search results

Yes, this is correct. The current system logs all these as different times. I want the first start, the last end and then to discount all starts and ends by the same person on the same job between the first and last ones if that makes sense. And then use that time as the amount of time logged...

Hello forum brains, I am hoping someone might have an idea on a solution here. We have a 3rd party application to for our production people to log their times on jobs. It works, almost, how we want it to. Where it falls down is when people log onto multiple operations at the same time (which is...

For the full background on this I have a time labour calculator for our internal BOMs. Our company timings are done as a decimal of the minute, in 6 second (0.10) or 15 second (0.25) breaks. When I export our BOM into a 3rd party application, their labour is broken into 3 fields, Hours, Minutes...

Thanks all. I have this working perfectly now. I used arnelgps code and it did exactly what I needed. ~Matt

Thank you, works perfect ~Matt

Hi All, Does anyone have a snippet somewhere on how to separate a minute field into each hour, minutes, seconds? IE 75.5 would be 1 hour 15 minutes 30 seconds ~Matt

Update. Quick search and I have changed the Dim for Public, but the below now does not work. Says invalid outside procedure. But when it has Dim, is works. Do I need to add something else? Public strLoggedUser As String strLoggedUser = DLookup("EmployeeID", "tblEmployee"...

Hi Pat I didn't get the chance. I will give it a go though as their bug is still creating the records. Just working on something else at the moment with a tight deadline. ~Matt

Hi all, If I have repeated Dim Strings, can I declare them as public once on a form then just refer back to them anywhere else on the form code? Example as the below code. This is used on a few different command buttons. Dim strLoggedUser As String strLoggedUser =...

I can close this now. Managed to get the 3rd party to login and do the delete for me, so all good. ~Matt

Hi Pat, Sadly this not my table, I can access it to see the issues, but cannot change anything. Basically it adds 3 lines to the audit log for every product each time someone opens any record. This is a bug in the software, nothing that I have done. The 3 lines that get added are not needed at...

I am doing this at the moment, but it is still slow, and with this may records I need to run the query so many times, which is why I was hoping I could get Access to loop it for me. I could then set it on another machine and let it loose for me. ~Matt

Hi ebs17, Please see code below. DELETE dbo_StockRecordAuditLog.StockRecordAuditLogID, dbo_StockRecordAuditLog.StockRecordID, dbo_StockRecordAuditLog.Username, dbo_StockRecordAuditLog.Action, dbo_StockRecordAuditLog.ActionDateTime FROM dbo_StockRecordAuditLog WHERE...

Hi All, I have a query to delete certain records from a link SQL table, but there are a lot (over 300k). Is there any way of creating a query to loop delete 100 records at a time so it doesn't get hung up trying to delete them all in one go? ~Matt

For our use, we have some fields that have similar entries, but with lots of characters. This saves the single finger typists from having to put it all in. They can start and now it does start to filter by what they have typed so far. Before it had nothing so you had to type the entire text in...

Updated to a public function which also seems to work nicely. Public Function funDropdown() On Error GoTo ErrorHandler Screen.ActiveControl.Dropdown ExitSub: Exit Function ErrorHandler: MsgBox Error$ Resume ExitSub End Function

I have had this issue and posted a while back, and have since been using the below code in the Got Focus of the combo box. It is not ideal, but it does then allow the AutoFill to work. (where cboBoxName is your combo box name) Private Sub cboBoxName_GotFocus() Me!cboBoxName.Dropdown...

Yes, I like this idea. I will have a look into this as it may work for me. ~Matt

Hi All, Is there a way of making a form with a fixed position but not allowing any other forms to over/underlap it? I wanted to have a left sided menu for my modules, and when one is selected a custom ribbon is then loaded. I know a fixed position can be done, but wasn't sure if I could then...

Hi CJ, I normally have my listboxes/combo boxes row source as a pre-made query. Would your method be a better option for me to learn? ~Matt