Recent content by helpmonny

I didn't have access to the Business Intelligence link before but have now added access to it and it shows a standard report called TimesheetActuals which shows me the data I want. it calls the column TimesheetLineActualWork which I couldn't see in any views but since I have it in the report...

thread913-1718983 Hi, I have implemented this project time reporting and it is working well for inputting the data. However, I cannot work out how to view the total time against a project after all the team have input their updates. I can only fine the work, actual work etc fields which don't...

Thanks for the reply Pascal. It's actually throwing the exception before this point. When I step throught the code and run the line: CallByName(NotesWorkspace, "EditDocument", CallType.Method, ParametersEditDoc) It runs and does open the new memo in edit mode with the address field populated...

I'm creating a new Notes mail message from .NET using the code below. It seems to work fine and creates a new memo and leaves it open in edit mode but if you are not a Lotus Notes Administrator, it also throws an exception at the end, even though it's worked fine? Any ideas why? Public...

Thanks SQLBill with a 'while' clause this works perfectly. DECLARE @updatenbr INT SET @updatenbr = 6 while exists (select * from mrrpay where code is null) begin UPDATE mrrpay SET code = @updatenbr WHERE ic = (SELECT MIN(ic) FROM mrrpay WHERE...

The missing numbers don't need to be accounted for. The groupfield column is just an id linking to another table so could be any number. The groupfield column could be anything really, it simply needs to be grouped and the updatefield is the important one which will be an integer incrementing...

I'm trying to write a stored procedure to update a field for all rows in a table. I need to pass in a starting value and update all rows for group1 and then increment it by one and update all rows for group2 and so on (the 'groupfield' values won't be in order either). Also, if the groupcount of...

Sorry Ed, you are right. I'll find the correct forum. Sorry for wasting your time.

Hi Ed, thanks for you reply. This doesn't resemble my code so it's maybe a different version. This is my code for a basic form and I want to filter the [f000]field automatically: database sfp screen size 24 by 80 { File Reference [f000 ] Enquiry Date...

I have already created a form which shows all records from a table. How do I change this to only show a subset of records e.g. where ref matches "SFP*" so the user doesn't have to filter themselves everytime as they are only interested in this subset of records.

I'm trying to add a button to a form to open a second form and display data for the related record (using the wizard). The linking field is called our_ref. However, the values in this field are like NL/1/2/4 and it doesn't seem to be able to link them, I'm assuming because of the '/'. How do I...

I did the F6 thing and it detected drives and installed drivers but still didn't work, but I downloaded a few diskArray drivers from the web and tried them all and one worked. You still have to do the F6 thing first and then specify an additional drive and use the downloaded drivers. Just...

I'm trying to reinstall NT4 on my ML370 server but the NT install will not recognise the drives? What do I do?

I have Domino 4.5 and my SMTP server should only accept connections for inbound mail from Demon. Unfortunately it now seems to accept a connection to spurious IP addresses e.g. 66. 212.162.90. It doesn't accept any data and the inbound session fails but I would like to erradicate any...

Thanks, I've upgraded to Advanced now and it's working fine.