Search results for query: *

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

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

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

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

Thank you. Tony

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