Messages Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 24 Mar 2006 09:54 GMT

Hi,

I have a database with 1000's of records. I have a search set up to retrieve
info from this. How can I set up a message box to appear if no records match
the specified criteria??

Any help would be appreciated.

Signature

Phil

Reply to this Message

TC - 24 Mar 2006 09:59 GMT

What do you mean, you "set up a search"? Are you using a form? Or
working in the table directly?

Here are some tips to help you ask your questions effectively:
http://tc2.atspace.com/0012-UsingUsenet.htm#PostSubject

HTH,
TC (MVP Access)
http://tc2.atspace.com

Reply to this Message

Duane Hookom - 24 Mar 2006 12:54 GMT

Is there a form or code or macro or anything else involved in this? We need
to know your method.

Signature

Duane Hookom
MS Access MVP
--

> Hi,
>
[quoted text clipped - 5 lines]
>
> Any help would be appreciated.

Reply to this Message

Phil - 26 Mar 2006 23:45 GMT

Hi Duane,

I have a form created, user enter's the number and then click a button to
search fo r the record.

Would you need more info that this?

Thanks

Signature

Phil

> Is there a form or code or macro or anything else involved in this? We need
> to know your method.
[quoted text clipped - 8 lines]
> >
> > Any help would be appreciated.

Reply to this Message

Duane Hookom - 27 Mar 2006 00:15 GMT

Is the data display form the same as the form where the users enter the
number and click a button?
Is there code behind the button you could share?

Signature

Duane Hookom
MS Access MVP
--

> Hi Duane,
>
[quoted text clipped - 18 lines]
>> >
>> > Any help would be appreciated.

Reply to this Message