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 Rhinorhino 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: *

  • Users: Rofeu
  • Content: Threads
  • Order by date
  1. Rofeu

    Framework 3.5 website not working properly under Windows7 64-bit

    Hello, I've been creating a website in VS08 with .NET framework 3.5 on a 32-bit machine running Windows Vista. Everything was working as expected. However, I've now gotten a new computer. This is 64-bit machine running Windows 7. When running the site in debug mode, there are several things...
  2. Rofeu

    CRM 4.0: Copy Customizable Entity

    Hello, we have a customizable entity Ticket (formerly Case), but I now have need of another entity that is very similar to Ticket. It would be very useful to take a copy of Ticket and customize that, but I've not been able to find any functionality to copy entities. I've tried exporting it...
  3. Rofeu

    Everything alright?

    I must have heard this phrase a thousand times, but this morning it struck me as odd: "Everything will be alright" Does the 'al' in alright not already cover the 'everything'? Should it not be either: a) Everything will be right. b) It will be alright. or c) All will be right. ? Cheers, Roel
  4. Rofeu

    Predict FileCopy Process Time

    Hello, I've some code that copies the content of a folder into another folder. However, the size can be quite large and I'd like to give the user an estimate of how long it will take beforehand. Now, it's easy enough to get the size of the folder via the filesystemobject, but I'm at a loss as...
  5. Rofeu

    suspended quotation mark insertion

    Hello, I'm sure this is something really simple, but I can't find it. Whenever I type a quotation mark (single and double) it doesn't show until I hit the next key. How do I disable this? Cheers, Roel
  6. Rofeu

    Connect to SQL Server from LN

    Hi, I hope some one can point me in the right direction here. I'd like to update a table on a SQL Server with data in a LN document, but I've no idea how to connect to it. I've read something about LN being able to connect with OLE DB, but how I'm to put that in code, I could not find...
  7. Rofeu

    MenuBar Control not finding Macro

    Hello, I've this file that programmatically creates a dropdown on the main menubar with a list of controls on it. Now, I'm setting the OnAction to macro's listed in a module. If I call this module Menu_Options and set the controls to run the macro's everything works fine, however if I change...
  8. Rofeu

    Connection Types

    Hello, I've set up an ADO connection to a SQLServer, but although it works great, I'm not really sure if it is the best approach to use. Even though I use ADO, it also lists OleDB in the connection string. Does this make it an OleDB connection then? I've only recently started to venture...
  9. Rofeu

    Change References to Type Library

    Hello, my code uses 2 type libraries from Lotus Notes. This is no problem as long as other people have the same version of Lotus Notes, but when they don't these libraries are not picked up. I've tried copying the libraries to another folder and setting the reference to these, but that doesn't...
  10. Rofeu

    SUMPRODUCT as Array formula

    Hello, I've created this array formula that puzzles me. {=SUMPRODUCT(INDEX(Support!R1C4:R6C5,MATCH(INDEX(Support!R1C1:R14C2,MATCH (LEFT(VSource!R2C1:R17219C1,2),Support!R1C1:R14C1,FALSE),2),Support!R1C4: R6C4,FALSE),2)*VSource!R2C13:R17219C13)} If I enter this over 2 or more cells, it gives...
  11. Rofeu

    SUMPRODUCT as Array formula

    Hello, I've created this array formula that puzzles me. {=SUMPRODUCT(INDEX(Support!R1C4:R6C5,MATCH(INDEX(Support!R1C1:R14C2,MATCH(LEFT(VSource!R2C1:R17219C1,2),Support!R1C1:R14C1,FALSE),2),Support!R1C4:R6C4,FALSE),2)*VSource!R2C13:R17219C13)} If I enter this over 2 or more cells, it gives me...
  12. Rofeu

    Unable to open NotesSession

    Hello, I'm using GetObject("", "Notes.NotesSession") to get an open session or open a new one when there isn't one. It all works fine when there's an open session, but when there isn't it fails. The strange thing is that on some PC's it works fine, but on others' it fails. It's not the vba that...
  13. Rofeu

    Get Attachment from RichTextItem

    Hello, I'm trying to get the first attachment from richtextitem x. I managed to get the names from all the attachments in the document, but my code fails when I try to get the attachments from only the richtextitem. How can I determine from which field the attachments are coming? I've the...
  14. Rofeu

    Adding Link Hotspot to email

    Hello, I'm compiling an email programmatically, but I want to add a link hotspot to an url. I can't seem to find the code to do that. Can someone point me in the right direction as to how to go about this? Cheers, Roel
  15. Rofeu

    Code Constantly Breaking

    Hello, I'm sure I'm just overlooking a setting or something simple like that, but I can't find it. I went from Excel 2000 to 2002 and all of a sudden code in my workbooks breaks for no apparent reason. There's no error and on clicking continue it just resumes only to break again after a few...
  16. Rofeu

    Update Query Syntax Error

    Hello, I'm trying to run an update query on an Excel sheet I have. Below is the SQL I'm running but it's giving me a syntax error and I can't find where I'm going wrong: SQL_Update_Source_OPP = "UPDATE `'OppTracking TAB Delimited-v2$'` A " SQL_Update_Source_OPP = SQL_Update_Source_OPP & "SET...
  17. Rofeu

    COUNT CHARS IN CELL

    Hello, in Excel is there a way to return the number of instances a character is present within a cell? i.e. how many comma's are in a cell. thanx for any suggestions. Cheers, Roel
  18. Rofeu

    BeforeSave Event Loop

    Hello, I've this beforesave event that basically blocks the file from use in case someone opens it with macro's disabled. after saving it returns the file to the state it was in when the user hit the save button. This works fine, but if you close the file through the X in the top right...
  19. Rofeu

    Field Properties?

    Hello, is there any way to test a field on a Lotus Notes form on the properties ReadOnly and Visible? Cheers, Roel
  20. Rofeu

    FTSearch Query with Hyphen

    Hi, I'm doing an FTSearch on a view. The query-string I'm looking for might contain a hyphen. The problem I'm having is as follows: "06-0*" works fine "06*" also works fine, but "06-*" doesn't return anything. How do compile my search-string so it'll pick up the documents that contain...

Part and Inventory Search

Back
Top