Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JustKev

    Loop through Logfile for New value and update Old Value

    Finally got there (sort of) with this approach: If rstCascade.EOF = False And rstCascade.BOF = False Then Do ' Walk down the Cascadelog for the new location varFind = DLookup(strNew_Loc, strCascadeTableName, _ "[" & strOld_Loc & "]='" &...
  2. JustKev

    Loop through Logfile for New value and update Old Value

    Thanks Remou I appreciate your prompt reply, a little more information is that Im trying to update the Inventory table Inv.Locationcode to the "New" (last)updated value (logtbl.Newvalue) in the log table, so I thought I would have envisaged a nested loop, i.e. go through each record in the...
  3. JustKev

    Loop through Logfile for New value and update Old Value

    Im new to loops and hope someone can help with what should be a simple solution. I have a table with Location information imported from another database, the user can change the locationcode to a new value, this "new "value is stored (as well as the original value) in a log table as...
  4. JustKev

    Create a dynamic logfile from Sql statement records

    Thanks Remou Finally got my head round it, and it works fine. I have now got a Data validation table that can be used for reporting and exporting into s spreadsheet. Dim rs As DAO.Recordset Dim strSql As String Set rs = CurrentDb.OpenRecordset("Select IntegStatement FROM...
  5. JustKev

    Create a dynamic logfile from Sql statement records

    Thanks for your help, Im very new so stumbling along really, the idea is to be able to add records to the Statement so it is dynamic the sql reference table is: Key(autonumber) StateName(text) IntegStatement(memo) and it is populating a logfile with generic fields, an example of the SQL...
  6. JustKev

    Create a dynamic logfile from Sql statement records

    Im a newbie so bear with me, I have several versions of a database with 30 odd tables in each. Each database has records that must be completed and so I create standard queries that are then copied to each Db instance. The problem is that these Query reports need constantly updating amending...

Part and Inventory Search

Back
Top