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. striveforexcelence

    media player on worksheet

    I'm sorry I used the code above but I still dont seem to have any association between the player and the code. Am missing something? The player has the buttons greyed out so I am sure there is no association. (You cannot hyperlink)
  2. striveforexcelence

    media player on worksheet

    hello all I recently did a project where I needed Windows Media Player to play a video using vba. This opened an isntance of media player. Then I was contacted by someone who saw my posts and he would like to use media player directly on a worksheet. I have placed a media player on a...
  3. striveforexcelence

    VB Script to copy in Excel Workbook

    can you just establish the static location for them and link the workbooks?
  4. striveforexcelence

    Concatenating Cell values in Excel 97

    wait concatenate is simple in excel. give me an example of what is in the cells and i will tell you exactly how to do one cell and pull it down or the rest
  5. striveforexcelence

    formulas with hidden columns row activate problem?

    well, I thought I had it fixed by activating a non formulaed (?) row on sheet activation. for some reason the first row will not maintain a formula??? Any ideas?
  6. striveforexcelence

    formulas with hidden columns row activate problem?

    yes it does look like that... i re did the activate sheet code to a different row cell and it works fine. weird. something about if you activate a cell in a row the row loses the formulas. This project has been quite a pain it is a demo for a us/canada/south america roll out and it has an...
  7. striveforexcelence

    PowerPoint 2000: How to remove all slides' animation at once?

    I looked at the vba and i use vba and i am certain there is an easier and more maintainable way to do that. i am sorry i dont have your version anymore to play with. good luck
  8. striveforexcelence

    Attach a file to a record

    are you viewing the record on a form? it is very possible to do this sort of thing depending on how you are viewing the record and how you want to associate the other document. give a bit more specific information about what you have so far. let's work together to wow your boss :) he can see...
  9. striveforexcelence

    formulas with hidden columns row activate problem?

    thanks i was really stupid about the arrow keys lol the scroll lock button was off but the rest is really odd As for the code Im not really sure what you want to see but mainly you come to the opening sheet and you click on a hyperlink button that opens a sign on form for a text box password...
  10. striveforexcelence

    Access 2003 Calls per hour

    Yes this is very possible and you can do it different ways depending on how you have set up your table. If each call entry is assigned to a particular hour, you can sum in a query for a report or you can group in the report itself. Both ways are simple but again it depends on how the...
  11. striveforexcelence

    formulas with hidden columns row activate problem?

    I have a workbook that has an initial sheet on open and then when an assigned macro on a navigation bar is selected another sheet is activated and becomes visible and range "B9" is activated so that the first entry will appear in the first appropriate row for that sheet. The sheet has three...
  12. striveforexcelence

    PowerPoint 2000: How to remove all slides' animation at once?

    have you tried going to "animation schemes" selection "no animation" and selecting "apply to all slides"? Just a thought for now
  13. striveforexcelence

    Powerpoint: Slide Master images not printing

    vionca, I was looking around powerpoint trying to reproduce your situation. Are you trying to print only those slides or all of the slides? When you "print" is the printer set to "notes" or "slides"?
  14. striveforexcelence

    Constructing a form to track student attendance

    from an end user standpoint i was wondering a couple of things.....first.... who is going to input this data? teachers? if they have many students and/or many classes this is inevitably going to become a mundane process and that leads to incorrect information either not entered for a day or...
  15. striveforexcelence

    Powerpoint 2002 Text Speed

    I tried playing with powerpoint to see if i could replicate the issue. When I used credit, it seemed slow enough to read unless maybe if there were too many lines and the lines were very wide. I am wondering if you were instead using a custom animation. If so, you can set the default delay...
  16. striveforexcelence

    List boxes in Excel - User Form

    SOLVED!!! Thanks to everyone who helped out with this. By piecing together bits from various people we were finally able to figure out the obstacle. Thank you all! It works perfectly now.
  17. striveforexcelence

    List boxes in Excel - User Form

    well that is my point. The question then remains.....what do I do .... what do I modify....what do I add......so that in the simplest explanation..... whatever the user chooses in that list box is put into the first available row in column b and the the corresponding unit price is put beside it...
  18. striveforexcelence

    List boxes in Excel - User Form

    yes that was my previous post that i apologized because now even i am confused yes they are supposed to be in b and c and only b anc c and not type over a previous post. It shouldnt matter where the cursor is it automatically finds the first available row in b and posts the selection to b and c.
  19. striveforexcelence

    List boxes in Excel - User Form

    it seems that way but its not you try it i have tried that six people are then as "plain as the nose on my face" i screwed up the verbage cuz i have been explaining this all day i will change it and it will not be that simple thanks tho
  20. striveforexcelence

    List boxes in Excel - User Form

    im sorry now i screwed it up.....the products must appear in columns b and c

Part and Inventory Search

Back
Top