User Profile

Collapse

Profile Sidebar

Collapse
Matt Pegg
Matt Pegg
Last Activity: Mar 31 '08, 05:42 AM
Joined: Apr 18 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Matt Pegg
    started a topic ASP/Access Bizarre db results ?
    in ASP Classic

    ASP/Access Bizarre db results ?

    Hi all,

    I have a problem where I have a webpage accessing data in an MS Access database, but the results of a: set rs=conn.execute (sql_statement) appear to be cached somewhere..

    Its only a recent issue, and the page has been in use for quite a while now without a problem, and I haven't touched the db connection code.

    Now, however, I get results from the table as they were entered two days ago, not...
    See more | Go to post
    • Matt Pegg
      started a topic How do I disable a button if First Row of DataGridView selected ?
      in Visual Basic

      How do I disable a button if First Row of DataGridView selected ?

      Hi all,

      I want be able to enable and disable navigation buttons when on the first or
      last row of a DataGridView object.

      I have a populated DataGridView and two buttons - "First Row" and "Previous Row".
      If the user clicks "First Row", they are taken to the first row in the DataGridView via:

      Code:
      Private Sub btnFirstRecord_Click(...) 
' Move to first record
      ...
      See more | Go to post
      • Matt Pegg
        replied to SQL Help: Select distinct
        in Access
        Thanks for the response.

        Unfortunately in order to use GROUP BY, I need to iclude all of the fields selected in the GROUP BY clasue which defeats the purpose...

        ie. tried SELECT Column1, Column2, Column3, Column4 from Table_X GROUP BY Column2, Column3, Column4;

        but got "You tried to execute a query that does not include the specified expression "Column1" as part of an aggregate function....
        See more | Go to post

          Leave a comment:

        • Matt Pegg
          started a topic SQL Help: Select distinct
          in Access

          SQL Help: Select distinct

          Hi all,

          This I thought would be a relatively easy question, but after hunting around the net, I haven't been able to source an answer..

          I have a large table in Access with four fields.

          I would like to generate a result set that includes all four columns,
          but removes duplicates for the last 3 columns. eg:

          something like

          SELECT Column1, DISTINCT Column2, DISTINCT...
          See more | Go to post
          • Matt Pegg
            started a topic ASP Excel spreadsheet generation frustration
            in ASP Classic

            ASP Excel spreadsheet generation frustration

            Hi all,

            I'm trying to generate a simple Excel spreadsheet via ASP but I'm running in to trouble. Here's the code:

            <%
            response.AddHea der "Content-disposition", "attachment ; filename=test.x ls"
            response.AddHea der "Content-type:", "excel/ms-excel; name=test.xls"
            %>
            <table>
            <tr><td>01234 </td><td>abcde</td></tr>...
            See more | Go to post
            Last edited by jhardman; Apr 18 '07, 04:43 AM. Reason: removed email address
            No activity results to display
            Show More
            Working...