Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    patatrac is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2012
    Posts
    9
    I would extract from Report1 when open IDs and saves in table answer , but don't know the way...
    example but dont work
    in open event
    Dim db As Database, rst As Recordset, rst2 As Recordset
    Dim ID As String, TheValues As String
    Set db = CurrentDb
    Set rst = db.OpenRecordset("SELECT ID_Body FROM 01_Body ")
    Set rst2 = db.OpenRecordset("Answer")
    rst.MoveFirst
    ID_Body = rst!ID_Body
    'Let ID = rst!Unique_ID
    Do While Not rst.EOF
    rst2.AddNew
    rst2("ID_Body").Value = rst("ID_Body").Value
    rst2.Update


    rst.MoveNext
    Loop

  2. #17
    patatrac is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2012
    Posts
    9

    solved

    create
    1 Report_print (is query create table)
    1 TempTableForReports
    and set recordsource 2 reports in table.
    thanks all

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-29-2015, 11:16 AM
  2. Update Query - Random Alphanumeric String
    By turkeylord in forum Queries
    Replies: 3
    Last Post: 09-12-2014, 12:55 PM
  3. Random Query
    By TrackStar in forum Queries
    Replies: 0
    Last Post: 06-20-2012, 09:10 AM
  4. Replies: 8
    Last Post: 03-19-2012, 08:50 PM
  5. Query Random Number Column Manipulation
    By gmontano in forum Queries
    Replies: 4
    Last Post: 10-05-2010, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums