Form goes blank when no records

Lillian

unread,

Oct 29, 2009, 9:35:22 AM10/29/09

to

I have a form that goes blank when a user deletes all records.
Is there a way to have vba to add a record when the form is open. This
would keep the form from going blank.

jaquelin zalasar

unread,

Nov 1, 2009, 5:10:17 PM11/1/09

to

"Lillian" <libert...@blessa.com> escribi� en el mensaje de noticias
news:gziGm.39$v47...@newsfe23.iad...

zane reining

unread,

Nov 6, 2009, 10:06:02 PM11/6/09

to

hi names zane
"Lillian" <libert...@blessa.com> wrote in message
news:gziGm.39$v47...@newsfe23.iad...

kalle09

unread,

Nov 7, 2009, 5:58:31 AM11/7/09

to

"Lillian" <libert...@blessa.com> schrieb im Newsbeitrag
news:gziGm.39$v47...@newsfe23.iad...

Jeff Boyce

unread,

Nov 11, 2009, 9:22:00 AM11/11/09

to

Lillian

Yes, having vba add a "dummy" record might be one way to handle that ... but
you'd be left with a dummy record, right?

I'm guessing that you're looking for a way to keep the form from going
blank.

One way to do this is to base the form on a query ... your form is based
directly on the table now?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Lillian" <libert...@blessa.com> wrote in message
news:gziGm.39$v47...@newsfe23.iad...

Lesley Segovia

unread,

Nov 11, 2009, 6:22:47 PM11/11/09

to

hey peoplesw wanna chat

"Lillian" <libert...@blessa.com> wrote in message
news:gziGm.39$v47...@newsfe23.iad...

Ésteesuntextodeprueba

unread,

Nov 21, 2009, 12:18:37 PM11/21/09

to

"Lillian" <libert...@blessa.com> escribi� en el mensaje de

noticias:gziGm.39$v47...@newsfe23.iad...

r dfgfghed

unread,

Nov 20, 2009, 7:26:49 PM11/20/09

to

"Lillian" <libert...@blessa.com> a �crit dans le message de
news:gziGm.39$v47...@newsfe23.iad...

turi angelomario

unread,

Nov 24, 2009, 9:13:12 AM11/24/09

to

"Lillian" <libert...@blessa.com> a �crit dans le message de
news:gziGm.39$v47...@newsfe23.iad...

????

unread,

Nov 30, 2009, 4:14:29 AM11/30/09

to

????? "Lillian" <libert...@blessa.com> ?? ?????
news:gziGm.39$v47...@newsfe23.iad...

Agnes Bolmus

unread,

Dec 3, 2009, 7:18:44 AM12/3/09

to

Hello

"Lillian" <libert...@blessa.com> schrieb im Newsbeitrag
news:gziGm.39$v47...@newsfe23.iad...

mike knudsen

unread,

Dec 5, 2009, 10:59:07 AM12/5/09

to

"kalle09" <pack...@web.de> schrieb im Newsbeitrag
news:%23yVJYk5...@TK2MSFTNGP06.phx.gbl...

mike knudsen

unread,

Dec 5, 2009, 11:17:17 AM12/5/09

to

"kalle09" <pack...@web.de> schrieb im Newsbeitrag
news:%23yVJYk5...@TK2MSFTNGP06.phx.gbl...
>

brooknrick

unread,

Dec 6, 2009, 12:12:09 PM12/6/09

to

Sure Lilly, its simple............ Tell the user not to delete all records
anymore:]

"Lillian" <libert...@blessa.com> wrote in message
news:gziGm.39$v47...@newsfe23.iad...

Jeff Boyce

unread,

Dec 14, 2009, 9:00:11 AM12/14/09

to

Another approach might be to make it impossible for the user to delete
records...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"brooknrick" <ric.b...@gmail.com> wrote in message
news:%23MpnGdp...@TK2MSFTNGP04.phx.gbl...

Piero Busanca

unread,

Dec 15, 2009, 7:57:26 AM12/15/09

to

joker

unread,

Jan 11, 2010, 7:43:31 PM1/11/10

to

"Lillian" <libert...@blessa.com> escribi� en el mensaje de noticias

news:gziGm.39$v47...@newsfe23.iad...

Angel

unread,

Feb 4, 2010, 7:25:56 PM2/4/10

to

Scandalous people

"joker" <manulp...@hotmail.com> wrote in message
news:6A473059-C6B0-4362...@microsoft.com...

HARVEYHINDIN

unread,

Feb 11, 2010, 10:35:24 AM2/11/10

to

"Agnes Bolmus" <agnes....@t-online.de> wrote in message
news:816B39EF-DBE6-4B9D...@microsoft.com...

>
> "Lillian" <libert...@blessa.com> schrieb im Newsbeitrag
> news:gziGm.39$v47...@newsfe23.iad...

Arvin Meyer [MVP]

unread,

Feb 11, 2010, 9:42:32 PM2/11/10

to

The form goes blank because it is not updateable and there are no records.
The best thing you can do is check the record count and use a message box to
display a message if there are no records.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"HARVEYHINDIN" <harv...@cox.net> wrote in message
news:9873C611-E2B9-4F4E...@microsoft.com...

Yosiaki Akao

unread,

Feb 15, 2010, 2:05:54 AM2/15/10

to

"Agnes Bolmus" <agnes....@t-online.de> wrote in message
news:816B39EF-DBE6-4B9D...@microsoft.com...
>
> "Lillian" <libert...@blessa.com> schrieb im Newsbeitrag
> news:gziGm.39$v47...@newsfe23.iad...