2815 Sikh Philosophy Network - View Single Post - Which event is triggered?
View Single Post
  #4 (permalink)  
Old 28-Jul-2006, 08:40 AM
Gino's Avatar Gino
Guest
 
Posts: n/a
   
   
Re: Which event is triggered?

Thank you Larry for the clarifications. This is what I suspected.

Regarding the Listbox with check marks" which I found on the web, it is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13711-which-event-is-triggered.html
actually coded in VBA and works with Access 97 and Access 2000. It does not
use an activex but some features within ACCWIZ.DLL which comes with a full
installation of Access.
The link with history and download is http://www.lebans.com/vb_listbox.htm

Best regards
Gino





"Larry Linson" wrote:

> There's no event triggered by scrolling in a continuous forms view Form
> (whether or not it is embedded in a Subform Control). The OnCurrent event
> fires when you select a different record, but simply scrolling does not
> select a different record (as you see if you left the RecordSelector active
> in that Form).
>
> Very likely, you found an ActiveX control that provides the capability you
> want. But, unless it specifically says it is created and tested to be used
> with Access, it may not work -- not nearly all ActiveX controls meet Access'
> requirements.
>
> Sorry I don't have better news.
>
> Larry Linson
> Microsoft Access MVP
>
> "Gino" wrote in message
> news:CBA65BAB-9419-40E6-ACCC-7C077C63DEDA@microsoft.com...
> >I needed a very simple listbox with check mark for each record, (which is
> >not
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13711
> > available within Access), so I created a simple subform with one text
> > field
> > and the checkbox, which I use in a way similar to a listbox (i.e. when I
> > click on a record in my subform, the main form displays that record).
> > This is triggered by a Click_Event on the text field on the subform and it
> > works fine.
> >
> > However, I need to be able to scroll up and down the subform using the
> > arrow
> > keys and have the main form synch with the subform.
> > I do not seem to find an event which gets triggered by simply moving to
> > the
> > the next or previous record using arrow keys or the navigation buttons at
> > the
> > bottom of the subform (I tried OnChange, OnCurrent, BeforeUpdate and
> > AfterUpdate etc. etc., but since there is no actual data change nothing
> > happens).
> >
> > Any idea?
> > Thank you very much.
> >
> > P.S. I found a clever free utility which displays listboxes with check
> > marks.
> > The demo works fine but it requred a bit too much knowledge for me to
> > customise it to my requirements. (I can't remember the link to that site
> > but
> > I will post it if I find it).
> >
> >
> > When I click
> >
> >
> > it as a subform on a form using the same data.
> >
> >

>
>
>

Reply With Quote
 
Page generated in 0.13807 seconds with 25 queries
0