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!

Register Log in
  • Congratulations Chriss Miller 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. drmichaelw

    data validation Yes or No- Excel

    That was easy Thanks!
  2. drmichaelw

    data validation Yes or No- Excel

    How do you create a drop down box in a cell with the only choice of Yes or No?
  3. drmichaelw

    Excel: Internal Rate of Return Function (IRR)?

    I did read the help and found it a bit confusing. So if my results for the 19 months is -26.0%. That means what?
  4. drmichaelw

    Excel: Internal Rate of Return Function (IRR)?

    Thanks for the info. The formula works, can you explain what this formula is doing? Why doesn't a positive # work for the guess and why doesn't the value change when I use guess of "-.5" or "-.9"?
  5. drmichaelw

    Excel: Internal Rate of Return Function (IRR)?

    I am using the IRR function and I am getting #DIV/0! returned. When I check my data there is no zero value. Here is my formula. Can you tell me why I am getting #DIV/0! =IRR(B6:T6)*12 Here are my values: ($24,000.00) ($128,448.45) ($30,000.00) ($100,000.00) ($27,000.00) ($50,000.00)...
  6. drmichaelw

    VBA ? In help in creating dynamic charts in excel

    Dale, That sounds great. I will go through the data tomorrow and will send you a sample worksheet. The feature which sends the graphs to powerpoint sounds great as well. I will communicate with you soon Regards, Michael
  7. drmichaelw

    VBA ? In help in creating dynamic charts in excel

    What I would like to do is click a button that runs code, which creates bar graphs of my data. Mytable columns: Description, Part ID, Fab, system division, total/partId for each part Id I have different fabs, systems and total/partId. Iknow what I want to do however I don't have much...
  8. drmichaelw

    Dynamic Excel charts

    I forgot to mention that the excel data is comming from Access. My alternative would be to create the charts in access, and export them to excel. I never used chart in Access. Can anyone help with this alternative. Please refer to my initial question. Thank you.
  9. drmichaelw

    Dynamic Excel charts

    I'm only a little bit familiar with vbscript, but is there a way to create a macro to graph my data. My table columns are (name, part,fab,totals,division and totals/part.) I would like to create a different graph for every part. The x axis would be fab and the y axis would be totals. I am...
  10. drmichaelw

    format number in Query

    Worked well! How do I add in the leading and trailing 0 before and after the decimal place.
  11. drmichaelw

    Can I typecast in a Select statement?

    Sorry for the confusion! Sample data: 0 00 000000 000000-000-00 000-000-00-000 Each month I receive new data and I won't know in advance how many part id will have data like the above, and what combination of zeros and or dashes they will have. Any Part id that contains zeros with or without...
  12. drmichaelw

    format number in Query

    SELECT system, total, system/total AS [sys/total] FROM table; Iwould like to return only one decimal place instead of many for [sys/total]. How can I format to one decimal place?
  13. drmichaelw

    Can I typecast in a Select statement?

    Bob, I'm not sure what you are doing on the WHERE clause. It looks to me that the only value that won't be selected is the one you listed, or are you saying to make a WHERE clause like this WHERE [part id] <> '0' AND <>'00' AND <> '000', etc.?
  14. drmichaelw

    Can I typecast in a Select statement?

    Select CLng([Part ID]) From table WHERE [Part ID] >0 I get an error in the expression. Problem out of the over 20000 rows some of the part ids have letters. Would this blow up the Clng function?
  15. drmichaelw

    Can I typecast in a Select statement?

    I have a select statement that includes [part id] The excel table that I am linking to has &quot;dirty data&quot;. Some [Part Id] have been assigned 0,00,000,0000,etc. [Part Id]is text not a number. I am performing a COUNT function on [Part ID] and it counts the [Part Id} with the...
  16. drmichaelw

    Exporting from Access to Excel

    As it turns out I did not realize that I had a table named the same as the query. This table had some of the same info, making it confusing. I did not need the table and deleted it and my export runs fine. Thanks
  17. drmichaelw

    Exporting from Access to Excel

    I am running Access 2000. I have created a link to an external excel file and I am running a number of queries on this link. I am trying to export the results of one of those queries back to the same excel file. I created a macro to do this in the macro in the macro window. I am exporting...
  18. drmichaelw

    How to create a VB Form in Access

    Got it, Its easy once you know the way Thank you
  19. drmichaelw

    How to create a VB Form in Access

    In design view I clicked on the button and in properties window clicked EVENT and ON CLICK. However, I did not see the click procedure in my module? MW
  20. drmichaelw

    How to create a VB Form in Access

    Sorry, I am using Access. I have written vba code in Access. I would like to know how I can run this code from a form in this database. I created a form, and put a button on it. I am trying to figure out how to run the vba code when I click that button. When I created the button I had a...

Part and Inventory Search

Back
Top