Search results

Hi Minty, I mean saving a design change. I shall update the main post. ~Matt

Hi All, I have a database that works fine. Apart from 1 form which now takes over an hour to save. Every other form is fine. Instant saves. But this one just locks all office apps on my PC while it saves. I have recreated the form from scratch, and it stays the same. There is a near identical...

It's not, no. But it is easy enough to understand and edit. I have managed to modify it and add my own parts without anything breaking, so far.... ~Matt

I used this guy, and edited the layout for our use. http://testolek.xaa.pl/portfolio2/index.php It cost €100 for the full code, but was well worth it. ~Matt

Hi all, The 3 tables I am using are from an external source, CIM50. I cannot change the field types at all. Please see below dbo.WorksOrderOperation Column Name Data Type Allow Nulls WorksOrderOperationID bigint False dbo.WorksOrderOperationBooking Column Name Data Type Allow Nulls...

Can you shed any light on why this will not work without the Like in front? The SQL fields are both the same data type and this is the only query that does not work without the Like. But it was working this morning. I changed nothing, but it just stopped working..... ~Matt

SELECT dbo_WorksOrderOperationBooking.EnteredBy AS Employee, dbo_WorksOrderOperationBooking.StartTime AS Start, dbo_WorksOrderOperationBooking.FinishTime AS [End], dbo_WorksOrderOperationBooking.QtyCompleted AS Quantity FROM dbo_WorksOrderOperationBooking GROUP BY...

It never has for me before. But somehow this is the only way I can get this criteria to work. ~Matt

Update: If I change it to Like [Forms]![frmBarcodeProductionManagement]![txtBarcodeWorksOrderOperationFilter], it works..... ~Matt

My issue here is, that it was working. But now it is just not. I am just trying to filter a based on an ID number. There is nothing complex about it, despite what access is telling me. Below is the full SQL of the query. SELECT dbo_WorksOrderOperationBooking.WorksOrderOperationID...

Hi all, I am getting an error message on a query when I try to filter on a ListBox. Criteria is as below. [Forms]![frmBarcodeProductionManagement]![lstBarcodeWorksOrderOperationList] Bound Column is 1 and the field is from an SQL table, WorksOrderOperationID and the field I am trying to...

Thank you Gina, It works perfectly, and the code was easy to read and learn. Thank you for your help. ~Matt

Thanks Gina, And the download is exactly what I was after, so just need to integrate it into my form now. ~Matt

I tried that but it didn't work. But now it does. Possibly my browser playing up.... ~Matt

This looks perfect, but the download link does not work :( ~Matt

Hi all, Just to rekindle this, I wondered if it was related to references, so I took the accdb version to the affected machine to check. The curve ball here is, the accdb version works fine. When I convert to accde, it stops working. All used references are fine. Everything else works as it...

Hi all, Does anyone have a sample code of Up and Down buttons to change the sequence of a list? I have a table with a field [Sequence] which I will use to sort the order. It does not allow duplicates. What I am after is a code for buttons so when an item is highlighted, if I click Up, it...

Hi All, Is it possible to use conditional formatting on a continuous form, but get the colour from a table? Lets say I have a status table like below. StatusID StatusName StatusColourRGB 1 Enquiry 51, 255, 255 2 Open 246, 255, 51 3 Ordered 51, 255, 51 4 Closed 255, 162, 51 Is it...

I tried this. I actually deleted and rebuilt all combos, but this one still fails. Only this one, the others all work fine. Really weird this. It was working before. And this FE never gets changed really. Everything has always worked. The version people were using was October 2020. ~Matt

I will give that a go. Weird that it is only that combo and only that machine though. As I said, the list part itself works, it just won't work if you type in it. ~Matt