[AccessD] Dang Bound Forms Again

Jim:

When the data entry property is set to Yes and the recordsource is returning
zero records because there are no records yet in the table, the screen comes
up blank.

This has to be a common problem with a simple workaround.  I can see lots of
times when a bound form opens to an empty recordset (or an empty table).
how is this handled?

Regards,

Rocky

Rocky

----- Original Message ----- 
From: "Jim Dettman" <jimdettman at earthlink.net>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 04, 2003 12:07 PM
Subject: RE: [AccessD] Dang Bound Forms Again


> Rocky,
>
> <<If I remove the recordsource I get the form but the bound fields have
> #Name
> in them because they're bound to unknown fields.>>
>
>  Well don't do that<g>.  If you want the form blank, either put a filter
> condition on it that returns no records or set the DataEntry property to
> True.
>
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Wednesday, June 04, 2003 2:28 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Dang Bound Forms Again
>
>
> Charlotte:
>
> When there are no records in the recourd source the form comes up blank.
>
> If I remove the recordsource I get the form but the bound fields have
#Name
> in them because they're bound to unknown fields.
> ----- Original Message -----
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: <accessd at databaseadvisors.com>
> Sent: Wednesday, June 04, 2003 10:28 AM
> Subject: RE: [AccessD] Dang Bound Forms Again
>
>
> > Why would you get #Name? Stuff with an empty table?  If the form is
> > bound, it's bound to the fields, whether there is anything in them or
> > not.  If you are binding the form when you open it, use a default empty
> > recordset (i.e., WHERE 1=2), which will eliminate the #Name error but
> > still give you empty bound fields.  You would have to change the
> > recordsource in code, but I generally use an empty recordset as the
> > default recordsource to make my forms load faster.
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> > Sent: Wednesday, June 04, 2003 8:50 AM
> > To: AccessD at databaseadvisors.com
> > Subject: [AccessD] Dang Bound Forms Again
> >
> >
> > Dear List:
> >
> > I have a bound form which displays product structures.  If the product
> > structure table is empty (as it would be when the user is just starting
> > up) the screen comes up blank.  I would like the form to display empty
> > without the #Name stuff, of course.
> >
> > How do you all solve this problem of a bound form bound to an empty
> > record source?
> >
> > MTIA
> >
> > Rocky Smolin
> > Beach Access Software
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com