Search:

Type: Posts; User: tuktuk; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    2
    Views
    107

    Re: VBA double Quote syntax

    got it figured out:
    wsData.Range("G8").Value = "=CUBEMEMEBER(""myCube"", ""[Geo],[Region].&[01]"",""" & strReionName & """)"
  2. Replies
    2
    Views
    107

    VBA double Quote syntax

    Hey there,

    I'm trying to use vba to set a cell value. the cell value needs to be an formula which uses CUBEMEMBER. the last value is a string

    the formula I need to set is ...
  3. Replies
    0
    Views
    150

    Slicer w new pivot datasources

    Hey there…I have a slicer linked to multiple pivots whose data connection is an olap cube.

    My goal is to change the olap cube connection and then change the data sources for all pivots and still...
  4. Replies
    1
    Views
    682

    Re: Trailing 3 Months DAX help needed

    I figured this one out: Sum(LASTPERIODS(3,[Date].[Month]),[Measures].[Sales Revenue USD])
  5. Replies
    1
    Views
    682

    Trailing 3 Months DAX help needed

    Hey there,

    I'm trying to create a Calculated Measure using OLAP Tools for a pivot whose based is a tabular cube....excel 2016.

    here is my formula: CALCULATE([Measures].[Sales Revenue...
  6. Replies
    1
    Views
    90

    formula for % of parent

    Hey there,
    I need help writing an formula to result in % of revenue subtotal on a summary sheet per product.

    Column A contain a list of products and then a summary line based on a region....where...
  7. Replies
    1
    Views
    176

    find max in a range then offset

    Hi there.

    I have a summary sheet that references a range of data on worksheet(“rawdata”). My formula on my summary sheet finds the max of a row on “rawdata”. I’m trying to now find the date...
  8. Create a new Calculated Measure for a pivot table whose data source is our OLAP cube

    My piovt has LOCATION and PRODUCT for the rows and REVENUE for Value.

    My goal is to create a new MDX Calculated Measure show each PRODUCT its % of it LOCATION REVENUE Total. Therefore, I created...
  9. Replies
    4
    Views
    141

    Re: Countifs quesiton

    gotcha.....what if is not a continuous range and individual cells. more specifically: CA5, CC5, CE5....etc?

    using the "<>0") option
  10. Replies
    4
    Views
    141

    Countifs quesiton

    I have summary sheet that references values on a data sheet. if the data sheet if populated with a 0 the summary sheets cells show "-".

    I want to count all cells that do not contain a "-" on the...
  11. Replies
    2
    Views
    187

    Re: password protect 2016 excel workbook

    it the second box when creating the pswd ...... "modify"
  12. Replies
    2
    Views
    187

    password protect 2016 excel workbook

    how do I password protect a 2016 excel .xlsx so that when a user open and DOES not know the pswd .......selecting CANCEL will open the file as READ ONLY? is this possible? thanks
  13. Replies
    1
    Views
    295

    Set MS Access Window size on open

    I know that I can set DoCmd.Maximize on open for a form......

    but how to I set the size of the ms access window to be around 3 in x 3 in on open.

    I appreciate the help.

    T
  14. after combo box entry populate column in the recordsource

    hey there
    once the combo box entry is selected I want to populate the recordsource column StartDate. since the form in linked to the main table I'm trying to populate the date with I've tried...
  15. VBA to establish ADO conn and refresh PowerPivot

    Hey there,

    I have an excel PowerPivot report that I'm attempting to refresh on open. I understand that i can use
    ActiveWorkBook.Model.Refresh but i am prompted for password to my Oracle data...
  16. Replies
    8
    Views
    3,404

    Re: VBA to Check to see if an ODBC table exists

    alright that worked but it appears that maybe it is too fast as wierd as that sounds. when i trigger the code i get an ODBC call fail error on the DoCmd.RunSQL strSQL but if i key thru it (F8) i do...
  17. Replies
    8
    Views
    3,404

    Re: VBA to Check to see if an ODBC table exists

    so i actually created a qry which shows results from LastLoad +1 to Now()-1. This gives me all dates needed. then i step thru the entire list loading those table that exist utilizing the original...
  18. Replies
    8
    Views
    3,404

    Re: VBA to Check to see if an ODBC table exists

    well actually you were correct. i am actually trying to figure out if a table exists in the oracle database. so the error handling works fine but i was asking if you have other suggestions on how to...
  19. Replies
    8
    Views
    3,404

    Re: VBA to Check to see if an ODBC table exists

    I like that but I’m still struggling with my over all procedure. Maybe you can give a suggestion. Overall goal is to auto load data from an odbc connection where the name of the desired table...
  20. Replies
    8
    Views
    3,404

    VBA to Check to see if an ODBC table exists

    Hey there,

    Using VBA in a module, I need to check to see if a table that i want to connect to via ODBC exists. is this possible?

    I'm using DoCmd.TransferDatabase acLink, "ODBC Database",...
  21. Replies
    3
    Views
    172

    Re: Defining variables

    looks like that works for the variable "z" but not the Date-1 var "a". hmmmmmmm. any other suggestions?
  22. Replies
    3
    Views
    172

    Defining variables

    I'm trying to define the following variables:

    dim z as integer
    dim a as integer

    z = "012913"
    t = Format(Date, "mmddyy")
    a = t - 1

    my issue that z is being set to "12913" rather than...
  23. Replies
    1
    Views
    388

    Re: Docmd.runSQL Syntax

    SOLUTION: so instead of having a dynamic table name in the string i decided to simply change the name of the table to "tsktsrhstDAILY" before i run the docmd.run sql. that way i do not have to...
  24. Replies
    1
    Views
    388

    Docmd.runSQL Syntax

    Can anyone help me locate where the error is in the SQL Statement



    strSql = "INSERT INTO tbl_Phone_Stats_by_Day (tsr, call_date, SumOftot_calls, SumOftime_connect, SumOftime_paused,...
  25. Re: subtract one hour in query (time/date) field

    gotcha.......actually i just reformatted in the query. thanks..that will get me there.

    Interval Time Formatted: Format([Interval Time],"hh:nn:ss ampm")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4