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...
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...
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
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.