Re: Blank Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

jervin via AccessMonster.com schreef : 
Hi,
I want to get rid of the blank form everytime i open. I had a form link with
a query and i wanted to prompt me sayin "data not found" instead of showing a
blank form. i just dont know how to do that...thanks ....


You can check me.recordset.eof to see if there are records

Or run the query before opening the form and see if there are any records, if not, give a message, else open the form


.

Relevant Pages

  • Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
    ... The query above is really a warehouse query. ... when going from rid to rid. ... My guess is the i/o sub system ... application development team set up a vanilla Oracle database, ...
    (comp.databases.informix)
  • Re: Blank Form
    ... Gijs Beukenoot wrote: ... I want to get rid of the blank form everytime i open. ... I had a form link with a query and i wanted to prompt me sayin "data not found" instead of showing a blank form. ...
    (microsoft.public.access.forms)
  • Blank Form
    ... I want to get rid of the blank form everytime i open. ... I had a form link with ... a query and i wanted to prompt me sayin "data not found" instead of showing a ...
    (comp.databases.ms-access)
  • Blank Form
    ... I want to get rid of the blank form everytime i open. ... I had a form link with ... a query and i wanted to prompt me sayin "data not found" instead of showing a ...
    (microsoft.public.access.forms)
  • Re: Subform Requery Doesnt Show Updates to Data
    ... I did not bind the main form to a query and I ... Private Sub cmdClose_Click ... Get rid of the DoCmd.RunCommand acCmdSaveRecord line. ... About the only other idea I have about the delay is maybe ...
    (microsoft.public.access.formscoding)