Search results for query: *

What 'reference' do I need to include to access the 'System.Windows.Media.Imaging' namespace? I'm using VS express 2013, and want to access\edit jpeg metadata. From what I can find, it looks like the best way is by using the classes 'JpegBitmapDecoder', 'BitmapImage', etc from the...

How do I get the desktop to refresh? I've drawn some graphics on the screen by doing: Using gr As Graphics = Graphics.FromHwnd(GetDesktopWindow()) gr.DrawString("text", New Font("Arial", 20), Brushes.Green, New Point(50, 100)) gr.DrawImage(New...

Fantastic, thanks! "We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the Internet, we know this is not true." -- Robert Wilensky

After a reinstall/rebuild I've lost a file I thought was called "Win32.tlb", it provided a type library for "referencing" which provided a huge number of win32 API declare functions, subs, types & constants, so theyd appear in the object browser making writing code much easier! Think it came...

works a treat! - thanks "We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the Internet, we know this is not true." -- Robert Wilensky

Thanks strongm, that looks brilliant, and so simple - I'm embarrassed! sorry for being thick, but how do I reference Shell32? thanks G "We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the Internet...

I need to be able to read an image's dimensions in VB6, but am struggling with the GIF format. Its easy to do for a bitmap by directly reading the image header part of the file, and can do similar for a JPEG with the help of Intel's JPEG Library. From code that writes GIF it appears that an...

thanks Strongm, that works a treat! "We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the Internet, we know this is not true." -- Robert Wilensky

This must be really easy to do(!) but I just cant get it to work!! I want to grab the current active visible form (a regular VB form I've created), controls and all, as an image so I can shove it in a picture box an another form. I've found lots of code for grabbing the entire desktop, but I...

Is there a quick way of getting the maximum or minimum of some columns? ie. say I want to select the maximum of two columns I can write it as: SELECT (CASE WHEN COL1>COL2 THEN COL1 ELSE COL2 END) AS RESULT FROM etc... Obviously the MAX function doesn't do this, ie SELECT MAX(COL1,COL2) AS...

that works, thanks PHV. I'm really embarrassed..... ;-)

I've got this bit of code in a VBA module: Sub test() Dim c As ADODB.Connection Dim m As ADODB.Command Dim r As ADODB.Recordset Set c = New ADODB.Connection With c .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb;User Id=Admin;Password="...

oops, MS access likes #mm/dd/yyyy# so Christmas would be #12/25/2005#... what db provider are you using?

different db platforms like their dates in different formats, eg MS access SQL likes #25/12/2005#, oracle sql likes '25dec2005'. the way to write the date in the sql is independent of how the column may be formatted when the table's displayed. hope this helps

I'm building an application in VB6 on NT4 using the ADO (MDAC version 2.7) to pull data from a MS Access 97 DB. The provider string im using is "Microsoft.Jet.OLEDB.4.0". When I open the connection it works fine on some machines here but on others I'm getting the errors: "3706 - ADO could not...

Wow, thanks Bogdan - that works a treat! I feel rather silly now...

Thanks Chris, Ive tried ClearFields and ClearSelCols in different parts of the code but it doesnt seem to have any effect. Is there another way of clearing it that I'm missing? ta

Im having real trouble getting a DataGrid to refresh after updating the ResordSource of a bound DataControl. I have a DataControl, DataGrid, TextBox and CommandButton on a form. This bit of code works OK when it is first run: Private Sub cmdRun_Click() With adodcSQL...

I'm new to ADO Data Controls having trouble writing a connection string to use. In the open code: Set c = New ADODB.Connection c.ConnectionString = "Driver={Microsoft ODBC for Oracle}; Server=myServ.world; Uid=myID;Pwd=myPWD;" the connection string above works fine. But when I try to...

Brian Ignore me - sas/connect would be required on the client to connect to a server - I can see from the setinit above that this isnt present. sorry