Search results

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

I am not duplicating the data. Would you mind to have a look at the database if I posted it here? Here is how application should work: 1) User selects a container # from the combo box on the main form. 2) this popuates the first subform with the list of products (datasheet view)...

I just revised the requirements of this application and realized that the second subform does not have to be invisible. How would I approach the issue that: the user clicks on the productID field in the 1st subform, and this populates the second subform with the productID selected? thanks...

Hi! Im using the code on the on click button. the problem with that is that it saves the comments and runs all the queries everytime users presses this button to save the comments. Is there any alternative? or saving the comments can be faster and the queries are run as well? Thanks!

Thank You! it works really well. Just wondering, is there a way to open the form as a subform underneath? like it becomes visible only if there is there is a matching product?

Hi, I am using the following code to add comments from a subform to a table. The subform is populated by a combo box: Private Sub Command9_Click() DoCmd.GoToRecord acDataForm, "frmMain", acNewRec DoCmd.OpenQuery "qry - Archived" DoCmd.OpenQuery "delete_qry_Final_Details" DoCmd.OpenQuery...