Dlookup / Vlookup

[leibale]

Is there a way to use in VBA inside access, some function like Dlookup but to do the search in array within the code
Or something like Vlookup of excel (with the TRUE or the FALSE argument) ?

 

[xenou]

You may need to be more specific. In short, "Yes"...but what are you trying to do?

 

[SydneyGeek]

You may be able to do what you need with a query, which will be much faster than any functions. But if you really need something like VLOOKUP, check you the ELOOKUP function on Allen Browne's site.

Denis

 

[leibale]

Re: Dlookup / Vlookup access, VBA

In excel we use the VLOOKUP function with the argument FALSE which is similar to the dlookup function in Access
Some time we need to use that function with the TRUE argument that search the highest value in the table that is Less or Eq to the value I want.
When a user in Login, I am search the current hour against a table:
04----Good Night
11----Good Morning
17----Good Afternoon
24---Good Evening
etc,
and sent the user a greeting

So, my questions are:
1. There is a way to use the dlookup against an array and not against a record set (with the true or the false argument)
2. What is the way to do it in access with the TRUE argument

 

[SydneyGeek]

Re: Dlookup / Vlookup access, VBA

As I said before you need a different function. Check out ELOOKUP for range matching (ie the TRUE argument).
For the FALSE argument just join the main table to the lookup table in a query.

Denis