Search results for query: *

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.

I have ArcserveIT 6.61(834) Workgroup edition. When trying to backup other NT servers on my domain, I get the message N3905 Skip Node - Not supported in this edition. The release notes say I should be able to backup other servers, so are they wrong?!

We have 3 remote domino servers sending mail to a domino mail server at our HQ and it routes external mail from them and itself to a domino smtp server, then through a firewall to their destination. Names.nsf is 172Mb but I can't email it to you as mail isn't going out. Should the server...

I've checked and only have one foreign document. If R5 doesn't use smtp.box which mailbox does it use? And where do I specify the mailbox to transfer to from my other domain server.

I've checked and only have one foreign smpt document. If it doesn't use smtp.box, which mailbox does it use?

Thanks peterve, I followed the instructions and after the upgrade incoming mail is received and processed fine, but outgoing mail is simply queued in SMTP.box under pending conversion and stays there. Do I need to put an entry in the relay host section - I'm using a firewall proxy server? Any...