Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gohym
  • Order by date
  1. gohym

    Searching through a tree structure

    Hi CajunCenturion, Thank you so much for the algorithm! Well it is definitely a good start for me. I'll study the algorithm, but it won't be so soon as I have gone on to other tasks already. Guess I'll come back to this problem in 1 or 2 months time. Thanks.
  2. gohym

    Searching through a tree structure

    Hi jmeadows7, Really appreciate your advice. I will try to do some readings on tree traversal with "infix, postfix or prefix" algo... These terms sound pretty intimidating. Can you point me to some good resource for my readings? Thanks!
  3. gohym

    Searching through a tree structure

    Hi, I am trying to do some calculations which require some kind of depth 1st search algorithm. I have some ideas as to how to do it, but I think there should be a better way to do it. Hopefully someone can give me some advice. Thanks in advance. FYI, I'm not an expert in coding, would...
  4. gohym

    How to hide and secure columns in Excel?

    Hi macropod, Thanks for the reply! I think the separate worksheet method should work. I'll give it a try. thanks. :) BTW, do you mind showing me how the 'veryhidden' property is set via vba? Cheers!
  5. gohym

    How to hide and secure columns in Excel?

    Hi, I need to ensure that the users do not get to see one of the columns in the file I created, but I may still need to make changes to that column... I am thinking of having some kind password protected column, i.e. no password cannot see and edit column. Is it possible? For clarity sake...
  6. gohym

    Spam problem- How to create rules based on display name?

    Hi, I'm having problems with spam emails... I had been using the rules wizard of my outlook 2002, but I realise that outlook 2002 is not able to create rules to identify display name of sender, but can only be based on the email address of the sender (correct me if I'm wrong)... can anyone...
  7. gohym

    How to Delete all records in a table using ADO

    Hi Mike, Let me give it a try and get back to you... Thanks!
  8. gohym

    How to Delete all records in a table using ADO

    Hi, I have a table, "Temp", that contains some temporary information; it has only 1 field called "CSIID" . The CSIID is shown on a form and I want all the table's records to be deleted, once the form closes... preferably not using DAO... Can someone please provide some guidance... time is...
  9. gohym

    How to change start-up options

    Hey Edski, Thanks for the help... it worked... won't tell anyone :)
  10. gohym

    How to change start-up options

    Hi... made a lousy mistake of playing around with the start up options, without knowing what was it about... I unchecked all the start-up options which removed the database windows etc... now I don't know how to undo all those options and get back to the default mode... anyone can offer any...
  11. gohym

    How to ensure all textboxes have same height?

    That's because I read the FAQ on how to get great answers! Cheers... see you around.
  12. gohym

    How to ensure all textboxes have same height?

    Hey it worked! May still need a bit of adjustments, as the text is a bit close to the box, but let me solve that part myself... Thanks!!
  13. gohym

    How to ensure all textboxes have same height?

    Hi dhookom, Thanks for the reply. Can you elaborate on the Line method? to be frank I'm not that proficient with all these programming stuff... Thanks!
  14. gohym

    How to ensure all textboxes have same height?

    Hi, Appreciate any help that you can give here... Thanks. I have this report with 5 textboxes. Each of them is set to "can grow" = true. However, it is also prefered that all the text boxes have the same height. I have the following code... but it does not seem to work. Private Sub...
  15. gohym

    How to calculate weighted score with NA cells in excel?

    Strange... I tried to give geoff a star... clicked the link a few times, but nothing happened... Anyway, Here're a few stars for you Geoff... Thanks! * * * * *
  16. gohym

    How to calculate weighted score with NA cells in excel?

    Hi Geoff, I took the opportunity to learn something from the code... I digested the code and did a bit of modifications... the initial code did not give the results I wanted because the conditions for the calculations is based on having the front part of the item being the same as the same as...
  17. gohym

    How to calculate weighted score with NA cells in excel?

    Hi Geoff, Thanks for the code!! I'll give it a try and get back to you...I really hope this works... was trying not to do coding... something I'm not very familiar with... but it's good to learn...
  18. gohym

    How to calculate weighted score with NA cells in excel?

    hmmmm.... I think putting 0 instead of NA only solves part of the problem... because I need a way to remove items rated as NA totally from the calculation of the weighted average, i.e. the weights for NA need to be removed from the denominator... Using the same e.g. from above... item 1.1 will...
  19. gohym

    How to calculate weighted score with NA cells in excel?

    Hey geoff... thanks!! Really really appreciate it!

Part and Inventory Search

Back
Top