Re: References choice...

Hi,
as I understand you - you can declare a public variable in common module, in combo box AfterUpdate event assign it to selected value. Then you can use it in code, to use it in a query - you need to make a public function, which returns this variable value, and use this function in a query

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"strela" <neko@xxxxxxxxxxxx> wrote in message news:e9o227$ume$1@xxxxxxxxxxxxxxxx
Thank you, this is helpful.

I have forgot to ask you too next question:
Is it possible to define constant 'A' that would pick a value from combobox
on a form and would be visible in whole project (I would use that value
later in other forms,...). One example: when I make query, I would like to
have this value as criteria also after I close form where combobox choice is
made (when query relies on combobox value on form, it looses this value at
the moment the form is closed). Any help?

Thanks in advance.

Best regards,
Stole.

"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:u2ahu89qGHA.3820@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
then you can open object browser (F2 in VBA window), select library you
interested in and it will give you list of classes, methods and properties

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"strela" <neko@xxxxxxxxxxxx> wrote in message
news:e9ndlv$neu$1@xxxxxxxxxxxxxxxx
> "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:#zoXt2wqGHA.3484@xxxxxxxxxxxxxxxxxxxxxxx
>> hi,
>> in general - you need to have min 3 references in Access
>> Access
>> VBA
>> DAO (or ADO)
>>
>> if you are not sure you using any other - you can remove it.
>>
>> Normally, when developer decides to start using some library or >> ActiveX
>> control in access application - he adds reference. it this case he >> have
>> to
>> be sure that this library or control installed on other users PCs
>
> This is database for me and few more people. Everyone has the same
> computer
> and software, so this should not be problem. Problem is where can one
find
> what each reference "brings new" to access VBA? Thanks in advance.
>
> Best regards,
> Stole.



.

Relevant Pages

  • Re: References choice...
    ... build query in the list of constants,... ... Best regards, ... made (when query relies on combobox value on form, ... in general - you need to have min 3 references in Access ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to remove duplicates from linked table query?
    ... Penny ... > You can simply use the full references to the ComboBoxes as the Parameters ... > and provided that the Query is handled by Access, ... >> Regards, ...
    (microsoft.public.access.queries)
  • Re: References choice...
    ... Is it possible to define constant 'A' that would pick a value from combobox ... made (when query relies on combobox value on form, ... Best regards, ... in general - you need to have min 3 references in Access ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reporting Out Two Names w/Phone # from the Same Table
    ... The combobox on the form where the data's entered already pulls in multiple ... I'm trying to get two references to the same Contact_Table to work ... into the query. ...
    (microsoft.public.access.reports)
  • Re: AllowAdditions=False makes unbound controls blank out when recordcount=0.
    ... If the RecordSource is not a read-only query, one workaround is to allow the ... You can place other controls in the Form Header section and they are ... there are still display problems with those ... > the after update event of the combobox. ...
    (microsoft.public.access.forms)