Results 1 to 4 of 4
  1. #1
    smahdih is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    52

    run a report but not show it, when form load

    hi

    how can i run a report or query and check it for record but not show report or query and i want when a form load, check the report
    like:



    on load event form:
    if count(report) >0 then
    msgbox " you have record"
    end if


    how can i do this?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    As posted elsewhere, you can use a DCount() function.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    smahdih is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    52
    Quote Originally Posted by pbaldy View Post
    As posted elsewhere, you can use a DCount() function.
    sorry for duplicate post,

    i use dcount() function and fiix it.

    sepasgozar (means tnx alot)

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Happy to help.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 11-12-2011, 02:40 PM
  2. Replies: 8
    Last Post: 11-08-2011, 05:11 AM
  3. Report load events - OnFormat???
    By weasel7711 in forum Reports
    Replies: 1
    Last Post: 04-20-2011, 09:33 PM
  4. Show only current record in report from form/subform
    By stelioshania in forum Reports
    Replies: 0
    Last Post: 03-02-2011, 02:19 PM
  5. Load Record from report in form
    By rdirosato in forum Reports
    Replies: 13
    Last Post: 03-08-2010, 10:35 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