Search results for query: *

Hi, Is there any way I can remain in context during an update to another table? The problem I'm having is that if I capture the current table I'm in to a variable, and then perform a USE statement, I immediatly leave the context of my current table for the new one. Now, if I do an EXECUTE...

Hi, I'm pretty new to actually doing something useful in SQL, so can someone shed some light on my problem. I need to change from my current database to the master database, execute some sp_addextendedproc statements, then return to the previous database. Thats it. I don't know the name of the...

Hi, I have an MDI window, which has a number of forms within it. If one of these forms calls a common dialog (for example to search for a file), and then decides while the common dialog is open to switch Applications (e.g. to Windows Explorer etc) and then switches back, the focus is lost on...

Hi, got a problem getting my hooking procedure to work and I'd be grateful for some pointers. Basically I want to send a custom message to another window, but currently, the hooking procedure (which is initializing and terminating fine) is not picking up any message(s) from the child window -...

Hi, I have a very simple database, containing two tables (each with 3 fields - 1 Primary Key, and two data fields). The datafields are of type: varchar(100), and: text respectively. I have created a new full text index on both tables through the wizard. However, when I run a query (super...

Right, This should be simple, but it's not - it's causing me endless grief. Basically, I have an ultra simple ASP page, and an ultra simple DLL with a single class. I have created an 'application' directory in IIS, and pathed it to my simple asp page. When I launch the ASP page, it instansiates...

Hi, Basically, let me set the scene, got a form with an embedded frame - now it has a textbox embedded into it - and I want to prevent the user being able to edit the contents without using textbox.disabled = true. Now, I understand *basically* how Win32 API works, and have implemented a...

Any idea how you distinguish between months and minutes with the format function? The only example in the offline msdn reference I could find seems to demonstrate that it's context sensitive, e.g. hh:mm:ss is time, where as dd\mm\yyyy is a date. But this does not always seem to work. Is there no...

Hi, How exactly do I implement a File, Edit etc bar at the top of my form? Is it a control? or is it something I enable on a form? - I can find no references on the net, or in MSDN, but thats probablly because I haven't a clue what such a control (assuming it is a control) is/would be...

Hi, I'm wondering how I poll for system messages from a 3rd party DLL?. Basically, I have a program which works out which files need to be added to a ZIP file, when it's worked it out - it passes to the ZIP compression library (XceedZIP) - which proceeds to zip the content. What I want to...

Hi, Is there a function by which you can determine if an array has been dimmed? Basically, I dim a global array as: Dim MyArray() As String Now in a function, if a certain string contains stuff, the contents is Split() into the array. Problem is, if I have nothing in the string, then the...

Hi, Basically, what I am trying to do is automatically serve a file to a user, so that when the html page reloads, the user is prompted to "save/open the file". However, the file to be served is created by an external DLL, which then writes it to a folder where the ASP website is stored, e.g...

Could someone explain what exactly a collection object is in the context of OO VB? I understand what classes do, but I don't quite understand what collections are. Could someone enlighten me? Thanks.

Hi, Any chance someone could tell me how I look for quote marks in a string - the obvious problem I'm having is that if you do Replace(MyString,""","0") Then it won't accept it, because it believes "" is one set of quotes, and the third is the opening of another string. What do I have to...

Hi, I'm looking for a way to get to the end of a text file, so I can read the last line in to extract some pertinent information. Unfortunatly, I can't read the entire text file into an an array and perform the operations in memory, because the textfiles contain 5-6 million lines -...

Hi, Could someone explain how using a binary operation, in this case AND is useful: If I take the binary for 11 and the binary for 13, and AND the results: 1101 (11) 1011 (13) ----- 1001 (9) - Is this TRUE or FALSE? What exactly does it acheive? I'm asking because a snippet of code I've...

Hi, I'm wondering, what values do you multiply by to convert an actual resolution value (in this case mouse pointer position co-ords 1024x768) to the windows, resolution independant screen co-ordinate system? Thanks

Hi, Wondering, how can you address a string as an array in Visual Basic? This is mainly because I want to test the contents of a string against an array containing permitted characters. I assumed, that like C, a string could be addressed as an array i.e. blah = "Hello" echo blah(0) --> "H", but...

Hi, I'm fairly new to Visual Basic (release 6) and having a bit of trouble with a tutorial I'm following - http://www.officecomputertraining.com/vbtutorial/tutpages/page42.asp - Basically, I'm unsure of what is going on here, and wondering if someone could just explain this specific hunk of...

Just wondering, is it possible to have an alert window come up and then dissappear after a certain number of seconds? I ask because I want to alert users when their lease on a record is about to expire, I use <meta refresh> to redirect them elsewhere when their lease does expire, but it'd be...