Search results

  1. T

    Reading values in CSV text inside a query

    I have a text field that contains a comma delimited list of numbers. I am trying to read one of these numbers from OLEDB through to an access database. I am trying to do the following: SELECT SPLIT(CSVData, ValueNo) as ReturnValue FROM MyCSVDataTable Where CSVData is a split field...
  2. T

    Button to open Windows Explorer window

    Try ... shell("explorer.exe """ & myPath & """",vbNormalFocus )
  3. T

    Lock Pivot Chart

    I have the same problems - I get around it by making a copy of the pivot chart in VBA and opening this instead of the original - therefore the properties for the original pivot chart don't get changed. However you need to make sure that your pivot chart form does not have any VBA code, otherwise...
  4. T

    Pivot Chart not saving format changes

    I have the opposite problem - And wish I could solve it.... I have formatted the Pivot Charts in the pivot chart view and got them looking really good, however if they are then opened by a user and the users fiddles with anything it saves the changes on top of my pre built pivot charts. This...
  5. T

    Hi!

    Just logged on to this forum, looking forward to discoverying a world of useful tit bits and also to help spread joy and delight in developing in Access. Specially when fiddling with stuff that does one thing in one version another in another and doesn;t work in a third!:eek:
Top Bottom