Search results

Hi all, I have the below table and I want to work out how many hours worked in a day based on the earliest start time and latest end time a person has logged on. In the data below we can see that Employee One logged on to 4 jobs around the same time, starting at 07:19:50 and ending these at...

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

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

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

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

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

Hi forum people, I have an idea someone has asked about at work, and wondered if anyone would have any tips or if it would even be possible. We use a type of cable that comes in straight 2m lengths. Sadly it is not always cut into multiples of 2m so we get a lot of waste. What has been asked...

Hi all, I have been looking and trying and cannot find the right syntax to open a form and apply a filter to the subform. Main form is frmProductionManagement, subform is sfrmProductionManagement is in Continuous Form view. If I set the filter in the subform in design mode to [Outstanding] >...

Hi all, I have looked but cannot find a method for this. I want to delete all files and folders from a main folder, apart from anything *.zip. I can find code to delete everything, or all of a certain file type, but nothing to only leave a certain file type. ~Matt

Hi All, I have generated a query that filters from options of a form. When I open the form, the list box posts the below error. But if I open the query itself, it shows the data and no error. Just won't display it in the list box. I have 3 check boxes for the dates Created Date, Sent Date...

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

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

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

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

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 all, I have always used a method of creating an insert query and then calling this with VBA when I need to add data to a table. DoCmd.SetWarnings False DoCmd.OpenQuery "qryInsertReturnAction", acViewNormal, acEdit DoCmd.SetWarnings True Is there any benefit to changing this to have the SQL...

Hi All, I have just finished a form the allows me to open saved pdf files and it works great. Is there simple code to direct print these to a specific printer? I have looked but lost the link that I found that I thought would do it and cannot find it anymore. ~Matt

Hi All, I have what should be a simple query, but I cannot get it to work right. I have a table with a DrawingRevisionID (PK, AutoNumber) and DrawingRevisionDate. I want to be able to only show the latest date, but also need to show the PK which may not be the latest number. As an example I...

Hi all, I have the below code to select a file and save the location to a table. Dim f As Object Dim strDocumentFileName As String Dim varItem As Variant Set f = Application.FileDialog(3) f.AllowMultiSelect = False If f.Show Then For Each varItem In...