Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Don't Display Form when no data (Access 2003, XP SP 3)

    I recall reading about this before but couldn't locate the thread. Basically, I want to do the On No Data for a pop-up form, not a report. Meaning, if the form is blank, add some kind of message telling the user that this is to be expected if they haven't processed the record in question.

    I'll keep looking around but wanted to check in with this question if a solution is out there.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Don't Display Form when no data (Access 2003, XP SP 3)

    You could use DCount in the code that opens the popup form to count the number of records that would be displayed in the pop-up form. If the count is 0, don't open the form but display a message box instead.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Don't Display Form when no data (Access 2003,

    i just did something similar, using Count(*) on the procedure. not sure if DCount is a better option but eventually this access project will be re-written in .NET/Winforms using SQL Server CE so I want to keep the code somewhat generic. If that makes any sense....

    Thanks, tho!

Posting Permissions

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