Recent content by jatkinson

Thanks PHV, thats great!

Yep, that does it!!! If I pad it out at the front to make 16 characters it works!! Thanks for the pointer! Next question then, is it possible, to code the query so I can strip the extra characters out and just type in the numbers I want to search by rather than padding it out into the query?

Hi, That didn't seem to work either. Interestingly I thought of using LIKE so I played with various but couldn't get that to work. The only result that gave anything was the following WHERE tablename.fieldname LIKE '%1-00001' but that then gave me entries for 1-00001 11-00001 21-00001...

Aah, I see what you're saying I'll give that a whirl! Cheers.

Hi, I did think of that and used: WHERE tablename.fieldname = '12345-00001' That simply returned no entries even though I can see the value clear as day in the open table. Hence a newbie getting confused! ;o)

For example I want to search for an entry with the value 12345-00001 so I used the following: WHERE tablename.fieldname = 12345-00001

Hi, First of all let me apologise if I'm in the wrong place and for the naivity of my question, I'm new to SQL queries etc, so please do point me in the right direction of the correct forum if this isn't right. Basically, a product we use stores records into a field in the format 12345-12345...

Thanks Guys for confirming my suspicions. I'm going to have to rework this on computer groups. I could push the software out to every PC on the domain but after testing it specifically on my PC it took more than 30 mins to install at start-up! (pretty certain something wrong there!) so I wan't...

Hi Steve, I'm thinking down the same lines as you and that is when I started getting confused. Like you it doesn't make sense to me logically to configure this way but this is how it's been explained and taught to me. I want to run the policy at computer level so it is installed prior to...

Yep, tried that..no problem with users access rights. Thanks for your post though.

Hi all, It's been a while since I've used Group Policies and I thought what I wanted to do was simple enough, however it doesn't seem to be working and I can't figure out why, which is now confusing me even more!! Basically, I want to install a piece of software via a policy to a specific...

Yeah, that is what I'm going to do, I was just looking to find a solution with the kit I had available at the time. Cheers.

Simply because they are in a different room to my Client devices and I cannot cable through the rooms due to layout issues.

Hi all, Any pointers on how I can connect part of my LAN which is wired to a wireless part? Specifically, all my devices connect to a wireless AP, including one of my servers (DC) in my home 'office' room, the other server is a DC too and is wired via a switch to the DC with the wireless card...

name resolution seems spot on, problem seems to lie with the wireless connection not being up whilst a user is not logged in ?