Recent content by ChrisMore

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

I've added those 4 arguments, the values are taken from the form controls where the intakes are entered. I'm not 100% sure if I've done it as you intended. I'm still getting the compile error so I assume there is something I've missed. My amended version of your code is below, please can you...

@gemma-the-husky, I'm off to a slow start unfortunately. I'm getting a compile error (wrong number of arguments or invalid property assignment) when I run the process_order_intakes code. It highlights 'CalcAVCO' in the code when the error appears. I haven't come across this error before, any ideas?

Thanks again for all your helpful advice. I think I need to experiment with the code you created in order to understand how best to use it for our company. I'll spend some time doing that in the coming days and I'm sure I'll need to return to this thread when I get stuck. But, in the meantime, I...

I see what you mean now, I refer to 'opening stock' as 'stocktake' and I have a table which hold this data, including a stocktake date field (I also have a stocktake count table which the stocktake table is linked to but it seems I forgot to include it in the sample database). The...

Thanks so much for your time in creating this, I very much like the direction this is going in. I have been racking my brain trying to understand it, if I'm being honest. I think I am getting there but do have a few questions: 1. In the CalcAVCO function, what do you mean by openingstock? Is...