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 strongm 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: *

  1. dham63

    Calendar Control - Visable when form opens

    Thanks so much for the help guys, I will remember the tips for next time. I ended up solving my issue by moving the Cal1_ click routine to the bottom of all the other code. I ended up using a number of date fields to access the one calendar, and all worked well as long as the code for the date...
  2. dham63

    Calendar Control - Visable when form opens

    Good Day and thank you in advance for your assistance. I am using Office 2003. As part of a form I have added a calendar pop up (From the control toolbox) which is working well except for one thing. The calendar is visable upon opening the form. I would like the calendar only to appear when the...
  3. dham63

    Why use Excel?

    From my own experience one of the issues is that I ususally have multi functional documents that have elements in them that may be better suited to one or another application. I try to look at the whole document and decide what is the best app for the majority of the functionality, but...
  4. dham63

    Changing code to use Option Button instead of Check Box

    Word 2003 The code below was kindly provided by DaveinIowa and works perfectly for what I need, as well as being easy to figure out and I have modified in several different ways to try different things out. One thing I have not been able to figure out and am looking for help with is how I would...
  5. dham63

    MS Query Replacement

    I like Crystal Reports. You can demo it at www.crystalreports.com Dee
  6. dham63

    Hyperlinks in Word

    In Word 2003 you apply the hyperlink and then click the Target Window button which gives you New Window as an option Dee
  7. dham63

    Assign Numeric Value to Check Box & Add to Total if Checked

    DaveInIowa - this did exactly what I needed, thank you so much
  8. dham63

    Assign Numeric Value to Check Box & Add to Total if Checked

    While I realize it might be easier in excel, the table is already designed in word and redesigning the entire in excel would probably take as much work as learning how to apply the vba in word. So my first preference is not to embed an excel. This is new functionality I want to apply to a...
  9. dham63

    Assign Numeric Value to Check Box & Add to Total if Checked

    Hi, yes it needs to be in Word. It is one aspect of a much larger project to which this rating table it related, and is all in Word.
  10. dham63

    Assign Numeric Value to Check Box & Add to Total if Checked

    Good Day, I am using word 2003. I have a table 3 columns across with each column holding a check box. The column headings are Good, Bad and Not Applicable. If a user clicks good I want a numeric value of 10 assigned, if they click bad I want a numeric value of 5 assigned, If they click Not...
  11. dham63

    Sorting, Grouping, Transposing in Excel

    Do you actually need any of the order information or do you just need to limit one line to a customer? If you are just looking to do that, it is easy enough to do using a pivot table and you will get info like this, with one customer per line. order1 order2 order 3 Name1...
  12. dham63

    Dependent Drop Down Lists

    Govana, this worked perfectly and is actually much easier than my nested ifs, even for less than 7. Thanks also to you Skip for your answer.
  13. dham63

    Dependent Drop Down Lists

    Hi Skip, thank you for your reply but I don't think this gives me what I am looking for. I have a drop down list that contains 19 options. I want the next cell to only show the list (I have 19 named ranges on another worksheet) pertaining to the selection they have chosen. Previously I have done...
  14. dham63

    Dependent Drop Down Lists

    Hi, I am using Office 2003. I have had previous success using dependent drop down lists with nested ifs in a validation statement. Now however I am faced with 19 options which have subcatagory lists, and I am not sure how to get around the limit of 7 nested ifs. I suspect that VBA might be the...

Part and Inventory Search

Back
Top