Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 3 of 3 FirstFirst 1 2 3
Results 21 to 30 of 30

Thread: Urgent Job - Req in 10 Hours (50)

  1. #21
    Join Date
    1st September 2011
    Posts
    11

    Re: Urgent Job - Req in 10 Hours (50)

    Quote Originally Posted by S M C View Post
    Oh and in the list, why are there cells filled till G6968 while in the Sell Price column, it is only till F6113
    Just change both to G7000.

    It's the product of a great many changes over the development phase. Once I had it working I was going to go through all the code line by line, but if you spot something such as the above, feel free to change it.

    With the LB control. Lets bite the bullet and go for functionality over aesthetics.

    So long as it behaves in the same manner, I'll be happy!

    Incidentally, the deadline is tonight only because I wanted time to address any bugs/issues before work on Tuesday and my dealings with Freelancer left me with close to zero confidence in internet 'programmers'.

    Given you are clearly more 'together' than previous individuals, it wouldn't be the end of the world if the job were completed tomorrow. Basically, I need to be able to run a fully functioning tool on Tuesday morning.

    Any other queries and let logic prevail. I will test thoroughly tomorrow, but any queries such as the above where you spot inconsistency, feel free to amend as you see fit - it is highly likely you will make the right call.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #22
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    Well, we could comment the code for the LV, and then revert from LB if you think you have to. As for the Enter event, I can assure you as soon as the focus was on the LB, the highlighted item will display in the product info filed. And, just to be sure, can you reiterate exactly what should the original requirement encompass? That is, precisely what should I be doing?

  3. #23
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    I appreciate the confidence. I will go through the existing code also, and see if I can iron out any apparent anomalies that I see (if there are any that is). But my priority would be to work on the original objective first.

    On the Product list, I have actually added a dynamic range that can expand till 10000 rows. And this will automatically updated in the LB because of the dynamic range.

    I am starting to work on the LB to ensure you don't loose out on any functional aspects of the tool. But I repeat, can you list down everything that I should be covering, so that you and I know what is expected.

  4. #24
    Join Date
    1st September 2011
    Posts
    11

    Re: Urgent Job - Req in 10 Hours (50)

    Okay, LV behaves as follows:

    1. If using "Code Search" displays results based on a search of column "A" in "Products"
    2. If using "Description Search" displays results based on a search of Column "B" in Products
    3. Tab down to LV from search box and as each product is highlighted, all relevant fields in Frame "Product Details" are populated with their respective values.

    I put the Enter event code in becuase in the original file, when I first tabbed into the LV control, the fields in the Frame "Product Details" would not populate - I had to arrow down and then back up again to get it to display the values.

    This only happened when I first tabbed into the LV on the very first result. I hope that makes sense.

    To put it another way, if I search for a product and the search results in LV narrow to one result. When I tab down to the LV control, I need the product details Frame to populate immediately without any other keystrokes.

    Does that make sense?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #25
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    So if I type Caliper in Description Search, the LV should populate all records that start with Caliper in the description field. Similarly, Code Search for the first field. Is that correct?

  6. #26
    Join Date
    1st September 2011
    Posts
    11

    Re: Urgent Job - Req in 10 Hours (50)

    Sound about correct,

    The only thing I would clarify is in the description search it returns all results that INCLUDE the search string, whereas with the code search, it returns all results that START with the search string. You should see the additional * wildcard in the description search code?


    Does that make sense?

    Excel Video Tutorials / Excel Dashboards Reports


  7. #27
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    Got it.

  8. #28
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    Your Products list has a lot of duplicates. Should I delete those?

  9. #29
    Join Date
    1st September 2011
    Posts
    11

    Re: Urgent Job - Req in 10 Hours (50)

    It doesn't matter really as it's a dummy list. The duplicates were to see how excel handles the 6000 lines.

    Excel Video Tutorials / Excel Dashboards Reports


  10. #30
    Join Date
    1st March 2010
    Location
    God's Own Country
    Posts
    3,612

    Re: Urgent Job - Req in 10 Hours (50)

    Can you send me your email address via PM? I have made the modifications.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 1
    Last Post: October 19th, 2011, 02:34
  2. Replies: 3
    Last Post: December 15th, 2010, 22:33
  3. Replies: 9
    Last Post: January 31st, 2010, 07:56
  4. Format Total Hours to Days, Hours & Minutes
    By dpw in forum EXCEL HELP
    Replies: 9
    Last Post: September 6th, 2007, 04:28

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno