Search results

  1. C

    Change chart options without double-clicking on chart

    I have had the following problem for YEARS across countless versions of MS Access (currently using 2016) and so I must be missing something but every time I try to create a chart in MS Access I hit the same issue... There are chart options I need to change that can only be gotten to by...
  2. C

    multiple criteria vlookup using date

    Thanks, this is working.
  3. C

    multiple criteria vlookup using date

    Sorry, I should have said... This is in Excel not Access. I've updated my first post. That said, it gave me the idea to try using VBA rather than formula... I wrote the following which is very slow but working... Function GetCostPrice(x, y As Range) Dim lBC As String Dim dDate As Date Dim...
  4. C

    multiple criteria vlookup using date

    Hello, I'm using Excel 2010... I have a large worksheet (about 12k rows) with three columns of products/prices. I need some formula which will find the price of a barcode at a given date. e.g. what is the price of 10009 on 3/1/15? (It would be at the last provided price, i.e. £1.10). Any...
  5. C

    Can you update a table/run queries without MS Access?

    Thanks, that looks exactly what I need. I'll give it a go.
  6. C

    Can you update a table/run queries without MS Access?

    Hi, I'm using Microsoft Access 2010. I want to create a database that people without Microsoft Access can use. I'm not sure if this is possible... If I create a database is it possible to use VBA in Excel to update a table in Access and then run/export a query? I know you can use Excel to...
Top Bottom