CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. June 29th, 2003, 04:45 PM #1
    jvbd02
    jvbd02 is offline Member +
    Join Date
    Sep 2002
    Location
    England
    Posts
    530

    How do I 'concatenate' snapshot reports (Access VBA)

    Hi,

    I have a number of access databases which I loop through, run the same query on, and end up with a snapshot of each.

    I am looking to 'concatenate' or similar these snapshots so that they can be displayed in just one report. How can I do this?

    Alternatively, can I run this query on each of these databases and continually write the report info to a single snapshot file until all databases are looped through? If so, how do I do this?

    Thanks.

    EDITED: Never mind - I have changed the design so that I do not have to deal with report snapshots anymore.
    Last edited by jvbd02; June 30th, 2003 at 01:11 PM.
    Reply With Quote Reply With Quote
  2. January 24th, 2011, 05:42 PM #2
    Lebowski
    Lebowski is offline Junior Member
    Join Date
    Jan 2011
    Posts
    5

    Question Re: How do I 'concatenate' snapshot reports (Access VBA)

    jvbd02: How did you do it? I am in need of a solution to concatenate multiple Access reports into one via VBA.

    If anyone out there knows, I'd greatly appreciate a code example.

    Thanks,

    Dave
    Reply With Quote Reply With Quote
  3. January 24th, 2011, 07:26 PM #3
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: How do I 'concatenate' snapshot reports (Access VBA)

    You realize that that was 8 years ago

    Start a new thread, please.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2013 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured