create a POP up information

[SF]

Hi,

I have a small sale database in Access 2002 with SQL 2000 back end. The
database works fine except that the manager want a POP up notice about any
product that is less than 5 in stock. Does anyone recommend possible
solution here?

SF

 

[Graham R Seach]

You can run a small script in Access to check for the number of items in
stock. How you do that depends on a number of factors, including whether you
want a list to popup when the database launches, or when you open up a
specific form.

So the question is; when do you want this popup to appear?

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[Vadim Rapp]

GR> So the question is; when do you want this popup to appear?

since the request is coming from the manager, I bet he wants the popup when
he is browsing the internet or reading email. Which means that it has to be
implemented as NET SEND. Seriously.

Vadim

 

[SF]

Can NET SEND be execute within Access VBA?

SF

 

[Vadim Rapp]

Hello SF,
You wrote in conference microsoft.public.access.adp.sqlserver on Wed, 7 Jun
2006 17:53:15 +0700:

S> Can NET SEND be execute within Access VBA?

interaction.Shell "cmd /c net send mymachine hello"

Also, in VBA you can use Declare Function, which allows you pretty much
anything Windows can do.

Vadim Rapp

 

[Graham R Seach]

<<Can NET SEND be execute within Access VBA?>>
Yes, but that's not the issue. Something has to trigger it. What??

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
---------------------------

 

[Vadim Rapp]

The best would be doing it without involving Access - depending on how
instantly the notification is wanted, create a job on sql server, or trigger
on the table.

Vadim

GR> Regards,
GR> Graham R Seach
GR> Microsoft Access MVP
GR> Canberra, Australia
GR> ---------------------------

GR> ??>> Can NET SEND be execute within Access VBA?
??>>
??>> SF
??>>
??>> GR>>>> So the question is; when do you want this popup to appear?
??>>>
??>>> since the request is coming from the manager, I bet he wants the
??>>> popup
??>> when
??>>> he is browsing the internet or reading email. Which means that it has
??>>> to
??>> be
??>>> implemented as NET SEND. Seriously.
??>>>
??>>> Vadim
??>>>

With best regards, Vadim Rapp. E-mail: (e-mail address removed)

 

[Graham R Seach]

Yes I know Vadim, but the OP hasn't been specific about what he wants.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia