Search results

Haha, I was missing something with the code - it was as simple as that! Thanks for your help all the same :)

Hi everyone, I have been using Allen Browne's Inventory Control code for quite some time now and it has been working perfectly. However, there is now a requirement for one of the stocked product's quantity on hand to be displayed as a decimal number. I have changed the data types of the table...

Thanks! And is it possible to have multiple subforms of crosstab queries on this form controlled by the command button? All the subforms would display similar results but with slight changes to the query where condition.

Perfect, thank you for your assistance :) Just a couple of questions regarding this setup: Is it possible to add a Sum totals for each column on the crosstab? Is it possible to add multiple subforms which are controlled by the one command button on the form?

02/11/2021

I've got the where condition working as below but I am still unable to figure out where the date formatting goes in the function, I either get an error or no formatting at all. @arnelgp can you point me in the right direction? "TRANSFORM Max(Customer_Orders_Items.Order_Quantity) " & _ "SELECT...

Ok, I tried to add the format to this part of the code "PIVOT Shipments.Despatch_Date IN (<exp>);" _ but I wasn't able to get it to work and get a compile error. Whereabouts on the function does the format go? I also tried to add the where condition to the 'cons_query' section of the form...

Amazing, thanks so much for this. I have almost got it working with my database but as my table structure is more complex than your sample I need to make some changes to the code. Below is what I currently have for my version of the code for 'cons_query'. "TRANSFORM...

The date columns shouldn't need go above 150 so 255 limit won't be a problem. Would you be able to provide some more detail about the For...Next Loop (as I have never used one before). The smallest date will be the current (today's) date. Also, where do I reference to the function for it to...

Hi all, I am trying to make a crosstab query with a date range as the column heading. My 'Shipments' table contains a field called 'Despatch_Date' and I would like the crosstab query to use this data as the column heading starting from today's date through to the maximum date in the data...

I found a solution here: https://stackoverflow.com/questions/35631335/changing-printer-in-vba-for-access-also-change-page-layout Carton label code works perfectly for what I need, pallet label code doesn't need to change. Private Sub Command2_Click() Dim DefaultPrinter As String Dim...

Thanks arnelgp, Where do I add this part of the code into your suggestion? prtr.TopMargin = 0.5 prtr.BottomMargin = 0.5 prtr.LeftMargin = 0.5 prtr.RightMargin = 0.5 prtr.PaperSize = acPRPSUser prtr.Orientation = acPRORLandscape

Hello! I'm hoping for some advice and guidance but first a little bit of background on my set up: The office has two PCs and two printers, the default printer is called "+25" and the other printer is "Zebra Printer". However the Zebra printer is also called "\\4H1Z742\Zebra Printer" because...

That looks to have done it! It will be thoroughly tested over the coming weeks but I think it is working perfectly. That has made my day, thank you so much for your help :)

Thanks so much, it is so close to working! The problem I can see is when there are multiple order shipment numbers for the order. I have added 16172B to the data and I'm getting the results as shown in the example database attached. It's working perfectly when there is just 1 shipment number...

It's not to make 3 labels per page but to make 3 items per label. This was working using the code you first created but it didn't respond when I tried to change the master/child links on the report to split the items based on the Pallet_Number field. I have attached a file showing two versions...

When I run the new report you made it is splitting the items across two pallet labels correctly but the code doesn't seem to be adding the blank spaces to create the fixed label height. As there is one item per label in this example there should be two blank spaces added for each label. Was this...

It is much appreciated that you have taken your time to look at this but I should have been a bit clearer with what the results of the report should be for this example. There are two pallets for this shipment; Ordered_Item_ID 66 is on pallet 1 and Ordered_Item_ID 67 is on pallet 2. Therefore...

I have attached the sample database. The shipment number to use is 16172A. I have left the reports set up so they are linked using the Order_Shipment_Number but it does look like they need to be linked using Pallet_Number to get my desired result. Something else which I was unable to get...

Hi @arnelgp, I have found that the problem I have above is resolved when I make the main report and subreport link by Pallet_Number (this field is called 'pallet' in your example). However, when I change this your code doesn't seem to do anything unless I link the reports by...