Search results

Thanks Doc, You have explained it very well and you are right. I need to find a way of taking the start date and then adding all minutes needed for the activity, including any breaks, out of hours times, public holidays and such. For now, if I can get a way of just taking the start time and...

That does make sense. I feel your pain of people and entering of data. I have had to write more code than I would care to make simple entry foolproof. And I still get amazed some days on what people have done.

Hi Larry, Thank you for the db. I have had a quick look and wonder why you have separate fields for the date and time? If you have these in a single field, you can just use the DateDiff to get the answer your formula shows. DateDiff: DateDiff("n",[ActivityStartDate],[ActivityEndDate])/60 This...

Hi plog, At the moment I am as basic as below for the employee side. EmployeeID, EmployeeName WorkingHoursID, EmployeeID, MondayStart, MondayEnd (and remaining weekdays) TeaBreakID, EmployeeID, MondayTeaStart, MondayTeaEnd (and remaining weekdays) LunchBreakID, EmployeeID, MondayLunchStart...

Apologies, I got over excited. The tea break should have been 10 minutes.

Skiving time 😆 they have more of that than anything.... ~Matt

Hi plog, I have tried this, but I need to add the time only during the working hours. If I add 600 minutes to 07:30 I would get 17:30, not 09:40 the next day when you take out the breaks and out of working hours.... ~Matt

Hi all, I am trying to get my head around the possibility of something, and hoping someone somewhere may already have this in the dust and cobwebs. I want to be able to work out the end date/time of an activity based on start date/time, worked out based on working hours. Example we have John...

Why not have the data entry part on a different form? Click add new data button and open a popup form to enter the new data, leaving the continuous form exactly where you have it. Once you close the data entry popup, the data would be at the bottom as normal, but your continuous form would...

If you do this, can I please have a copy when you are finished, purely for research purposes. And that would not be my name appearing on your statements....

Hi all, Has anyone ever been asked if it is possible to have a way of shutting all open databases down after a period of inactivity? ~Matt

Thanks MajP, This works fine. I shall use the Dim strFileCriteria As String method too. ~Matt

Hi all, I thought I had this fixed, but I was wrong. I have the below code giving me an error. If DCount("*", "tblFileRegisterDetail", ("FileRegisterTypeID = " & FileRegisterTypeID And "FileRegisterDetailNumber = '" & FileRegisterDetailNumber & "'")) > 0 Then FileRegisterTypeID is Numerical...

Thanks CJ, I did think of this, but on some of them I need to change the font colour to white, so it is not just the background of the text boxes. I will have a look into it though and see if I can always leave the text in 1 colour. The current record is highlighted black with white text, and...

Hi all, Is there a quick way of creating a conditional formatting style method but with the options added/selected in a table. We have 4 production cells, and each are assigned a colour. At the moment I have created conditional formatting rules to change the colour on my continuous form. What...

Solved. Just used & vbcrlf & and it worked. I had tried that, but must have typed it incorrectly. Dim strControlTipText As String strControlTipText = "Selected Record" & vbCrLf & _ "Customer: " & [Customer] & vbCrLf & _...

Hi all, Is there any way of adding line breaks into a control tip text? I have a lovely new continuous form setup that I have built using tips from here. I have go the ControlTipText to change to display the selected record, which is great. But ideally I want to display it on different lines...

Hi Pat, I don't want to delete them as such. I have turned off cascading deletes, but what I did want was a list of the BOMs that would be affected if I did want to delete them. I try to avoid any deletions at all, but I have been requested by the powers above me to allow deletion of products...

Thanks All, I thought this may have been the case so already started on the form, just in case. I shall close this down. ~Matt

Hi all, Is there a ready made code for letting you know which cascading records would be deleted if you delete from a one-to-many table? Let's say I have a Product that is used on lots of BOMs. If I try to delete that record, I would like it list the BOMs this product appears on. I did have a...