469,329 Members | 1,451 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,329 developers. It's quick & easy.

How to make DLookUP function works..

1
hey all,
I have tried to use the select statement instead DLookUp function as i have sql server at my backend and access as my front end.

But neither DLookUp function is working nor select state is working....
is there any other alternative way that i could make that run...

my code is

strEmail = DLookup("email", "owner", "name='Master_Table![Prim_Name]'")


and i treid

dim s as string
s = "Select email from owner where name = ' " & Master_table![Prim_Name]&" ' "

doCmd.OpenQuery(s)

now how could i get my email from this query. It is not giving me any output...

Thx in advance.
Jul 25 '07 #1
0 1148

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by David B | last post: by
42 posts views Thread by WindAndWaves | last post: by
6 posts views Thread by Don Sealer | last post: by
1 post views Thread by deejayquai | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.