Search results

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

I have indeed. I have a batch file linked to a shortcut, so every time they open the shortcut, it copies the file from a single server location. Makes it easy when I do an update, they just close and reopen to get the latest version. ~Matt

Hi Arne, The auto expand was already set. I have updated the list display but this has not fixed the issue. What boggles me is that it is only that combo, and only that client. Everyone else works off the exact same version FE and the other 14 clients are all fine. Likewise, every other combo...

Dear forumers, I have an issue with a single combo box, on a single machine. This form has 8 combo boxes I use to filter a list box. But I have an issue on a single client machine where 1 box, just 1, no longer works. Image is below. In every other combo box, once you start typing it starts to...

I am yes, but I also have that option for my main ribbon which is loaded without a form, so that always stays as the default. I want the main ribbon to stay, but when a form is open it gets its own ribbon, which becomes selected when the form is loaded. ~Matt

Hi All, I have some very nice custom ribbons and icons on my apps now, but I am now thinking of having form commands on their own custom ribbon too. Now I can get Ribbons to load with the form, but the default ribbon stays selected. Does anyone know how to get it to switch to the form ribbon...

Thanks guys, I shall leave it as it is. It is not a major issue, was just curious as I have seen other databases done this way. ~Matt

Hi all, Would there be any pros/cons to splitting my backend data into data types? At the moment I have a single backend containing all my tables. I was wondering if there would be any benefit in breaking this down into categories, IE Quote Data, Customer Data, Supplier Data, Employee Data and...