Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TrekBiker

    Use 2 columns in Detail Section of report

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

    Use 2 columns in Detail Section of report

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

    Use 2 columns in Detail Section of report

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

    Use 2 columns in Detail Section of report

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

    Style change after Windows Update

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

    Version 23H2 preventing full shut down

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

    Version 23H2 preventing full shut down

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

    Version 23H2 preventing full shut down

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

    Form Data Not Updating

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

    Form Data Not Updating

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

    Form Data Not Updating

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

    Form Data Not Updating

    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'...
  13. TrekBiker

    Forcing Form Updates

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

    Forcing Form Updates

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

    Running query with parameter from Inputbox

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

    Running query with parameter from Inputbox

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

    Running query with parameter from Inputbox

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

    Running query with parameter from Inputbox

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

    Running query with parameter from Inputbox

    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 = " &...
  20. TrekBiker

    My brewery client normally uses b

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

Part and Inventory Search

Back
Top