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

  • Users: HansD
  • Order by date
  1. HansD

    custom controls for embedded player

    Hello everybody I have a question: I have a website where you can listen to radio stations. You click on the logo of the station and the radio starts playing. Everything works in IE but not in FireFox Is it possible to make custom controls that also work in firefox: stop, play, mute...
  2. HansD

    automate copy, paste from htm to excel

    hey guys Sorry that I react so late but I have been away for a few days. Thanks for your reactions. I have now programmed it with the sendkeys function. just open site send "ctrl select" and then "ctrl copy". It works but after the copy the pc freezes for about 3 minuts and then goes on. It...
  3. HansD

    automate copy, paste from htm to excel

    The data is not coming from Access, but comes from a ASP website. With Access I already have automated to go to the site, enter password, open correct page and save that page to my computer. Because I need to organize the data before it goes back to Access I am using Excel. Thats easier because...
  4. HansD

    automate copy, paste from htm to excel

    thanks for the fast reply, I don't know this program. I am not sure if I can use that. I need a macro that does the trick, because after the copy and paste the macro continious the sort the data and then imports it back into my Access Database
  5. HansD

    automate copy, paste from htm to excel

    Hello Everybody I hope someone can help me, because i am going crazy. Our reseller has a pricelist on his website and I need that data in my access database. The data needs to be sorted first and I am using Excel for that. From Access I downloaded the pricelist ( which is a ASP site) from a...
  6. HansD

    Combobox to combobox

    Tnx for your reaction TheAceMan1. I will try it tommorrow because i have to go now. I will let you know how it worked out Hans
  7. HansD

    Combobox to combobox

    hello everybody I have a small question: i have a form with a subform on the main form i have a combobox(Cbo1) on the child form i have a combobox(Cbo2)and a button now i want to pass the data from Cbo2 to Cbo1 when i press the button, the comboboxes should be exactly the same Tnx Hans
  8. HansD

    copy part of Excel cell to other cell

    That's stange, when i delete the space after the articlenumber and put it there again, your code works there is something else (OH NO NOT SOMETHING ELSE!!!...sorry) your code deletes the spaces in the article description Sorry about all my questions, but you are really helping me good Hans
  9. HansD

    copy part of Excel cell to other cell

    Could this be the problem: There is something missing in the code you publiced in your first reply Dim s As Range, i As Byte, t As String, a I think there must be something behind the a Hans
  10. HansD

    copy part of Excel cell to other cell

    There is a space. This is an example of a sentence: 11005 SUNBEAM HDS 5.25" HDD 3.5" SILENCER RACK-- 8.55 after i run the code i get: cell 1: 11005 SUNBEAM cell 2: HDS 5.25" HDD 3.5" SILENCER RACK-- cell 3: 8.55 By the way, is it possible to lose the -- at the end of the articlename. The...
  11. HansD

    copy part of Excel cell to other cell

    Hey I am glad that you reply so fast, thanks But the 1,2&3 are good When you change those to 0,1&2 the first case overwrites the original data. i need to split the sentece in three cells articlenumber, article and prize Your code is great but I really don't understand it (hahaha)so i don't...
  12. HansD

    copy part of Excel cell to other cell

    It is a really good code, I thought it was going to be much longer GOOD WORK!!! Only one thing goes wrong: 121212 name of the article 12,00 cell 1: 121212 name cell 2: of the article cell 3: 12,00 cell 1 goes to the second space
  13. HansD

    copy part of Excel cell to other cell

    Thanks man I am going to try it out I will let you know if it works
  14. HansD

    copy part of Excel cell to other cell

    Hey Skip Thanks for your really fast reply. The first is until now still 6 characters, but the last is a price it can also be 123,00 or 1100,00 Hans
  15. HansD

    copy part of Excel cell to other cell

    Hey People i've got a little problem with sorting data I need to import a lot of data from a internetsite in excel a cell looks like this: 121212 name of the article 12,00 I need to split this in three cells cell 1: 121212 cell 2: name of the article cell 3: 12,00 I really hope somebody can...
  16. HansD

    help with js menu and frames

    Thanks for your reply Sorry that i posted the code wrong, I didn't know that. but........you learn from your mistakes I have allready found another solution. I am using a code i found on a internet site. I am not at home now so i don't know what the name was. Thanks
  17. HansD

    help with js menu and frames

    hey everybody I have downloaded script for a menu. It works perfectly but when i click on the menuitem it opens a new windows. I want it to open the page in a frame called "main". Is there anybody who can help me???? here is the script (fw_menu.js): function Menu(label, mw, mh...
  18. HansD

    sSQL string -> Table

    Tnx for the really fast answer When i change the string the way you said i get the error: "The query cannot be used as a rowsource"
  19. HansD

    sSQL string -> Table

    Hey Everybody I've got another question: I have the following string in a searchform. It puts the results in a Query and it works perfect. But is it possible to ut the results in a Table (Tbl_Results) instead of a Query. Thanks Hans sSQL = "SELECT [Tbl_Adres_AdresID], [naam]...
  20. HansD

    Search field (loop through 10 fields in query)

    Hey DougP Thanks for your reply. You really helped me on the way I have it to work now Thanks man Hans

Part and Inventory Search

Back
Top