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 derfloh 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: TBOB
  • Order by date
  1. TBOB

    SystemTime in 24 hour format

    I'll give that a try. Thanks, Tony
  2. TBOB

    SystemTime in 24 hour format

    I'm trying to show UTC and local time in a 12 and 24 hour format. Im using the following code: Private Sub Timer1_Timer() GetSystemTime zt txt12.Text = Right(DateAdd("h", -5, Format(zt.wHour, "00") & ":" & Format(zt.wMinute, "00") & ":" & Format(zt.wSecond, "00")), 11) txt24.Text =...
  3. TBOB

    FormatCurrency Formatting

    Sorry, It's in a text string in an Excel macro. Tony
  4. TBOB

    FormatCurrency Formatting

    I have the following code in my module, FormatCurrency(Amount). This gets me the ($400.00) format for a negative balance like I want, but I want it to be red too. Anyway to do that? Thanks, Tony
  5. TBOB

    Add record with dynamically pre-defined field

    Rob, Let me try that one. I'll get back to you. Thanks, Tony
  6. TBOB

    Add record with dynamically pre-defined field

    Rob, Basically I want whoever was actually contacted to be the last person on the list next time and and the person that was next on the list to be first one tried next time. It is basically a rotating contact list, but it's not always going to be the next person. Stix, I'll look into DMAX...
  7. TBOB

    Add record with dynamically pre-defined field

    Sorry about that subject line, but this is a little trickier than what I could fit on there. Here's what I'm trying to do: I have a record that has 7 contacts. They are in order like this: Name Order Contacted Contact 1 1 Contact 2 2 Contact 3 3...
  8. TBOB

    Wired port won't work

    Will look at all these tips and get back to you. Tony
  9. TBOB

    Wired port won't work

    I'm experiencing kind of an odd problem. I have a laptop on a network. Using a wireless NIC with a static ip, the laptop works fine on the network. When I plug the wired NIC into the network with a different static ip and with the wireless removed, I don't get any connectivity. That is no...
    • TBOB
    • Thread
    • Replies: 5
    • Forum: TCP/IP
  10. TBOB

    Formatting Issue

    Remou, Your the man! That did it. Thanks, Tony
  11. TBOB

    Formatting Issue

    Trying to format the variable LINENUM with the following code: strLINETYPE = "W" strLINENUM = "1234567" Case 8 strLINENUM = Format(strLINENUM, "\A\B\C\D-" & strLINETYPE & "-@@@@@-@@") This is resulting with this: "ABCD-5-@@@@@-@@" Should be this: "ABCD-W-12345-67 I use this format...
  12. TBOB

    Order By Clause of Query

    Mike, Tried that and got the same result. Thanks, Tony
  13. TBOB

    Order By Clause of Query

    I'm using a function to create an SQL string to select records and order them correspondingly. I'm using the following code: strSELECT = "RCLSITES.*" strFROM = "RCLSITES" If LINKNUM = 5 Then strSQL = "SELECT " & strSELECT & ", RCLSITES.rcllink, RCLSITES.rclstation " strSQL = strSQL &...
  14. TBOB

    VPN Equipment/Software selection

    Bob, Looks like good info. I'll pursue this angle first. Thanks, Tony
  15. TBOB

    VPN Equipment/Software selection

    New to the VPN world. Have a basic understanding of what VPN is and is for. Trying to decide what equipment/software to purchase. Have only 1 user that needs to connect to pc at the home office at this time. Any advice, links, or comments to help guide me through this would be appreciated...
  16. TBOB

    BEFW11S4 & ZyXEL 660ME-61

    Just got DSL and trying to build my network behind a Linksys BEFW11S4 V4. Using the web configurator, in the WAN setup I change the mode to Bridge and use the RFC 1483 Encapsulation. I have also tried mimicking the steps for bridging the 645 modem via telnet. Both ways, I have changed the WAN...
  17. TBOB

    Conditional Formatting of Row

    Both items mentioned were required. Thanks for the help. Tony
  18. TBOB

    Conditional Formatting of Row

    I have a report that has 4 columns. One of the columns is the result of a check box in a form. What I'm trying to do is anytime the value of that text box in the report = -1 change the backcolor of the other three columns in that row. Here is what I have so far: Private Sub Detail_Format(Cancel...
  19. TBOB

    Formatting Problem

    Thank you. Tony
  20. TBOB

    Formatting Problem

    Remou, That did it. I'm plenty happy about that, but could you tell me why? Thanks, Tony

Part and Inventory Search

Back
Top