Search results

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

Hi Dave, In the case the cable is around £10.46/m. So with 250m of off cuts and waste, it is definitely worth the investment into a proper system to manage them. ~Matt

Hi All, Thank you for taking an interest in this task. I did want to have a real time list of data for today, but sadly the guy tasked with the stock list decided to be ill today. In the meantime, I have found the below link, which seems to do something like the endgame here...

Hi Gasman, No, the fault here is not the supplier. It is our workers. The cable was all received in 2m lengths. But they always just grab a new length when doing a job, rather than find the most efficient lengths. You have no idea how frustrating this is, so I am trying to find a solution to...

Thanks MajP, I will get a list and PM it over. There is nothing hidden here so I will give you real lengths and cable details, and then same sample lengths we would cut it in to. ~Matt

Hi Majp, Yes, I did make this one easy, and it will not always be this way. What we are going to put in process as that the BOM will always have the required quantity in a multiple of 0.100, so there will never be any weird 0.056 lengths like we currently have. 0.056 will be rounded up to 0.100...

As an example, and this one will be basic just for an idea we have the below. CableSerial CableLength 001 0.330 002 0.660 003 0.660 004 0.800 005 0.850 006 1.650 007 2.000 Now we need to cut 10 x 0.165 lengths. Basic math would tell us that 10 x 0.165 = 1.650. So on here...

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

I actually just solved this myself thanks to an old post from IslaDogs. I used the below. DoCmd.OpenForm "frmProductionManagement" [Forms]![frmProductionManagement]![sfrmProductionManagement].Form.Filter = "[Outstanding] > 0"...

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

There are files in the folder and subfolder. The code I have now works fine which is good. I create the zip in a temp folder. Clear the main folder then move the zip to the main folder from the temp one. It's not elegant, but works for the basic needs we have. Thank you for your help, your code...

Hi Gasman, That code only deleted files and not folders. Now create the zip file in a temp location, empty the source folder then move the zip file back. I had to put a 2 second pause after the zip file is created otherwise it deleted the files before it was finished. I used the code on the...