Search results

If it's a new function it doesn't have to be optional, I was just thinking of using the optional variable on the original code to get both on hand values from the same function

That's right, I would like the numerical difference between on hand as of previous date and current on hand.

The date will vary so that's why I would like it entered in a parameter. I have been trying to figure out how to do this but to no success. How do I create a parameter which passes the date entered to the optional argument? Thanks

That's correct, although I already have the code working for the stock on hand at the current level. So my question is: how to I get it working for the stock on hand at a specific date? Thanks, Chris

Hi Isaac, It's not so much that I've got a problem with the code it's more of I don't understand how to get it to work. I would like to use the code's optional vAsOfDate variant and enter a specific date as a parameter to get the quantity on hand levels as of that date. As I said in my first...

Hi everyone, I am using Allen Browne's Inventory Control Quantity on Hand code and it has an optional vAsOfDate variant, as shown in the code below. I would like to use this to show the quantity on hand for a specific date but I can't get it working. I am currently using the code based on the...

Thank you so much, jdraw, that has solved my problem. It looks to be a really simple solution as well. But, of course, it's only simple when you know. I can now progress with my project! Cheers, Chris

jdraw, I have attached the database. The 'Quantity_On_Hand_All_Products_Query' is the one with the custom function. Thanks for your help, Chris

The_Doc_Man, thank you for your explanation. jdraw, I have created a query for all product codes (called 'Products_Query) and changed your code so 'Products_Query' is the name of the recordset. I then created a query with a Product_Code field and a custom function with the code as the...

Before I posted my problem to this forum I had been playing with the code to try and identify the reason for it only producing one result. My conclusion was because the product code is a variant, but as I have limited Access VBA knowledge I didn't know how to amend this. I think jdraw is almost...

Hi all! Thanks for all the input so far, and thanks for having confidence in my ability ;) I have had a look at the Northwind database (I can't believe I haven't done so before!) and I am inspired to learn to create something like this in the future. However, I will say it is a lot more...

Hi Adam, Thanks for your reply. I used Allen Browne's code as a custom function within my query. It requires me to enter a parameter value (the product code) for which to run the query on. However, I want the function to run for all products and don't want the parameter box to appear. I'm...

Hi everyone, :giggle: I am new to this forum and hoping for some assistance. I have very little knowledge of VBA in Access and am currently developing a stock database. I plan to have a report which summarizes all products showing key information, such as the current quantity on hand levels. I...