Results 1 to 5 of 5

Thread: Populating Access Report from Form [Resolved]

  1. Mar 17th, 2005, 11:00 PM #1
    Luke K
    Luke K is offline

    Thread Starter
    Addicted Member Luke K's Avatar
    Join Date
    Jun 2004
    Location
    Perth, Australia
    Posts
    183

    Resolved Populating Access Report from Form [Resolved]

    Hi All,

    I have an invoice report in an db (access) ofc and its working like a charm. However, I do not know how to populate it using fields on my form. Any help would be appreciated.

    The fields will be the typical invoice fields, like phonenumber and cost. I would just like to know how to set my textbox's as the recourdsource to the textbox's in the report.

    I await any reply
    Last edited by Luke K; Mar 24th, 2005 at 08:40 AM.
    Artificial Intelligence At War! - The best game of its genre
    Program your own robot and watch it fight in 3d!
    Droidarena 3

    If I have been useful, please Rate My Post

    Support FireFox -
    Microsoft Visual Studio .NET Professional 2003
    Microsoft Visual Studio 6, Enterprise Edition
    Microsoft Windows XP Professional, Service Pack 2
    Reply With Quote Reply With Quote
  2. Mar 18th, 2005, 06:53 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Populating Access Report from Form

    Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.
    Reply With Quote Reply With Quote
  3. Mar 24th, 2005, 04:50 AM #3
    nickname
    nickname is offline
    Addicted Member nickname's Avatar
    Join Date
    Sep 2004
    Location
    Europe - Belgium
    Posts
    170

    Re: Populating Access Report from Form

    Quote Originally Posted by Hack
    Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.
    How can you dump a full recordset in an access table?
    Software Engineer
    DBA
    Webdesigner
    --
    to code or to be coded, that's the question
    Reply With Quote Reply With Quote
  4. Mar 24th, 2005, 05:28 AM #4
    nickname
    nickname is offline
    Addicted Member nickname's Avatar
    Join Date
    Sep 2004
    Location
    Europe - Belgium
    Posts
    170

    Re: Populating Access Report from Form

    Quote Originally Posted by Hack
    Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.
    How can you dump a full recordset in an access table?

    sorry for the double post..
    Software Engineer
    DBA
    Webdesigner
    --
    to code or to be coded, that's the question
    Reply With Quote Reply With Quote
  6. Mar 24th, 2005, 08:39 AM #5
    Luke K
    Luke K is offline

    Thread Starter
    Addicted Member Luke K's Avatar
    Join Date
    Jun 2004
    Location
    Perth, Australia
    Posts
    183

    Resolved Re: Populating Access Report from Form

    Thanks for replying guys,

    Tbh I forgot about this post but have since resolved it myself. Thanks again!
    Artificial Intelligence At War! - The best game of its genre
    Program your own robot and watch it fight in 3d!
    Droidarena 3

    If I have been useful, please Rate My Post

    Support FireFox -
    Microsoft Visual Studio .NET Professional 2003
    Microsoft Visual Studio 6, Enterprise Edition
    Microsoft Windows XP Professional, Service Pack 2
    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