Search results

Thanks very much for your assistance, I shall attempt to implement this into my database set up :)

Amazing, thanks so much. I'm just wondering, can the below part of the code be ordered by Pallet_Number? Set rs2 = db.OpenRecordset("select pallet_number, label_number from table1 " & _ "where ((order_shipment_number) = '" & ![order_shipment_number] & "') and...

Thanks, that's an amazing start! The trouble I can see is the 'PalletCount' field doesn't exist in my database's Pallets table. This was only a helper column for the excel formula to work. Therefore, I would need to add this field to the Pallets table and your code would also need to build that...

I feel like there is starting data and expected final output, unless I am misunderstanding you. The column headers highlighted in blue are starting data and the green column is the expected final output.

Yes, each shipment has its own set of label numbers and pallet numbers starting from 1

It says xlsx files aren't supported so I'll have to paste it instead: Pallet_ID Order_Shipment_Number Ordered_Item_ID Pallet_Number PalletCount Label_Number Pallet_Item_Quantity 0 0 0 1 10001A 100 1 1 1 10 2 10001A 101 1 2 1 10 3 10001A 102 1 3 1 10 4 10001A 105 1 4 2 1 5 10001A...

Hi everyone, I'm hoping for some assistance in automating label numbers for pallets. I currently have a manually entered Pallet_Number field that stores the pallet number for each item on a shipment and groups the items together so they can be printed on individual pallet labels. However, each...

Thanks for the suggestion, I've tried to implement the code and I'm getting a Compile error for .Controls in lngQtyLast = Nz(.Controls("Zone" & vZone & "_Quantity"), 0). Any thoughts?

Thanks! That removed the error and I got the code working using the following: If strZone = "None" Then lngQtyLast = Nz(!Product_Quantity, 0) Else If strZone = "A" Then lngQtyLast = Nz(!ZoneA_Quantity, 0)...

Hi everyone, I'm trying to add an optional variant to the below inventory control code. I would like the code to output the current inventory for a particular zone of the warehouse if specified when calling the code. If a zone isn't specified, the code will return the current inventory for all...

Wow @arnelgp that works beautifully! If only I'd found your post on that thread when doing my research, I wouldn't have needed to create my own thread. Thank you very much for the post. And thank you to everyone who contributed :)

Please can we revert our thinking back to the title of this thread. Is it possible to open a pop up form at the cursor position? I have found similar posts on other forums, such as https://www.accessforums.net/showthread.php?t=23837 but haven't been able to get the code working on my project...

That's a shame. This would be almost perfect if it worked with a vertical scroll. Thanks for the suggestion, @MarkK. I am however struggling to see how this would fit with my project. This could be because of my lack of understanding of the code and how to adjust it to fit my purpose.

Yes sorry about that, I did delete the first post. I replaced my post because I answered my own question. I have run into a problem with your code when scrolling down the form and selecting a record. The zoom box doesn't align when the form is scrolled and gradually disappears off screen as I...

Thank you for sharing this @isladogs, very informative. I like the look of your 'Zoom Box' with the following code: Private Sub Text0_DblClick(Cancel As Integer) 'close zoom form if open If CurrentProject.AllForms("frmZoom").IsLoaded = True Then DoCmd.Close acForm, "frmZoom" strText =...

The pop up form is very narrow with an inside height of 567 twips and only opens when the product name field is clicked on so it won't jump all over the place. Having the form open above the cursor or active record each time effectively means it opens in the same place each time, just not the...

My products form has over 300 records so the user will be scrolling up and down the product list meaning the pop form would need to open at the location of the record depending on which has been selected. This is why I think it would work best to position the pop up form based on the mouse cursor.

Alternatively, the pop up form could open above the active record in the products form, if that's possible...

Hi all, I have a list of products in a form which make up our inventory and when a product is clicked on I would like a pop up form to open just above the mouse cursor displaying the stock numbers for that product. I have this all set up and working except for the placement of the pop up form...

Thank you for explaining this. I'm not familiar with coding terminology, such as arguments, but now you have explained it I understand that better. I've updated the runsql statements and they are running without errors. You are right about the date not being correct so I updated it to a starting...