Home > Archive > MS Access and Internet > October 2005 > After Update/ on change









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author After Update/ on change
DMc2005

2005-10-27, 8:31 am

Hi

currently i am developing a few data access pages to enable users to enter
data from an intranet.

i am more than confortable in developin access databases but have only
recently touvhed upon DAP. I can program with access using VBA.

What i would like to do is the following:

a) When the record has been saved successfully to be able to display an
message box. I have been using VBScript and the function MsgBox, but nothing
appears, this has been used in the event After Update on the MSODSC object.
Any body know how to do this?

b) The Save button i would like to be disabled unitl a user makes changes or
creates a new record. i am presuming that i would be using the onchange
event, how could i do this?

many thanks

D


Sylvain Lafontaine

2005-10-27, 8:31 am

Usually, when nothing happens it's because you have forgotten to write the
required parameter for many methods of the MSODSC object.

For example, instead of:

<SCRIPT language=vbscript event=DataPageComple
te() for=MSODSC>

we have to write:

<SCRIPT language=vbscript event=DataPageComple
te(dscei) for=MSODSC>

Notice the parameter for DataPageComplete. See
http://msdn.microsoft.com/library/d...acc10_DSCOM.asp

for more information on the topic and the other posts in this newsgroup for
more references.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"DMc2005" < davidmcnaughton_1999
_nospam@hotmail.com> wrote in message
news:%23SLLwUPzFHA.2792@tk2msftngp13.phx.gbl...
> Hi
>
> currently i am developing a few data access pages to enable users to enter
> data from an intranet.
>
> i am more than confortable in developin access databases but have only
> recently touvhed upon DAP. I can program with access using VBA.
>
> What i would like to do is the following:
>
> a) When the record has been saved successfully to be able to display an
> message box. I have been using VBScript and the function MsgBox, but
> nothing appears, this has been used in the event After Update on the
> MSODSC object. Any body know how to do this?
>
> b) The Save button i would like to be disabled unitl a user makes changes
> or creates a new record. i am presuming that i would be using the onchange
> event, how could i do this?
>
> many thanks
>
> D
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com