create a POP up information

  • Thread starter Thread starter SF
  • Start date Start date
S

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
 
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
 
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
 
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
 
<<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
---------------------------
 
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)
 
Yes I know Vadim, but the OP hasn't been specific about what he wants.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
Back
Top