Recent content by umair434

Hi all, I have a table which shows when a product is available in the stores. For example. Product Store Available A NS Jan, 2013 A BC Marc, 2013 How can I combine the available/store field which just shows Product Available: A - Jan, 2013 in NS AND...

Hi all, I have been trying to figure this out for a while. I have a list of products that have a loan payment associated to them. To cover these loans, we have incoming revenue for each product at different dates. The incoming revenue is a field of running sum of revenue for each product...

Hi all, I am trying to create a column/bar chart for some raw data that I have. Data: Products, Zones, Ordering Coming date So, the data I have is for products that are in some zones (warehouses), and orders coming date is when the orders are coming (sample sheet attached). What I would...

Hi all, I have been trying to figure this out for a while. I want to calculate running total and find out the date when that total is greater than a number. My initial plan was to use Dsum and then use dlookup to find when that Dsum value > [Fixednum]. But when I try Dsum and use...

Thanks guys. That works. It's been a while since I used access and hopefully things will come back to me quickly.

Thanks, Cronk. That helps. How would Iadd the [From supplier] field, to give me the quantity that was received, for that time period i.e. when the first quantity came, and how much was it.

Hi all, I have a table with products information (week, inventory, orders coming from supplier). I want to find out what week is the first order coming in. I have tried using dlookup to find week but, not working. Database attached (with table called desired output which is what I...

Hi, I have a list of products with their description. What i need to do is remove the last few characters to convert description into style. Example. ALTRA PINE M8ALTRA PINE M9ALTRA SIM LC M10ALTRA SIM LC M11ALTRA SIM LC M12 What i would like to see is just Altra Safeguard M and Altra...

thanks! But how do I declare the variables in the function then. Alternatively, I was thinking to use dlookup. So when user enter a week number. I make it equal to a string which equals one of the columns. Now that means the first part of the dlookup (the column name) becomes a variable...

Hi, i am using a simple public function to calculate the cost which is dependent on the inventory week. How do I design so that when the user enters a week number in a form. It uses only that column to calculate the cost. Public Function PPC(week1 As Variant, CASE_CUBE As Variant) PPC =...

Tried everything.. it still gives 0. I'm missing something here :(

that's what I tried before but timestamp always equals now().. the difference always turns out to be 0. Somehow I need to find the time when the button is clicked..Now() just shows the true time.

but how do I find the time when the button is clicked?

Hi, So I have a form set up which has a button.. the onclick event of this button runs some code and produces a report.. This usually takes 2-3 mins. I am actually looking for a way that if it has been less than 20 mins since the user clicked that button, a macro is skipped (no need since...

Thanks! that guided me in a right direction and I almost have what I am looking for. Just one thing: When the user selects a container number in the combo box, the first subform is populated with multiple product numbers. Each product number has to have a comment (Comment is a field in this...