Results 1 to 10 of 10
  1. #1
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7

    code for reporting


    hai,
    can any one help me how to wright the code for reporting....pls

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614

  3. #3
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7
    hai, sir
    i have developed one database & now i want generate report for the db like if i click on on id number the total details of the id number will be shown on screen .for that porpus how to wright code .

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Here is one method http://datapigtechnologies.com/flash...mtoreport.html

    Another uses WHERE CONDITION of DoCmd.OpenReport, like:
    DoCmd.OpenReport "report name", , , "ID=" & Me.ID
    http://www.blueclaw-db.com/docmd_openreport.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7
    hello,
    i have created db on using MS access 2007 & now would like to generate a report like if i click on any "id no" the total information of the that "id no" will shown on screen .
    so how to wrote a code for that can any one help me to write a code with example.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I have provided two examples. Make a choice and attempt code. Provide your attempt for analysis.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7
    thank you for your replay sir , i am just confused to that link .can you send any video clip for the code .

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I do not have video clips. I provided links that have helped many others. What you want is basic Access functionality. Exactly what has confused you? Have you made attempt?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7
    hello.
    i have develop a db using msaccess2007 now i want to generate reports for that db and i have some doubts in that like
    1. how to generate a simple report
    2.how to generate report that will be relationship with all the forms (or) table
    3. hoe to generate report like if i click on any id total information of the id will shown on screen
    pls any one help me with examples.
    thanks&regards ramesh
    Last edited by rakhee; 04-29-2013 at 11:33 PM.

  10. #10
    rakhee is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2013
    Posts
    7
    hello.
    i have develop a db using msaccess2007 now i want to generate reports for that db and i have some doubts in that like
    1. how to generate a simple report
    2.how to generate report that will be relationship with all the forms (or) table
    3. hoe to generate report like if i click on any id total information of the id will shown on screen
    pls any one help me with examples.
    thanks&regards ramesh

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Footer in Reporting
    By gatsby in forum Access
    Replies: 2
    Last Post: 03-12-2013, 09:06 PM
  2. Help with reporting
    By stevo7624 in forum Access
    Replies: 1
    Last Post: 09-03-2012, 09:54 PM
  3. reporting
    By jaykappy in forum Reports
    Replies: 10
    Last Post: 02-16-2012, 03:02 PM
  4. Complex reporting (well for me anyway)
    By Rubijon in forum Reports
    Replies: 4
    Last Post: 11-09-2011, 08:01 PM
  5. Question on Reporting
    By jbarrum in forum Access
    Replies: 20
    Last Post: 01-14-2010, 02:05 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