Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Identify New Data on new record (multiple fields) to existing reco

Discussion in 'Information Technology' started by Jen, Jul 28, 2006.

  1. Jen

    Jen
    Expand Collapse
    Guest

    I receive 2 monthly files on members that contain like 50 fields of data.
    Each record indicates either New, Change or Term. So 1 member could have
    multiple records coming on every file.
    On a Change record, what I need to do is when I receive a record on a member
    that already exists in my table, I want to check about 10 fields of data to
    determine what the Change is.

    I am looking for someone to suggest where I start with this. I know it can
    be done. I am a fairly experienced user; just looking for some help getting
    started. I am assuming this will require some programming, which is great if
    anyone has any suggestions.

    The database is '97.
    THANKS!!
     
  2. Loading...

    Similar Threads Forum Date
    India Threads Identifying Delhi Rape Victim Removed Breaking News Jan 8, 2013
    Controversial What Should Be the Media Policy about Identifying a Person's Faith in Their Reporting? Hard Talk Jan 3, 2011
    Identify the Raag and Taal Business, Lifestyle & Leisure Nov 14, 2007
    Sikh News Punjab survey to identify educated jobless (The Hindu) Breaking News Sep 2, 2007
    Sikh News Attn: UPA, identify yourself! Breaking News Mar 6, 2005

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Assuming your import table layout is identical (except for the extra field,
    Else list the fields ;-) )

    Sub DebugChange
    Dim Db AS DAO.Database
    Dim RsL AS DAO.Recordset, RsI AS DAO.Recordset
    Dim Fld AS DAO.Field
    Set Db = Access.CurrentDB
    Set RsI = Db.OpenRecordset("SELECT * FROM ImportTable WHERE
    STATUS='Change'"),DAO.DbOpenSnapshot)
    While Not RsI.EOF
    Set RsL=Db.OpenRecordset("SELECT * FROM DataTable WHERE PK=" &
    RsI.Fields("PK").Value
    For Each Fld In RsI.Fields
    If Fld.Name <> "STATUS" Then
    If Access.Nz(Fld.Value,VBA.vbNullString ) <>
    Access.Nz(RsI.Fields(Fld.Name).Value) Then
    Debug.Print RsL.Fields("PK").Value,
    RsL.Fields(Fld.Name).Value, Fld.Value
    End If
    End If
    RsL.Close : Set RsL = Nothing
    Next
    RsI.MoveNext
    Wend
    RsI.Close : Set RsI = Nothing
    Set Db = Nothing

    End Sub

    HTH

    Pieter

    "Jen" <Jen@discussions.microsoft.com> wrote in message
    news:ED5ADA0F-5239-40D9-B393-BA9A32A8C80B@microsoft.com...
    >I receive 2 monthly files on members that contain like 50 fields of data.
    > Each record indicates either New, Change or Term. So 1 member could have
    > multiple records coming on every file.
    > On a Change record, what I need to do is when I receive a record on a
    > member
    > that already exists in my table, I want to check about 10 fields of data
    > to
    > determine what the Change is.
    >
    > I am looking for someone to suggest where I start with this. I know it
    > can
    > be done. I am a fairly experienced user; just looking for some help
    > getting
    > started. I am assuming this will require some programming, which is great
    > if
    > anyone has any suggestions.
    >
    > The database is '97.
    > THANKS!!
     

Share This Page