Search results

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

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

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

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

Hi, On my Form I have a Label (Recnote) which gets changed by the VB code if criterior is true. My form does change this correctly however, once I quit (or close the Form) and come back, the changes dissappear. But the strange thing is that every now and then it does save it. Any ideas??? Any...

Hi, I am having this error which is driving me nuts but I am sure it is quite a simple one. I am attaching a Sample dbase - My command runs of a Form based on a Table. Any help?? Thanks

Hi, I know this is very simple but I am unable to get it work. I have a Form (based on Table "Trades") and on the Form is a Command button. The Command Button has a VBA Code which selects the items from the Table and coverts to a text file - this works fine but the problem is that I am unable...

Hi, I am new to Access Forum and I have a very easy question: I need to show a Progress Meter in a Form whilst my Dbase is running a Macro containing several Queries - these Queries are Delete, Append etc and finally a MsgBox. Any ideas on How to do a Progess meter whilst the Macro is running...