Re: can I do an inline select case statement? syntax ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 14 Apr 2005 10:52:10 -0700, "Newbee Adam"
<NewbeeAdam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Does an in line select even exist?

If by "inline select" you mean retrieving a table value using criteria
in a VBA statement, then DLookUp would be preferable:

Value = DLookUp("[fieldname]", "[tablename]", "<optional criteria>")


John W. Vinson[MVP]
.

Relevant Pages

  • Re: dlookup documentation?
    ... > Does anyone know if access provides online documentation for dlookup? ... > Refer to a subform or subreport property or control. ... You can use the DLookup function to get the value of a particular ... DLookup(expr, domain, [criteria]) ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I look though a set of records to find whether a specific value exists?
    ... DLookup() is explained in the link posed previously. ... The 3rd one is the criteria of what to match. ... the form into the string. ... > Dim varX As Variant ...
    (microsoft.public.access.formscoding)
  • Re: Find Record using 2 fields in table
    ... Generic syntax for DLookup when using two fields as criteria (assumes both ... if you're concatenating a variable value into the ... The intent is when a user enters a new repair and selects the Tool No, ...
    (microsoft.public.access.modulesdaovba)
  • Dlookup
    ... >>You have not entered any criteria to restrict the ... >>third argument of Dlookup is the domain restriction. ... >>This assumes a numeric UserID. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Academic Year date criteria in a query
    ... "WHERE" & put the expression in the Criteria row. ... > where would I put this code - in the criteria of a query ... Is DateColumn the name of the date field? ... > year which is the current DLookup value plus one. ...
    (microsoft.public.access.queries)