RE: open a form at start up only if it holds records

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: richard harris (richardharris_at_discussions.microsoft.com)
Date: 03/19/05 

Date: Sat, 19 Mar 2005 01:23:02 -0800

hi darrep,

you are right in that i want to open the form on start of the database. the
idea behind it is that we have policies for clients where the acceptance
terms run out, so i have created a qry to highlight these within the next 7
days. what i want is for the form to open automatically if there are records
present to prevent human error in not checking.

i will try the open form event but would be grateful if you would let me
know what i need to do here.

thanks for your help

richard

"darrep" wrote:

> Richard --
>
> I'm a bit confuesed by what you're after here but I have a few suggestions
> to offer:
>
> First, the confusing part to me:
> "At startup" I assume means at the startup of the database. If this is the
> case where does the form get the date criteria that will determine if the
> form has records or not?
>
> Now for suggestions:
> Try using the Form Open event of the form to check and see if the recordset
> for the form is empty or not. If the recordset is empty then close the form.
>
> HTH
>
> "richard harris" wrote:
>
> > I have a a form that holds records if the date criteria is met else there
> > will be no records.
> >
> > How can i make this form open up at start up if it holds records only.
> >
> > help is appreciated.

Relevant Pages

  • Re: Formula in DCounta Criteria
    ... If J4 is empty, I want the criteria to be IGNORED - ... Lets assume that J4 is the selector for SalesRep. ... blank cell. ... The Criteria Range for querying does not treat "" empty strings ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Search on entered or blank criteria
    ... generall - that if the previous search returned an empty recordset, ... Search form - Handle many optional criteria ... I have a form with 4 combos in the Form Header, ... textbox portion for the query to reference. ...
    (microsoft.public.access.queries)
  • Re: Fat men on motorcycles
    ... UKRM would be empty on that criteria. ... Off the top of my head, there'd be me, ...
    (uk.rec.motorcycles)
  • Re: UDF that checks if a cell contains a period.
    ... The only thing I would add to the other posts is the you do NOT have to check if the cell is empty... ... certain criteria. ... Jonathan = Jonathan + 1 ...
    (microsoft.public.excel.programming)
  • Re: Fat men on motorcycles
    ... UKRM would be empty on that criteria. ... Off the top of my head, there'd be me, ... burnt, darsy, Bonwick, Auvache, dwb, antonye, ballistic, lozzo, ...
    (uk.rec.motorcycles)