Announcement

Collapse
No announcement yet.

Urgent Job - Req in 10 Hours (£50)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Re: Urgent Job - Req in 10 Hours (£50)

    Let me look at deleting those files. In the meanwhile, this is how your listbox would look like. If you ask me, this is a safer bet. But I leave it to your discretion.Click image for larger version

Name:	ControlForm.jpg
Views:	1
Size:	28.7 KB
ID:	1107383
    Cheers,

    S M C

    Click To Read: How To Use Tags In Your Threads/Posts
    Please take time to read Forum Rules before posting
    Message To Cross Posters

    Comment


    • #17
      Re: Urgent Job - Req in 10 Hours (£50)

      Nope, problem not resolved even after deleting those files you mentioned. Anyway, I'd exhort you to take the opinion of a few more developers, if you deem so, and decide on whether the ListBox will suffice, or whether you need the ListView. My suggestion: play safe. (Ignore the fact that I may be influenced because I can't get it to work on my system).
      Cheers,

      S M C

      Click To Read: How To Use Tags In Your Threads/Posts
      Please take time to read Forum Rules before posting
      Message To Cross Posters

      Comment


      • #18
        Re: Urgent Job - Req in 10 Hours (£50)

        Oh and in the list, why are there cells filled till G6968 while in the Sell Price column, it is only till F6113
        Cheers,

        S M C

        Click To Read: How To Use Tags In Your Threads/Posts
        Please take time to read Forum Rules before posting
        Message To Cross Posters

        Comment


        • #19
          Re: Urgent Job - Req in 10 Hours (£50)

          If we can clear all queries, and ensure that both of us agree on the objective, and are clear how to do it within another half hour, it'd give me just about enough time to finish it before sleep. Otherwise, I may not be able to finish it within your 10hrs.

          Let me know.
          Cheers,

          S M C

          Click To Read: How To Use Tags In Your Threads/Posts
          Please take time to read Forum Rules before posting
          Message To Cross Posters

          Comment


          • #20
            Re: Urgent Job - Req in 10 Hours (£50)

            Originally posted by S M C View Post
            Let me look at deleting those files. In the meanwhile, this is how your listbox would look like. If you ask me, this is a safer bet. But I leave it to your discretion.[ATTACH=CONFIG]45633[/ATTACH]
            Hmmm... it doesn't look much different to be honest. Is there a lot of work in switchng it over? As in, if we went with that and for some reason it turned out that preference was to revert back to LV, would it be a lot of time?

            It looks okay in the static shot, but my concern is that it may behave slightly differently when returning the results. One example is the Enter event - where as soon as the focus was on the LV, the highlighted item displayed in the product info field.

            Let me know on the deleted files and the estimated time to switch to the LB (and possibly back to LV - but only if there is a good reason).

            I hope I don't come accross as too indecisive! I guess I'm conscious of asking too much of you.

            Comment


            • #21
              Re: Urgent Job - Req in 10 Hours (£50)

              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.

              Comment


              • #22
                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?
                Cheers,

                S M C

                Click To Read: How To Use Tags In Your Threads/Posts
                Please take time to read Forum Rules before posting
                Message To Cross Posters

                Comment


                • #23
                  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.
                  Cheers,

                  S M C

                  Click To Read: How To Use Tags In Your Threads/Posts
                  Please take time to read Forum Rules before posting
                  Message To Cross Posters

                  Comment


                  • #24
                    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?

                    Comment


                    • #25
                      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?
                      Cheers,

                      S M C

                      Click To Read: How To Use Tags In Your Threads/Posts
                      Please take time to read Forum Rules before posting
                      Message To Cross Posters

                      Comment


                      • #26
                        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?

                        Comment


                        • #27
                          Re: Urgent Job - Req in 10 Hours (£50)

                          Got it.
                          Cheers,

                          S M C

                          Click To Read: How To Use Tags In Your Threads/Posts
                          Please take time to read Forum Rules before posting
                          Message To Cross Posters

                          Comment


                          • #28
                            Re: Urgent Job - Req in 10 Hours (£50)

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

                            S M C

                            Click To Read: How To Use Tags In Your Threads/Posts
                            Please take time to read Forum Rules before posting
                            Message To Cross Posters

                            Comment


                            • #29
                              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.

                              Comment


                              • #30
                                Re: Urgent Job - Req in 10 Hours (£50)

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

                                S M C

                                Click To Read: How To Use Tags In Your Threads/Posts
                                Please take time to read Forum Rules before posting
                                Message To Cross Posters

                                Comment

                                Working...
                                X