Recent content by Fijian

I don't need any ActiveX Control. I meant I have not put any VBA but used the builder button.

Hi, I am using a Hyperlink Address property on a Label in a Form. This works fine and opens a html file which has help references. This file also has Bookmarks in it and works fine when used within html file. However, if I use the Bookmark property (Hyperlink SubAddress) it gives the...

This is what you can do. Very simple. Create a AfterUpdate command (assuming your Combo name is "Combo2" Private Sub Combo2_AfterUpdate() If [Combo2] = "Follow-up 2" Then Me.Combo2.Value = "See John Brown" Me.Combo2.BackColor = 2366701 Else 'Leave the back color as White Me.Combo2.BackColor...

Hi, I have done the hard part - created a Form Pivot Table in Access 2013 from an OLAP Cube using properties - ConnectionString and DataMember. The PivotTable works fine and gives me the result I want. But I am stuck with the easy part - I want to use the result in a Query or Table (i.e. The...

Thanks Joe, I had a look at the dbase you sent but it is not what I intend to do. Is there anyone else with any ideas? Thanks

Hi Joe, Brilliant! Please send me a dummy file, I will very much appreciate it. Thanks :)

Thanks DocMan for your advise. But I do not need to take a new methodology because the Avg Weighted is complex. I understand the full concept of FIFO and Inventory system but this is bit more complex. This is to do with Shares and the Accounting method required is Weighted Average which is the...

Hi Gemma, I do have unique ID for each transaction which comes from the source dbase which are attached to each transaction. I am still not sure what to do? Cheers

Hi The_Doc_man, The values you have shown are correct! If the values at Point 1 were sold at 2, then it becomes FIFO (First In First Out) and that's why I mentioned not to get mixed with that scenario. This method is Weighted Average and thats why 2.5 at Point 1 and 2.75 at Point 2 is correct...

Hi, I've searched hours on the forum but with no luck. If there's anyone out there who can help me would be very much appreciated. The calculation in Excel is very simple but I am unable to replicate in Access. Please don't confuse this with FIFO calculation as it is purely Weighted Average...

Thanks Moniker. Your suggestion appears to do the trick but I am struggling to get the result. I have tried several ways to get it work but I think I am missing something which could be very simple. I would appreciate if anyone can have a look and point out what I am missing. Please click...

Yes it is possible in Excel. But not in Access.

Hi, Just to let you know that WorksheetFunction does not work as it is not part of it. It is a Add On in Excel from Analysis Tool Pack. Any other ideas anyone?? Thanks

Guys, Excel Object Liabrary does not work. Also, it is not a simple equation which can be rebuilt as it takes hundreds of iterations to calculate so that is out of question. Any other ideas. Thanks

Hi, I am trying to use the YIELD worksheet function in Access but can't get it to work. It comes with Error Sub or function not defined. As per help file I have installed msowcf.dll but it still doesn't work. Any ideas? Thanks