Recent content by ensorg

Hi Brent, Do you mean I should have my pool of address as something like 192.168.1.x? If I do this would I still be able to access network resources on 192.84.7.x? Thanks

Hi, I have a cisco pix 501 firewall. I have configured a Remote access VPN using the wizard in the PDM. When I attempted to connect the client connects sucessfully but I cannot ping anything on the remote network. I have a Netgear router on 192.168.0.1 this is set so the DMZ is the pix outside...

PHV, apologies, I looked at it quickly and thought it didn't work, but after taking my time and looking at it again it does work perfectly. Thank you.

Stongm, That works perfectly. Thank you.

Hi All, I have a bit of VBA code to format a date into a year and week number format... intweekstartn = Format(datestart, "yyyyww", 2) So today would be 200627 The problem is if the week number is a single digit then it drops the leading zero, so it is returned as 20061 and not 200601. This...

Hi All, Quick question. I have a PIX 501 that is currently being used to connect to another PIX in a site to site VPN. Is it possible to set up a remote access VPN (so that I can connect using the Cisco VPN client) on the same PIX? Would the two VPNs be able to run simulateneously? Thanks

Hi All, I hope you can tolerate a newbie asking probably really simply and obvious questions!! We are looking to purchase a Dell PowerVault 725N NAS appliance. My questions are below 1/ We currently run a NT 4.0 server, will this NAS server be able to get the usernames from NT4.0 so that we...

Ah OK, thanks, I'll give that a go.

It all becomes clear now! Thanks again for your help. I tried to do it that way because I didn't want a button. I just wanted them to enter the part number and hit enter for the code to execute. Is there anyway to do this? Or am I barking up the wrong tree and should just go back to using a...

Fine, I apoligise for not knowing that. Thanks for your help.

Here is all my code. Like I said maybe I am confused and not using a function correctly. Public Function part(partnumber As String) 'Function is called when partnumber field changes. If partnumber = "" Then MsgBox "No part entered" Exit Function End If With...

sorry, but I am confused. Part is not a variable, but it is the name of the function, why would I assign the name of the function a value?

Sorry maybe I mis-understood. The command button method gets the partnumber in a very simple way partnumber = activecell.value As I said, this works fine, but this is not the way I want to do it. When I call the function as such... =part(c16) Then it does not work. I cannot figure out...

I know it doesn't return anything, like I said its a simplified version. The problem is when I call the function via code then the find section works but when I call it from a cell =part(c16) then the find section doesn't find anything, even though what is being passed to the function is...

Hi All, I have a small VBA function in one of my excel spreadsheets (a simple version of it is pasted below. I pass a part number to this function and it runs through another sheet and collects all instances of this part number. If I call the procedure via a command button..... call...