multi user access

Do you have a DAO reference set?
 
Well, nothing looks wrong. Just make sure you have that table in your frontend (whether it is the one supposed to be in the frontend or the linked one from the backend - as I can't remember right off the top of my head which is which).
 
Well, nothing looks wrong. Just make sure you have that table in your frontend (whether it is the one supposed to be in the frontend or the linked one from the backend - as I can't remember right off the top of my head which is which).

when i switch it back to dlookup, it works fine.. so i dont think it is the table right?
 
when i switch it back to dlookup, it works fine.. so i dont think it is the table right?

Good point. I wonder if it is the hyphen in the table name which is doing it. So, let's try changing this part of the eLookup code from this:

Code:
strSql = "SELECT TOP 1 " & Expr & " FROM " & Domain

to this:

Code:
strSql = "SELECT TOP 1 " & Expr & " FROM [B][COLOR=red][[/COLOR][/B]" & Domain [COLOR=red][B]& "]"[/B][/COLOR]
 
Good point. I wonder if it is the hyphen in the table name which is doing it. So, let's try changing this part of the eLookup code from this:

Code:
strSql = "SELECT TOP 1 " & Expr & " FROM " & Domain
to this:

Code:
strSql = "SELECT TOP 1 " & Expr & " FROM [B][COLOR=red][[/COLOR][/B]" & Domain [COLOR=red][B]& "]"[/B][/COLOR]

It works.. you are a genius!:)
 
It works.. you are a genius!:)

If I was a genius I wouldn't have used a hyphen in the name of the table to begin with. But since I created that tool 4 years ago, I have to cut myself some slack as I have learned not to do that anymore. :)

Perhaps I should go redesign the tool a bit.


But thanks anyway and glad we got it going for you.
 
do you have any alternative to Dmax too?

I am getting rid of all my D functions...as i find out that this slows down my database a lot.. there is a lot of improvement now that i got rid of dlookup. is there any alternative for dmax?
 
I don't have anything right now. You can experiment with creating your own using the SQL statements and opening a recordset with a Max in the SQL statement. Don't know if that would work but you could try.
 

Users who are viewing this thread

Back
Top Bottom