Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: Datagrid Population

    Option Explicit

    Dim conProject As ADODB.Connection
    Dim rsProject As ADODB.Recordset

    Private Sub Form Load
    Set conProject = New ADODB.Connection
    Set rsProject = New ADODB.Recordset

    conProject.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Persist Security Info =False;Data Source =" & App.Path & _
    "\OSD.mdb;Mode = readwrite"
    conProject.Open


    I have a text box named txtstartdate and one named txtenddate
    A commit button named cmdCommit

    What I need to do is populate a datagrid called datagrid1 where a project has a start date or an end date between those dates.

    The database is called OSD.mdb
    The table is Project

    I would like to return everything at first in the sql statement to see can I populate it.

    Any help would be appreciated

  2. #2
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147
    yup!, use the "between" query.
    Give me a place to code and i shall move the earth!

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    yeah but i actually don't know how to set up the data grid loop.
    if anyone could show how to make a datagrid dynamically update for all records in the project table then I can alter the select statement meself.
    thanks

  4. #4
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147
    can u please be more specific about ur question? does your datagrid already displays records? little that i know that once you've edited a record in a datagrid, records in table will be updated simultaneously, and also what is the loop thing?
    Give me a place to code and i shall move the earth!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •