Search results

12 year old thread! :ROFLMAO: Not sure any of the OP's will be paying attention any more!

Is Barcode tied to SequenceNumber? If yes, and it is also stored in the table, then you will need to modify Arnel's suggestion to handle amending that field too. I'm still not sure why you have to store the SequenceNumber - does it make a difference if Sriracha Chili Sauce comes after Sriracha...

Do you have code elsewhere that can change or re-order your sequence numbers? The only way that your original code can give a sequence number of 0 would be if there is a SequenceNumber of -1 in your table. Also, rather than looping the RecordsetClone, it might be easier/quicker to use DMax()...

SELECT Startup.Datum, Startup.ID, Startup.ArbFrei, Haus1_EG.FD1, Haus1_EG.FD2, Haus1_EG.FD3, Haus1_1OG.FD1, Haus1_1OG.FD2, Haus1_1OG.FD3, Haus1_2OG.FD1, Haus1_2OG.FD2, Haus1_2OG.FD3, Haus1_3OG.FD1, Haus1_3OG.FD2, Haus1_3OG.FD3, Haus2_EG.FD1...

Additionally, pay consideration to whether you really want to store the sequence number. If an item is removed (eg mistake) then you will have to go and re-order the numbering of all the other items or you will have gaps. Does the order sequence have any special meaning? If not, you can use a...

You can get it from the parent form then, but easier to add a control using the invoice FK on to the subform. It should populate automatically from the linked master/child fields

Is the ID field of tblLineDetails really a text datatype? Generally, you would need to add to your criteria to find how many records came before the current one. You will also need to include the InvoiceID in your filter. So, it may look like: Dim strCritieria As String strCriteria =...

Did you do a S.M.A.R.T test on your SSD? My guess is that the 'Approaching End of Lifetime' is more a synthetic value assigned by Crucial tied to warranty coverage period, and that your disk is actually fine. I have an SSD that is almost 5 years old but the S.M.A.R.T test doesn't show any...

Which treeview are you using? Does Node.Root return the root node directly? If so even simpler (almost tot the point of not needing a function at all!) Private Function FindRoot(ByVal nodX As Node) As Node Set FindRoot = nodX.Root End Function

The root node won't have a .Parent property, so you get the Error 91. You can handle it in your error handler and Resume Next for that err.Number. But surely you know the root node using the expression to limit your While clause (nodX.Root.Index) Why not bypass the whole While loop: Private...

Since you don't understand the problem, how do you know what is enough to understand it? 😂

It appears they did search for it

How many did you have? Surely you only needed one for each?

I think the consensus is that you should handle your errors

Malformed url. Should be: https://www.isladogs.co.uk/colour-conditions/index.html

Is this directed at me? I'm not sure I follow. Can you demonstrate in the attached example?

As you have noted [Category Type] is superfluous in table tblContact_Categories and ought to be removed. You can also try this query to show all contacts that have categories car and bike: SELECT c.* FROM Contacts c INNER JOIN ( SELECT cc1.ContactID FROM tblContact_Categories cc1...

Even if [Description] is indexed, the index can't be used with this criteria

Not really sure what you're asking! Are you looking to select a single record from the 10000? As long as you have a index on whatever is used as the criteria then select will be as fast as Seek. Seek is used to find a record within an already opened recordset, which could take a long time to...

Changing sort order usually requires 2 passes: 1. Adjust one or more items to SortOrder +/- 1 between item being moved and item where it is moving to. 2. Adjust the sort order of the moved item to its new position Something along the lines of: Function MoveItem(ItemID As Long, CurrentPos As...