Recent content by TBOB

I'll give that a try. Thanks, Tony

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

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

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

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

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

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

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

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

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

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

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

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

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

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