Search results for query: *

I'd like to revert to the layout style before the update to Windows version 22H2, which did this to forms. Outlook has similar dark appearance.

Sorry for late response, the notifications come a separate email address that I've only just checked. At first I lived with it, because holding down the Off button for tens of seconds forced shut down. Then it started as normal next time. Now I'm not getting repetitions and see there was...

It says 'Go to sleep'. On powering off it says 'Your device ran into a problem and needs to restart. We're just collecting some error info and we'll restart for you'. It doesn't restart, and I have to hold down the power button for approx 20 seconds for it to turn off fully. Then it will restart...

Experiencing problem that my Windows 11 laptop doesn't shut down fully, or go into sleep mode. This didn't happen until the 3 March update to Windows version 23H2. Many threads describe this but none of the suggested fixes work for me and I have to hold the On/OFF button down for tens of seconds...

Glad it's not just me! Hope you're recovery is proceeding well.

Thanks Duane. I didn't have success using Me.Assigned.Requery but as you say, reassigning the row source appears to be very reliable. The whole area of Requery, Refresh, Recordset.Requery etc is a bit of a mystery to me.

No takers on this one but found a work around for the List Boxes not updating. Instead of Me.AssignedForeign.Recordset.Requery I used Me.AssignedOwn.RowSource = "qryListBoxOwn". Left wondering why this worked when others didn't.

This form has details of beer orders, in this example Order ID 1725127, which has separate record pages for the three beers in the order. The one shown is for Aspall Cyder, for which 3 were required, each needing to be assigned to a separate cask. The Book Out button for this 'Foreign'...

Thanks Duane, and your comments on the tables are absolutely correct. Unfortunately they were created before I became involved and are full of bad practices. I'd like to rebuild the tables but there's a whole separate system for barcode readers feeding into the table fields as they are, and I...

Form ‘For Booking Out’ uses order details that need to be inserted into three separate tables for a new Cask. A Cask ID is entered then ‘Update Own Cask Tables’ puts fields into the appropriate tables, eg Casks Racked/Sold needs Date Sold and Order Detail ID from the first form. If wanting to...

Thanks, there can be 10s of IDs so I'll allow typing and just check what's entered is in the list. Delighted with the full process, which will save the company a lot of manual updating.

The manual process starts by picking a cask with the required beer from all that are in stock. The cask will have a numeric CaskID that they make a note of and either type into the new Book Out form or use the drop-down list to scroll through the candidates in stock, picking the one they want...

Andy & Duane, thanks again for your suggestions, which I've implemented. When the barcode readers don't work they can now take a cask from stock for the required beer. The cask label shows the CaskID and what beer is inside. They enter the CaskID, with the combo checking this is already...

Thanks so much for responses, which make a lot of sense. It's getting to a time here where I'll be unpopular if continuing to work so will resume tomorrow, incorporating your advice. More when I've progressed.

This is a follow up to a previous question, again exposing my lack of knowledge. The first part below to update a table worked properly, thanks for that. Dim NewCaskID As Long NewCaskID = InputBox("Enter Cask Number") strSQL = "UPDATE [Casks Racked/Sold] SET OrderDetailID = " &...

Thanks Andy and Combo, useful for my syntax learning process.

Thanks Strongm, that nearly got me there, just asked for missing parameter " But this worked SQL = "UPDATE [Casks Racked/Sold] SET [OrderDetailID]=forms!frmBookOut.[OrderDetailID] WHERE [CaskID]= " & NewCaskID & "" Excellent. Have a virtual pint of best Essex beer!

My brewery client normally uses barcode readers to feed data into the main database when processing orders. Sometimes the readers fail and they need some manual processes. One of these is to update a table 'Casks Racked/Sold' that had been part completed previously with details of casks in...

Thanks Duane, spot on. They say there's a fix on the way, so no need to do antything meantime. Hope your recovery is progressing well, and you're back on the bike.

A client has reported that font names throughout their database have recently been automatically changed, same for all users' copies. The change is from Calibri 10 to MS Sans Serif 10, for most but not for all controls on the forms. There's some dialogue on the web about an Office 365 upgrade...