Search results

Hi All, Is there any way I can get a query to create a sequence number based on the first column, but start again when the data in the first column changes? I have a query that has 511 rows. Column1 is BomReference and this has a total of 30 different BomRefences. What I am after is the query...

Just to throw more brown smelly spanners into working fans please see below for more information. If I take a copy of the form and save it "Copy of frmBarcodeProductionManagement" and edit this form I do not get the save issue. If I then rename the corrupted form to...

I am still stuck in the save mode, and I finish at 1pm, so I am going to revisit this on Monday. I am going to take a backup of the form, then delete all controls. If the save speeds up, I will add them back, 1 by 1, to see which one has ruined my Friday. In all my time using Access, this is...

Hi Gasman, That is what I did to create the new form, which is why the codes are all the same. The only difference between the 2 would be the source query to the main listbox used on both. If I use the old version of the form and use the new query source, it still saves fast. It has really...

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