Search results for query: *

DNS is resolving properly, we ping by name not by IP. I agree that a situation with fewer routers would be more ideal but this is the way things were done to get other things running properly in the office before I started working here. I'd like to rework all the systems now into a better...

I originally posted this in the "DNS/BIND/DHCP/WINS Issues" forum but had no answer for several days so I tried to post here. I have since had some help from that forum but the issue is not yet resolved, mostly because I am having trouble getting the go ahead from my boss to proceed with the...

Just modify that one. If you need more fields then add more lines to get them string newCell string newVal strfmt newCell "%s%d%s%d" "R" Ro "C" x Dderequest LinkVar newCell newVal x is the column number where the new info is in. To figure out how to do the rest just use the recorder to...

I just stumbled upon another script from the author of the one I used to create the one above. It's "Mark D. MacLachlan , The Spider's Parlor" who is markdmac here on TekTips David I. Taylor A+, Network+, MCP Windows XP

I have one that will out them from an excel file. As is, it starts on the second row (so you can have a header row) and then stops but you can change the first line "integer Ro =" to whatever row you want to start on and the begining on the loop "while Ro <" to the first row you want to NOT out...

I just realized you can do it for a dynamic gap if you use offset and find the starting cells for each range earlier in the code. Dim startJ as Range, startK as Range 'some set of code to find the appropriate cells. Counter = 0 Do While Counter < LNum startK.Offset(Counter, 0).Value = _...

Why not do it all in one loop instead of a nested one? something to the effect of Counter = 2 Do While Counter < LNum Sheets("Data").Cells(56 + Counter, 11).Value = _ Sheets("Data").Cells(Counter, 10).Value Counter = Counter + 1 Loop This assumes that you want to start the...

It seems that the RouteFinder's firmware is not up to date. We're going to try updating it and see what happens. David I. Taylor A+, Network+, MCP Windows XP

I've checked the RouteFinder and all of the configuration appears the same as on the Windows server as far as routing goes. There are no packet filtering rules associated with the subnets involved and all other traffic appears unaffected. I can see about having the router restarted tonight...

We are having an interesting issue in our office. We use two gateways on the same segment depending on the department for which the computer is used; one is a Windows Server 2003 system running routing and remote access. The other is a RouteFinder "network appliance". When trying to connect to...

If the three are all equivalent; why does one give an error and the other works fine. I'm just confused, if it works it works but it may be good to know in the future. David I. Taylor A+, Network+, MCP Windows XP

That seems to have fixed it. Is there a reason that Cells(4,10).Value is any different than Range("J4").Value or it's supposed equivalent [J4].Value? Now I'm going to have to go through all my code and change it to Cells to make sure I don't run into that again! David I. Taylor A+, Network+...

I don't get any tool tips from the line and if I right click and choose definition it says "Identifier under cursor not recognized". If I step through the code from there it skips completely out of the sub back up to the command button that called it and the unload statement which follows...

Stil getting the same results, break point activates when it reaches that line, I press continue and the cell doesn't get updated nor does the following break point trigger. David I. Taylor A+, Network+, MCP Windows XP

Sorry for the double post, got too busy talking about the code I forget to ask what you meant by "Modal Userforms" PHV and how I would distinguish them from other types? All I did to create the forms was go into the VB Editory and click "new userform" David I. Taylor A+, Network+, MCP Windows XP

Not only did using Me.Hide fail to fix the problem but as you say the sheets remained in memory and the next time I called them the old values were in place. Sorry it took me so long to listen to you about the break points... I'm editing with the built in VBA editor from office and only just...

Thanks for the idea Roel, but that's a no go either. I replaced every instance of Unload Me in the project with Me.Hide and still the main form is being closed as soon as I'm finished with the first secondary form it loads. David I. Taylor A+, Network+, MCP Windows XP

We are having an interesting issue in our office. We use two gateways on the same segment depending on what department the computer is meant for; one is a Windows Server 2003 system running routing and remote access. The other is a RouteFinder network appliance. When trying to connect to the...

Is the picture in the same cell as the movie title or in the cell beside it? If it's in an adjacent cell you could try highlighting both columns before choosing to sort. I'm still using 2003 so I can't say this will work for sure. David I. Taylor A+, Network+, MCP Windows XP

The first way would be to simply not allow anyone other than the IT department to have power user or administrative rights to their local machines. This will prevent them from installing anything. The next would be to put a GPO in place with a software restriction rule that prevents any of the...