Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. helpmonny

    Project level reporting

    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...
  2. helpmonny

    Project level reporting

    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...
  3. helpmonny

    Creating New Memo from .NET

    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...
  4. helpmonny

    Creating New Memo from .NET

    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...
  5. helpmonny

    Update a field with a counter incrementing after group by

    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...
  6. helpmonny

    Update a field with a counter incrementing after group by

    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...
  7. helpmonny

    Update a field with a counter incrementing after group by

    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...
  8. helpmonny

    Filter records to show in a form

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

    Filter records to show in a form

    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...
  10. helpmonny

    Filter records to show in a form

    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.
  11. helpmonny

    Linking forms when field contains "/"

    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...
  12. helpmonny

    OS install

    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...
  13. helpmonny

    OS install

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

    Unauthorised inbound connections

    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...
  15. helpmonny

    Backing up other NT servers

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

    Backing up other NT servers

    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?!
  17. helpmonny

    Upgrade Domino 4.5a to 5

    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...
  18. helpmonny

    Upgrade Domino 4.5a to 5

    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.
  19. helpmonny

    Upgrade Domino 4.5a to 5

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

    Upgrade Domino 4.5a to 5

    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...

Part and Inventory Search

Back
Top