Recent content by TrekBiker

Thank you so much, Duane, these explain everything and will save my client a lot of print paper. I wasn't aware of the difference between Print Preview and Report View even though you'd mentioned it. I'd been looking at your Testing SubReport Height sample database and couldn't replicate...

No, how does that affect it? The samples you put on your other example opened to show the data in two columns so I assumed I could do the same, but no.

Thanks Duane. I also saw your reply to a post elsewhere, showing how to get 2 columns with varying heights of subreport. But I couldn't replicate it, sorry, as there's something I'm missing. A I've attached a mock up of a test database if you have a moment to see where I'm going wrong. Hope...

I want to reduce the size of the product list in this report by spreading the items over 2 columns in the Details section. Page Set-up has an option for 2 columns but this would apply it to the whole report, so the advice is to use a subreport for the Details section and make this 2 columns...

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.