Oldstone Place

From http://www.databasejournal.com/features/msaccess/article.php/10895_3505836_2Public Public Function UpdateOrderInfoWebSite() As Long<br /> On Error Resume NextDim objDoc As SHDocVw.InternetExplorer<br /> Dim sURL As String<br /> Dim lOrderID As LonglOrderID = Forms!frmOrder!txtOrderID</p> <p>Const cURL As String ="http://localhost/Orders/Process.asp"<br /> sURL = cURL &#38; "?ID=" &#38; lOrderID<br /> sURL = sURL &#38; "&#38;SDate =" &#38; Forms!frmOrder!txtStatusDate<br /> sURL = sURL &#38; "&#38;SID [...]

My favorite method for executing SQL, be it saved queries or raw SQL, is the Execute method of the Database object. You can execute a statement with a single line, like this: [code] CurrentDb.Execute “UPDATE titles SET price = price * 1.10″ [/code] In this case, CurrentDB references the currently open database. Alternatively, you can [...]

Interested in learning C# or even .NET? The open source Ximian C# compiler is available for .NET and Linux at www.go-mono.com. Another free compiler is #develop with a full IDE for both C# and VB.NET at www.icsharpcode.net. With open source rivals like these, commercial C# producers like Microsoft and Borland face a stiff challenge, especially [...]