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 bkrike 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: peterd51
  • Content: Threads
  • Order by date
  1. peterd51

    VB5 to OOo Calc set decimal places in cell

    Hi, I'm trying to set a cell to show numbers to two decimal places and I've found various bits of code around but nothing works for me. I currently have: Dim oCell As Object Set oCell = oSheet.getCellByPosition(1, 1) Call oCell.setvalue(1000) Dim NumberFormats As Object Dim...
  2. peterd51

    Insert cells in OpenOffice Calc from VB

    Hi, I'm looking at Open Office (v4.1.5) and accessing Calc (=Excel) from VB. Specifically VB5 but I hope I can convert any suggestions made for VB.net, etc. I've played around with a few things for a few days, checked online, nothing seems to work. Dim URL As String Dim oSM As Object...
  3. peterd51

    HTML External Links Fail

    Hi, I have in my <body> an external link and when I click on it, the URL changes to 'my web page' plus the one I'm trying to get to. For example... <A HREF="http://www.tek-tips.com">Click here to visit Tek-Tips.com!</A> Would show 'www.mypage/http://www.tek-tips.com' and get an error 404...
  4. peterd51

    CM3.3 to Unity 4.0

    Hi, we have a hundred+ users who have VM working OK... spare 'licences' available... but any new users that are set up now aren't working. When the call goes to Unity the caller gets a string of messages one after the other: 'sorry 'extension' not available, please leave a message after the...
  5. peterd51

    can VB5 use IE8 as it's browser?

    Hi, using XP and VB5... I've had a few 'trojan' warnings popping up for a while so I re-formatted my C: drive and re-installed everything. Windows Automatic Updates installed IE8 and my browser program that I've run in the IDE for a year or two stopped working. After I re-installed IE6 I got...
  6. peterd51

    Excel search error

    Hi, I pick up a name from sheet one, switch to sheet two and search for the name. I then copy data from alongside the name and paste it back into sheet one. No problem until it doesn't find the name on sheet two where it crashed. So I added error checking but now it works OK until the first...
  7. peterd51

    browser asking for 'with - end with'

    Hi, this is odd in that I've been using a simple browser code for years but now it suddenly started telling me I have to use 'with'...and TBH I wouldn't know where to start with that. <code> Private Sub Form_Load() <Set up> do Go1 = "no" Timer1.Interval = 3000 '3 seconds...
  8. peterd51

    VB5 MSFlexgrid re-display from row 0

    Hi, background: I'm using a flexgrid in VB5 to diplay names and data in multiple columns. Some of the figures have dollars, pounds (sterling) or euro symbols so a straight 'sort' doesn't work correctly. It works Ok if I copy the 'sort' column to another hidden grid with a second column holding...
  9. peterd51

    display data in columns

    Hi, I have some data, held on the hard-drive in a .csv file. At start-up I read this in to an array and when the user hits a command button I want to show the data in a grid or tabulated screen that the user can scroll up and down and select one item at a time. I've poked around with this for...
  10. peterd51

    find the .exe folder in VB5

    Hi, sorry this is such a simple question but I've had an hour searching here and not found an answer. How would I find the folder that the program is running in? For instance, one user might put the .exe on the c-drive while another puts it in their 'documents', and for this particular...
  11. peterd51

    Excel VBA command button

    Hi, I can create a button in Excel and add a macro to it... next I want to have 'up' and 'down' arrows that the user can click on and it'll toggle a search on that column, then replace the existing arrow with the other one for next time. I can do the search OK, it's changing the arrow that...
  12. peterd51

    Excel VBA create command button

    Hi, I can create a button in Excel and add a macro to it... next I want to have 'up' and 'down' arrows that the user can click on and it'll toggle a search on that column, then replace the existing arrow with the other one for next time. I can do the search OK, it's changing the picture that...
  13. peterd51

    How to find a folder with VB5

    Hi, I'm looking to store a temporary file on a users PC that can keep info, such as the last file that they looked at. The idea is that it'll start from that point when the user next runs the .exe. I'm thinking of placing this file in the temp, or maybe the cookies, folder. How do I check...
  14. peterd51

    Pass column &amp; line co-ordinates to Excel

    Hi, I have a macro and currently it works on fixed lines and columns... what I would like to do is set it up so a user could highlight the block of lines and columns desired and then run the macro on that block. Can't seem to find the right search words to see anything previously asked. Any...
  15. peterd51

    VB5 IDE mouse scroll not working

    Hi, sorry if this isn't a VB problem but I have no idea what the cause is... I can use the mouse scroll button to move the screen up/down in every program/screen (MS Word, etc, even on this screen!) except when I'm looking at a VB code listing. I get the same problem on my desktop PC and on...
  16. peterd51

    Acceptable number of ATM drops

    Hi, what's an acceptable percentage or ratio, ie 1 per million packets, of output drops on an ATM circuit please? For instance, since clearing the counters 21 hours ago I see 31498 output drops in 27631462 packets out. The only info I can find on output drops is a general 100 maximum in any...
  17. peterd51

    Ethernet port collisions

    Hi, I need a pointer on this as I'm not exactly sure if it's 'normal' or not... we have a Cisco switch directly connected to a Cisco router and the only available port on the router is an Ethernet 10 Meg. The config on each port is set to 10 Meg 1/2 duplex and we're seeing massive ammounts of...
  18. peterd51

    mrtg (checking a cisco switch to keep on topic)

    Hi, I've set up mrtg for the first time, and it works! I can see the traffic on the switch ports... but when it displays the graph it's from right to left, ie, the new data is added to the left hand edge. Is there an easy way to turn this arround so the new data is added to the right hand...
  19. peterd51

    change ADSL modem to Router

    Hi, I have XP sp2, with a USB ADSL modem. When I click on IE or Mail it dials up an ADSL connection. I've bought a USB/Ethernet router, loaded the drivers and the PC starts it up as a 'network connection', gets a DHCP address and then flashes the 'data' light... the network connection shows...
  20. peterd51

    error in BSCI book?

    Hi, in index C, talking about access lists, it states in a table: Address Wildcard Mask What It Matches 172.16.8.0/21 0.0.7.255 Any host on subnet 172.16.8.0/21 but with this subnet mask, doesn't it also match any host is the subnets .9.0 to .15.0 ? Or have it got this completely...

Part and Inventory Search

Back
Top