create a POP up information "SF" <socfund[ at ]online.com.kh> 04.06.2006 03:02:11 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

Re: create a POP up information "Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 04.06.2006 05:13:10 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 --------------------------- "SF" <socfund[ at ]online.com.kh> wrote in message news:eViRJN4hGHA.4144[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > 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 > >

Re: create a POP up information "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> 07.06.2006 04:53:17 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

Re: create a POP up information "SF" <socfund[ at ]online.com.kh> 07.06.2006 10:53:15 Can NET SEND be execute within Access VBA? SF "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> wrote in message news:u$B784eiGHA.1276[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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 >

Re: create a POP up information "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> 08.06.2006 02:30:01 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

Re: create a POP up information "Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 08.06.2006 13:54:59 <<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 --------------------------- "SF" <socfund[ at ]online.com.kh> wrote in message news:OnxAXCiiGHA.1208[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > Can NET SEND be execute within Access VBA? > > SF > > "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> wrote in message > news:u$B784eiGHA.1276[ at ]TK2MSFTNGP03.phx.gbl... >> 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 >> > >

Re: create a POP up information "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 08.06.2006 15:38:39 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> "SF" <socfund[ at ]online.com.kh> wrote in message GR> news:OnxAXCiiGHA.1208[ at ]TK2MSFTNGP02.phx.gbl... ??>> Can NET SEND be execute within Access VBA? ??>> ??>> SF ??>> ??>> "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> wrote in message ??>> news:u$B784eiGHA.1276[ at ]TK2MSFTNGP03.phx.gbl... 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: vrapp[ at ]nospam.polyscience.com

Re: create a POP up information "Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 12.06.2006 10:24:51 Yes I know Vadim, but the OP hasn't been specific about what he wants. Regards, Graham R Seach Microsoft Access MVP Canberra, Australia --------------------------- "Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> wrote in message news:eX9TWGxiGHA.4880[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > 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> "SF" <socfund[ at ]online.com.kh> wrote in message > GR> news:OnxAXCiiGHA.1208[ at ]TK2MSFTNGP02.phx.gbl... > ??>> Can NET SEND be execute within Access VBA? > ??>> > ??>> SF > ??>> > ??>> "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> wrote in message > ??>> news:u$B784eiGHA.1276[ at ]TK2MSFTNGP03.phx.gbl... > 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: vrapp[ at ]nospam.polyscience.com