Search results for query: *

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

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

I’m trying to format the value in a text field of a form. The underlying table has the field as text. Let’s say the input is 12345. I want to the resultant format result to look like this, ABCD-E-12345. I ‘m not using the format in the properties window of the text box because this is eventually...

I’m trying to group items in my report by systems. The problem is the field I’m using to group with stores the result of a lookup table. The report is in order by the IDNum of the lookup table (i.e.: 1-V, 10-B, 11-F, 15-A, 20-R, 21-H, 30-AL, 33-BE). What I would like it to do is sort by the...

I have a network with four computers on it. Two are wired into a WRT54G and the other two are are fed from a EZXS55W switch which is fed from the router. Three computers have WinXP Home and one has WinXP Pro. They are all DHCP and have the same IP range. The workgroup is the same for all...

I have a small network. 1 pc with XP Pro and 2 with XP Home. They are connected using a WRT54G. 2 are wireless, 1 is wired. They are all set to use the Router's DHCP server. They all get an IP in the same domain. They are all in the same workgroup with unique names. They all get to the Internet...

I would like to know if this is possible before I even start trying. What I want to do is take the result of a query, create(or use existing) tabbed pages to display one record on each page. So, if my query returns 12 records, then I would have 12 tabbed pages with the first record on page1...

I'm using one form to build an SQL string and then display those results on another form. That part is working fine. What I would like to do is to pass the selection criteria from that query to the new form to set certain properties. The original selection is based on one field only. How do I...

I'm building an SQL string based on a selection from an option group. When I look at the string in VBA it looks like this: "SELECT RCLSITES.*FROM RCLSITES WHERE rcllink = ZNY". The query doesn't run, but asks for a parameter. When I look at the query something has added brackets around [ZNY]. If...

I have a single ADSL connection for use in a Home Office (5 office terminals right now) with 3 separate home users. Right now, everyone is networked together using 2 Linksys switches. What I need to accomplish is to separate the home users from the office users, but share the Internet...

I'm trying to go DSL Router --> Linksys EZXS55W Switch --> Linksys BEFW11S4 (via a crossover cable to port 1) to then utilize the WAP. I've been able to get internet connectivity when hardwired into the BEFW11S4 (port 4). I have wireless connectivity to my laptop, but not internet connectivity...

I'm trying to build an SQL string via a criteria form that finds a record. I build the string using the following code located in the code module for the form: Function BuildSQLString(strSQL As String) As Boolean Dim strSELECT As String Dim strFROM As String Dim strWHERE As String strSELECT =...

Have a network with 1 98SE machine, 1 XP machine, and 2 ME machines. All connected on a switch. Good physical connectivity. The problem is the 2 ME machines. One can see the workgroup, but I can not get it to access the Internet. It keeps displaying 'the page cannot be displayed'. The other ME...