Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Scraping web works on same kind of webpage except one.

    My company uses a webpage created by ASP.NET to upload data from difference sources (people). Employees from different regions input data on the webpage and I consolidate the data into a report.
    ...
  2. Re: Open and close field based on input of another field

    Sorry, I was not clear.

    Yes, this would be a form, but how would I code the fields. I am new to Access.
  3. Open and close field based on input of another field

    Hello,

    I have a Table with 11 fields.

    The first field is a drop-down field with two options. Lets call them option A and option B.

    The remaining 10 fields relates to either option A or...
  4. Replies
    2
    Views
    126

    Re: Subscript 9 error, VBA Array, shorthand

    Thank you!
  5. Replies
    2
    Views
    126

    Subscript 9 error, VBA Array, shorthand

    Can anyone tell me why I am getting a subscript 9 error.

    The error is at the line highlighted in red.



    Sub Create_arrays()

    Debug.Print "Creating the Arrays"
  6. Re: Edit code to fix out of stack space error

    Thanks. I changed the variables to Long and I still getting the error.
  7. Edit code to fix out of stack space error

    The code below used to work, but now I am getting an error (out of stack space).

    The code calculates ownership percentages up an ownership tree.

    For instance:
    Company 11394 is owned 75% by...
  8. Replies
    1
    Views
    251

    Dictionary, item, object required error

    I am getting an object required error when I run the following code:




    Sub Schedule15(theDictionary As Dictionary)


    Dim singleKey As Variant
  9. Replies
    1
    Views
    201

    Collection, class, printing

    I have a collection with a custom class and I don't know how to print the items in the collection.

    Can someone help me?

    The collection = datacollection.

    The class = bobjclass

    class...
  10. Replies
    0
    Views
    66

    Help with Pivot update event

    Hi,

    I uses pivotable to create financial statements from data.

    There are three different group accounts (Ks, Ps and As).

    I want each group account to have its own color.

    My pivot table...
  11. Object required, runtime error 424, dictionary print to immediate

    When I try to print items to an immediate screen and I get an onject required error.

    This code is modified from a code I got online.

    The debug higlights the line in red.



    Sub...
  12. Replies
    4
    Views
    121

    Re: create array by using a function

    I am new a functions so maybe I guess I don't understand how to construct them.

    I want to populate a array with data from a dictionary. I find arrays easier to work with.

    I want to populate 5...
  13. Replies
    4
    Views
    121

    Re: create array by using a function

    I am trying to populate with the function.


    [CODE][Function populateDict(thearraY As Variant) As Variant/CODE]
  14. Replies
    4
    Views
    121

    create array by using a function

    I am getting a mismatch error at the line highlighted in red. The error occurs after the function is ran. I am confused because I created both items variants. How could there be a mismatch?


    ...
  15. Re: Transfer Dictionary data to an Array, but getting "subscript out of range"

    Yes, found my issue. I will choose my the name of my variables more carefully.

    Thanks!
  16. Re: Transfer Dictionary data to an Array, but getting "subscript out of range"

    Found it.

    I had an spelling error. I misspelled returnarray inside the parameter.
  17. Re: Transfer Dictionary data to an Array, but getting "subscript out of range"

    Yes, I guess it is a bit confusing.

    Let me explain what I am trying to accomplish.

    The function I submitted is part of a subroutine.

    1. The Function (populatedict) takes in an array...
  18. Re: Transfer Dictionary data to an Array, but getting "subscript out of range"

    ReturnArray is declared at the top of the module before the main sub.

    "dim returnarray() as variant"
  19. Re: Transfer Dictionary data to an Array, but getting "subscript out of range"

    I have option explicit and option base 1 at the top
  20. Transfer Dictionary data to an Array, but getting "subscript out of range"

    My code is running into a Run-time error 9 (Subscript out of range).

    When the code is debugged, the line printed in red is highlighted.

    Here is my function:


    Function populateDict(thearraY...
  21. Replies
    3
    Views
    235

    Re: Return value from function

    Thanks. Works perfectly.
  22. Replies
    3
    Views
    235

    Return value from function

    Hi

    How do I return a value to my sub procedure from a function?

    I created two functions to get the last row and column of a worksheet. However, after the function is ran, it resets to zero. ...
  23. Writing array to excel is slow despite only 2500 rows of data.

    The following sub procedure is one of a few located in my module.



    Sub writetrans()

    Sheet3.Activate

    For A = 2 To UBound(MainArray2)
  24. Replies
    3
    Views
    156

    Re: debug Syntax for dictionaries

    I am trying to view the items associated to the key. How would I do it with the watch window?
  25. Replies
    3
    Views
    156

    debug Syntax for dictionaries

    Here is a snippet of my code:

    Set Results = New Dictionary

    For i = 2 To UBound(Mainarray)

    TheDate = Mainarray(i, 1)


    ' If team one is not already in dictionary then add
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4