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 =...
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,
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...
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...
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...
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 &...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.