Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds; generated 58 minute(s) ago.

  1. Replies
    0
    Views
    429

    Return Duration

    I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user.

    My data has
    User name
    Time landed on the page
    ...
  2. Replies
    0
    Views
    49

    Open Access query via VBA and lock

    I have used the following previously to open a query in Access and then copy the data to a holding sheet
    rsQuery.Open strQuery, cnConnection, adOpenKeyset, adLockOptimistic

    I now need to use the...
  3. Replies
    4
    Views
    140

    Re: VBA access query using AND & Or

    Thanks Joe

    Unfortunately my experience of building queries in Access is pretty poor and I've learnt how to do a query in Excel/VBA the wrong way round. I have tried may times to master the art of...
  4. Replies
    4
    Views
    140

    VBA access query using AND & Or

    I am wanting to get some data from an Access table based on multiple criteria and I'm not sure if my criteria is working and I can't seem to find anything that would let me verify it.

    the query as...
  5. Replies
    1
    Views
    93

    Cell Format Changing

    I am using a loop to populate multiple cells on a cell by cell basis and some of the cell formats are changing to a date format despite being formatted as a number.

    This seems to happen for a...
  6. Replies
    3
    Views
    220

    Re: Return Timeline Selection

    Thanks for this but is it possible to do this via a formula?
  7. Thread: Access Query

    by mikeymay
    Replies
    4
    Views
    1,428

    Re: Access Query

    Thanks for the input all. I managed to get this to work without fixing anything so not entirely sure why it didn't work initially.
  8. Replies
    3
    Views
    220

    Return Timeline Selection

    Is it possible to either return the Label Selection or the periods selected from a Timeline attached to a pivot table?
  9. Thread: Access Query

    by mikeymay
    Replies
    4
    Views
    1,428

    Access Query

    I am wanting to return all records in an Access table that meet a query criteria.

    The query I have built via VBA code is -
    SELECT ID, Price, QtyOut, ValueOut, InStock, ValueInStock, Allocated...
  10. Replies
    1
    Views
    65

    Re: Select Power Pivot PT Item

    I thought the following would work but it's causing a run time error
    Dim strArray As String

    strArray = ""
    Do Until rngPerson = ""
    If strArray = "" Then
    ...
  11. Replies
    1
    Views
    65

    Select Power Pivot PT Item

    I am looping through row labels in a PT using the following (which doesn't feel efficient but it's the only way I can check each item value)
    Set ptField = ptPivotTableList.PivotFields("[AD...
  12. Replies
    1
    Views
    79

    Re: Loop through PT

    Finally found the issue...


    Set ptField = ptPivotTableList.PivotFields("[AD Expected].[Proper Name].[Proper Name]")
  13. Replies
    1
    Views
    79

    Loop through PT

    I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT.

    I thought the following would work
    Set ptField =...
  14. Replies
    1
    Views
    134

    Delete Table Rows

    I am wanting to delete the visible rows in a table where a filter has been applied.

    This is what I'm using at the moment
    With Sheets("Events").ListObjects("tbl_EventItems")
    ...
  15. Special symbols/font in data validation

    I have a specialist font for garment care symbols (Medium iron, do no wash, dry clean only, etc) which I need to show in a drop down.

    The font I have installed shows the actual symbols in the cell...
  16. Re: User Form controls still executing after Unload

    Ah!!!

    So if I am needing to assign a control value to a variable (CbPersoron to strPerson), how do I do that without declaring strPerson as public?
  17. User Form controls still executing after Unload

    I am using a UF that the user enters details on that need to be appended to a range in a worksheet.

    Once the data has been added and pasted into a holding worksheet, the UF is closed via an Unload...
  18. Replies
    2
    Views
    115

    VBA Vlookup Function

    I am attempting to recreate the following Excel function which returns the expected result

    =VLOOKUP(B8,Rates_Lookup,3,FALSE)

    The code I am using to recreate this is
    .Offset(lngCount, intLoans...
  19. Replies
    3
    Views
    226

    Re: ListBox Item - Change text font

    Thanks

    I did want to change the colour of specific items but I'm going to go with the multi column listbox as this will allow me a column to show what I need to show.
  20. Replies
    3
    Views
    226

    ListBox Item - Change text font

    I there anyway of changing the any aspect of a listbox items font?

    I deally I want the font to be green or at the very least someway of making it stand out from everything else in the list box.
    ...
  21. Replies
    7
    Views
    392

    Re: Sorting Listbox items

    I have plugged this in for all the select/unslect controls and have the following
    Private Sub btnSelect_Click()

    Set ObjList = CreateObject("system.collections.arraylist")

    For intSelected =...
  22. Replies
    7
    Views
    392

    Re: Sorting Listbox items

    I'll give that a go.


    Thanks
  23. Replies
    7
    Views
    392

    Re: Sorting Listbox items

    So I've managed to cobble together a fix for this....


    Private Sub btnSelect_Click()

    Dim rngSelected As Range
    Dim rngSort As Range

    Dim strItem As String
  24. Replies
    7
    Views
    392

    Re: Sorting Listbox items

    This is the code I'm using when I want to move the selected items to the 2nd listbox
    Private Sub btnSelect_Click()

    Dim strItem As String

    Dim intSelected As Integer

    For intSelected =...
  25. Replies
    7
    Views
    392

    Sorting Listbox items

    I have two listboxes

    Items for Selection (this is a multi select)
    Items Selected


    When all the required items are selected the user will click a button to send them to the Items Selected...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4