Search results for query: *

Thanks guys for the prompt response. Worked a treat. Steve

Hi All, I'm trying to work out if this is possible as all my current attempts at this have failed. I have written a query which shows me how many people have attended a course, one of the columns counts the number of people and returns the count correctly. Now another one of my fields holds...

Thanks, Worked a treat :) regards Steve

Hi All, I've trying to write a macro using VBA to find and replace a number of text strings which I've assigned to variables. The code essentially looks like this:- count = 0 Columns("X:X").Select For count = 1 To CorrectCount MsgBox count MsgBox CorrectCount MsgBox roleorig(count) MsgBox...

Hi All, I'm hoping somebody on here may be able to help me out. I'm making some changes to a workflow application that we've got, it's pretty basic stuff which I can handle via simple functions and alike. It's in Notes 7. I've come across a challenge tho, by creating a step in the workflow...

OK, I fixed it, I had a space in between Sheet and 1! aarrgghhhh, do you just love code! thanks to anybody that takes the time to read this. Steve

Hi Everybody, Hope somebody could point out what I'm doing wrong here. I'm trying to write a Macro which uses Excel Vlookup Function. The formula I'm assigning the cell is:- ActiveCell.Formula = "=VLOOKUP(A3,'[" & CoreFileName & Rolename(count) & "]Sheet 1'!" & UsrLstRange & ",2,FALSE)"...

Hi All, I'm new to using peoplesoft and i'm trying to run a query against the job table. I only want the query to look at the current row of data for each record, but I'm struggling as the query is returning results from all rows in the table for each record. Does anybody know how I can...

Hi, Wonder if anybody out there could help. I'm writing a simple @command to detach a file to a directory on the users windows workstation. I can get it to work if I specifiy a full path of where to save the file however as we're using a windows platform each user has it's own profile, I...

Hi, I'm looking for some help as so far I've been unable to do this. I've created a form in Word which has a number of check boxes. This form works fine once it's been locked, however I've now been asked to incorporate this onto an Excel spreadsheet. My problem is that in order for me to...

Hi All, Wonder if anybody can help me out with a bizare DNS problem I'm having. I've got two meeting rooms which both have a 5 port HUB in them, this then connects to my subnet and issues IP addresses in the same range and also gives out the same DNS servers. Now in the one room we have a...

Hi, Having a weird problem here and just wondered if anyone else has ever come across this. Im running Windows 2000 SP3, with IE6 SP1. Basically when you type the addy of a website, the status bar starts to load the site, then stops, the IE symbol in the top right hand corner is still...

Hi, We build and roll out a large number of Windows 2K Prof Machines using Ghost images. As part of this image we run the Norton Ghost Walker to generate a unique SID for the PC's in question based on their asset number. We've found that after a given period of time a number of these machines...

Funny you should mention ZA! I've just sorted the problem about 30 mins before your post came through. I have got ZA installed on the machine but I disabled it a couple of weeks ago. When I reenabled it and checked TraceRT was one of the apps that was denied access, gave it access and...

All, I can ping a server that i'm trying to connect to fine and it responds without a problem. However when I do a tracert on it, I get a failure:- 1 Transmit Error : Code 65 Any suggestions? Thanks

Could be a BIOS problem, i.e the BIOS isn't telling the machine to come back up correctly after the restart command is issued. Try downloading the latest BIOS and see what happens. Zulu

I know this may seem like a silly suggestion but try starting the PC in VGA Mode and try running word. I had a similiar problem once and it was related to the display driver. The driver installed by 2000 didn't like my graphics card. I had to get the latest one from the Vendors website. I...

I've seen this before in our enviroment, it's usually because the NETBIOS name has changed itself to something different to that of the PC name. Create yourself a local admin account, remove the machine from it's current domain membership, ensure that the NetBios name reflects the PC name and...

I'd be grateful if anyone could answer this question. I have a report based on a query, I'd like to be able to change the sort order of the report based on the criteria user selects on the form. The three sort options I have on the form are "Office", "Issue Reason" and...