Re: Click Function Problem - Code Help Required
From: Claire (claire_at_private.com)
Date: 05/04/04
- Next message: John Vinson: "Re: Can't insert new record into tables using Form"
- Previous message: Joseph Ellis: "Re: Learning to work with recordsets, and failing miserably"
- In reply to: Alan Fisher: "Click Function Problem - Code Help Required"
- Next in thread: Claire: "Re: Click Function Problem - Code Help Required"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 3 May 2004 21:50:43 -0600
Hi Alan:
I know this is unconventional, unfortunately, I have adopted a database that
was originally programmed in Access 2. The logic is not the way that I would
have written it so I thought this would be easier than rewriting most of the
60 odd queries in this database.
However, I do not have any code associated with the On Click event of the
list box. I would like to make the list box invisible so that the end user
does not have to click in it at all. I would like the correct code to be
written in the After Update event of my combo box.
Private Sub cboProgress_AfterUpdate()
Dim lstGstNew As Variant
Me.lstGstNew.Requery (correct result shows)
Me.lstGstNew.SetFocus (goes to the list box)
Me.lstGSTNew_click (blows up with Method or Data member not found
error)
I realize that the last line of the above code does not work........this is
what I need replaced with a valid function.
Thanks for your help Alan.
Claire
"Alan Fisher" <anonymous@discussions.microsoft.com> wrote in message Private
Sub cboProgress_AfterUpdate()
> Dim lstGstNew As Variant
>
> Me.lstGstNew.Requery (correct result shows)
> Me.lstGstNew.SetFocus (goes to the list box)
> Me.lstGSTNew_click (blows up with Method or
Data member not found
>error)
news:79aa01c4314c$52366ab0$a401280a@phx.gbl...
>-----Original Message-----
>Hi:
>
>I'm having trouble getting my message across on this one.
Hopefully, third
>time lucky. Thanks to everyone that offered suggestions
previously, but I'm
>running out of time. I know I need to learn VBA
unfortunately, time is not
>on my side.
>
>I need some code that will make access click in a list
box for me, not go to
>the list box, not set the focus to the list box, but
physically click the
>list box. The list box is currently showing the expected
result, but in
>order for a recalculation to take place on another form,
you must physically
>click in the list box.
>
>I have tried many times, without success, to use _click
to make this happen.
>I know this should be really easy, but I am at my wits
end. All of my
>efforts end up with "Sub or Function not defined"
or "Method or Data member
>not found" errors.
>
>Could somebody that KNOWS, please help me out with this
one.
>
>Below is the portion of my code that I am having trouble
with:
>
>>
>A million thanks
>Claire
>
>
>It is not surprising that you are having trouble getting
a reply that helps. What you are trying to do is very
unconventional to say the least. Sorry if that sounds
critical it's just the way it is. If you have code
associated with the On Click event of the list box that is
doing what you want you should just copy it to where you
are trying to make the click event happen. That is the
line where you have Me.lstGSTNew_click (Which isn't a
valid operation) should be replaced with what ever event
you have in the On Click event of the list box. If you
have more specific requirements or information that could
help make your problem better understood, reply with it
and I will try and help more. Good Luck.
>.
>
- Next message: John Vinson: "Re: Can't insert new record into tables using Form"
- Previous message: Joseph Ellis: "Re: Learning to work with recordsets, and failing miserably"
- In reply to: Alan Fisher: "Click Function Problem - Code Help Required"
- Next in thread: Claire: "Re: Click Function Problem - Code Help Required"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
