Re: References choice...

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have tried to do that because it seems logical to me, but when I go to
build query in the list of constants,... there is not my value in the list.
How to find it? Or just in the field criteria put her name?

Thanks in advance.

Best regards,
Stole.

"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:#AaNhDIrGHA.3564@xxxxxxxxxxxxxxxxxxxxxxx
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...
    ... 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, ... Is it possible to define constant 'A' that would pick a value from combobox ... >> in general - you need to have min 3 references in Access ...
    (microsoft.public.access.modulesdaovba)
  • Re: Webdav htmldescription tag missing from response
    ... Instead of DAV:htmldescriptions, you must query urn:schemas:httpmail:htmldescription ... Best regards, ... the reason why no html description is returned in this case, ... > Webdav and has been quite happy for sometime. ...
    (microsoft.public.exchange.applications)
  • 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: date useage in vb expression
    ... > a WHERE clause rather than a named filter or query. ... >> End Sub ... >> Best regards ... >> Scott B ...
    (microsoft.public.access.formscoding)
  • Re: Query to use like values from other table
    ... or similar to above query. ... Best Regards, ... Luqman ... >> The ways I know is either use union query ...
    (microsoft.public.sqlserver.programming)