Re: Eval("Name of Field")
From: Gijs Beukenoot (gijs.beukenoot_at_wanadoo.nl)
Date: 11/29/04
- Next message: Dan Wells: "Re: Setting unknown date range in a query"
- Previous message: MDB-HZA: "Eval("Name of Field")"
- In reply to: MDB-HZA: "Eval("Name of Field")"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 15:26:45 +0100
Na rijp beraad schreef MDB-HZA :
> A column in a query:
> Data: Eval(FieldName())
>
> In a general Module:
> Public Sub FieldName() As String
> FieldName = "Name of Field"
> End Sub
>
> when run, the query should EVALUATE the name of the field returned in the
> query and look up the value of that field for each record. Instead it puts
> "Name of Field" in each record. Would not the purpose of evaluate be to
> change from a string to code?
It's doing exactly as you code. The function returns "Name of Field" so
that's what you get in your query... I'm not sure what you'd expect it
to return, please explain a little bit further...
-- Your eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. When I snap my fingers, you cannot imagine why you ever felt otherwise. <snap>
- Next message: Dan Wells: "Re: Setting unknown date range in a query"
- Previous message: MDB-HZA: "Eval("Name of Field")"
- In reply to: MDB-HZA: "Eval("Name of Field")"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
