Search results for query: *

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.

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

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

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

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

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

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

Sorry to come back again as Duane gave me a perfect solution to my last request. I've tried replicating it with a different starting query that needs results to be ranked, but every time get Rank = 1. The query structure looks very much the same so I'm constantly missing something. This time...

My client creates orders each with multiple items, assembling details in a query like this. Using this to print labels gives just one label for each Order Detail ID. We want instead to print the quantity number of each label, so 8 of Maldon Gold 4 of Oscar Wilde 24 of Captain Bob etc...

Sorry to have to ask this as it's a frequent subject but I'm struggling to add ranking by Total for each Company in each Category in this query. What I want is this, etc Using other posts I've tried this SQL, amongst others, but am not getting what I want. SELECT s1.Category, s1.Company...

I'm wanting to assemble data in several queries into a single form, including three subforms based on crosstab queries if possible, as they give a neat layout. PHV in thread 702-1347583 gave a way of doing this using modifications to the crosstabs like this, but I didn't understand. He said...

Is there a way around the maximum field size of 255 characters in Access 365. The old Memo field allowed this.

I have a form containing a subform sfmDebtorsList with information about customers who have elected to receive Statements by email. A command button on the main form initiates creating the email and saving the attachment. The process works fine when customers have company names like Smith Ltd...

This is the source query for what I'd like to be a new subform where a main form that provides Category and Company as link fields. I'd ideally like to display the subform data something like this. How best to get near to achieving this?

This is a reporting form for comments and scores at an event. The bottom subforms get their criteria from the ones above, and the left hand set works properly, showing the scores for each Judge when stepping through all 9 of them, 3 judges for each of 3 companies in this Category. The top...

I'm wanting to extract records in the Comments Written table below that don't have matching WrittenID in the query qryWrittenWithMatchingPresentation. This Select statement produces no results SELECT [Comments Written].EntryID, [Comments Written].Judge, [Comments Written].Category, [Comments...

I want to sort this query first by the Category column then by descending Overall scores. It needs more than just sorting each column. Any guidance will be much appreciated.

My client wants to be able to use his database when working on site, so any data added there is also accessible to people in the office. I wondered if OneDrive could do this but it seems not. I see there's a WebApp option but have never come across it in use. Is this a possibility and what...

I'm very near a solution for formatting a range of cells in a worksheet created from Access This colours alternate rows but does the entire rows, not just the parts in the specified range. Dim LR As Long, i As Long 'Find the last filled row in column A LR = Range("A" &...