Jim Dettman
jimdettman at earthlink.net
Thu Jun 5 07:39:51 CDT 2003
Rocky, The property "Data Entry" is really mis-named a bit. By setting it yes, it prevents any loading of existing records. One would think however that it deals with adding records and it does not. When you set it to yes, you should see a blank form regardless of records existing or not. << I can see lots of times when a bound form opens to an empty recordset (or an empty table). how is this handled?>> If the above didn't clear things up, then I think we all are missing your point in some way. 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 6:33 PM To: accessd at databaseadvisors.com Subject: Re: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com