Posts by john.knapp

str = Left(str, str.length -4)

The solution that comes to mind immediately is to host the database on an internet accessible machine, and set your Data Connection accordingly. Another possibility is to script the database objects and run that script on each new machine (you would also have to run it again when you alter the database objects).

So when I attempted to tag an untagged article, I received a message about not having permission to delete existing tags - of which there were none....

Is this a feature or by design?

Thanks,
JK

Rough diagram of db to record stats, see attached

IE issue apparently - able to post just fine from Chrome

Bear with me, I'm working up a demo project - I had a long post I had been writing as well, but apparently lost it during the day...

If you're all set, mark the thread as solved.
Thanks

I built and ran the app, none of my response times were more than 2-3 seconds at most - with the "usual" response time being 300-700 milliseconds. I've added a label to the form to show the response time, see attached.

This has already been done, and even with 'www.downforeveryoneorjustme.com'. Click Here to see the thread.

By the way, I did a Google search using "vb.net check if website is down" and that was the first hit...

Google has a custom search API, Click Here for the overview.

What are your specific requirements?
How many websites do you need to be able to view?
How much of each website do you need to "block"?
Is this for a class project, just killing time, or what?

Maybe I'm not understanding your requirements, but if your Gr_No is already an int value; just add up all the int values and divide by the total number of values - that will give you the average value - then just display that value (and/or update your Obtained_Marks field).

Codeproject has a webservices intro, with a client-side console application to consume it.
Click Here to view the article.

I would look at the ASP.Net membership web project for ideas, you may even be able to use that project plus SQLExpress as your membership platform, and have to code only the particulars for specific fields/properties/methods applicable to your unique requirements.

In other words, how much do you have to write from scratch?

The Microsoft.Office.Interop.Word namespace is documented on MSDN for Word 2003 and Word 2010 only, so apparently not distributed with any other versions of Office. That said, the Interop assemblies are available for redistribution. The assemblies for Office 2010 are found here: Click Here, I have no idea what will happen if you install and reference those assemblies on a system that has Word 2007 installed, and whatever code you write would have to be isolated by version and tested on a specific basis.

HKLM\Word.Application.CurVer also has the version number on my system (Office 2010), but I don't know whether that key exists in any/all other versions.

Again, it would be helpful to know what versions you need to support.

Couldn't you check the version and then conditionally branch from there? I found an example here: Click Here. Some sample code to look at might be helpful... By the way, what versions are you trying to support? The original post states Word 2008 and Word 2010, but Word 2008 is in Office 2008 for Mac only as far as I know.

Also, in the original post, I stated line 61 as the point where I would get the access violation - after formatting and edits, that became line 68.

Solved! The API function returns the buffer length required in TCHARs, I needed to double that length requirement to get the byte count required for my pointer.

Hello all. I'm using an API function via PInvoke, with the interesting data being returned to a pointer. My application crashes when attempting to free the pointer. If run with no breakpoints, the application hangs on Line 61 below. After the first run, it will then throw a memory exception whether run at full speed or stepping through.
Please look over the code below and point me in the right direction.
Thanks!

Imports System.Runtime.InteropServices

Module Module1
    Partial Public Class PInvoke

       ' Have to use Pointer to return pathnames
       ' StringBuilder only returns first NULL-terminated string
        <DllImportAttribute("kernel32.dll", SetLastError:=True, CharSet:=CharSet.Unicode, _
                            EntryPoint:="GetVolumePathNamesForVolumeNameW")> _
        Public Shared Function _
            GetMountPointsPtr(<[In]()> <MarshalAs(UnmanagedType.LPTStr)> _
                           ByVal sVolumeName As String, _
                            ByVal lpBuffer As IntPtr, _
                            ByVal uintBufferLen As UInteger, _
                            <Out()> ByRef uintReturnLen As UInteger) _
                            As <MarshalAs(UnmanagedType.Bool)> Boolean
        End Function
    End Class

Sub Main()
    ListMountPoints()
End Sub

' if no Volume GUID passed to sub, use the one corresponding to my USB stick
Private Sub ListMountPoints(Optional strVolumeName As String = _
                                    "\\?\Volume{9a615499-414c-11e0-bd72-78e7d1722cbc}\")

    Try
        Dim uintBufferLen As UInteger = CUInt(IntPtr.Size)
        Dim uintRequiredBufferLen As UInteger = 0
        Dim Win32ErrVal As Integer = 0
        Dim lpBuffer As IntPtr = Marshal.AllocHGlobal(IntPtr.Size)

        ' call function to get Required Buffer Length first
        PInvoke.GetMountPointsPtr(strVolumeName, lpBuffer, uintBufferLen, uintRequiredBufferLen)

        Win32ErrVal = Marshal.GetLastWin32Error()
        If Win32ErrVal = 234 Then
            'expected return value (ERROR_MORE_DATA), as our initial buffer is not large enough
        ElseIf Win32ErrVal = 2 Then
            ' oops
            MsgBox("File not found, invalid volume specified?")
            Exit Sub
        Else
            Throw New ApplicationException("Exception getting required buffer size …