elookup error

  • Thread starter Thread starter Grimwadec
  • Start date Start date
G

Grimwadec

Re Allen Browne's ELookup function, no matter in what circumstances I use it,
even simply substituting it for DLookup and leaving the additional argument
blank, I get error message: ELookup Error3061 “Too few parameters. Expected
1.â€

The article at "http://allenbrowne.com/ser-42.html" is said to address this
under Limitations (#2.) but I do not understand the issue. Can anybody help
please?
 
Concatenate the value from the form into the 3rd string.

The example on the webpage you quote says to use:
ELookup("Surname", "Clients", "ClientID = " &
[Forms].[Form1].[ClientID])
instead of:
ELookup("Surname", "Clients", "ClientID = [Forms].[Form1].[ClientID]")
 
getting there but slowly. I tried

DespatchPhoneDate = ELookup("LastReminder", "tblPickUpReminder", "JobNo = &
"Forms!frmCustomerG!subfrmJob.Form!ID", "LastReminder DESC")
but get a "list separator or )" message. I can't work out how to fix the
code. Help please.
--
Grimwadec


Allen Browne said:
Concatenate the value from the form into the 3rd string.

The example on the webpage you quote says to use:
ELookup("Surname", "Clients", "ClientID = " &
[Forms].[Form1].[ClientID])
instead of:
ELookup("Surname", "Clients", "ClientID = [Forms].[Form1].[ClientID]")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Grimwadec said:
Re Allen Browne's ELookup function, no matter in what circumstances I use
it,
even simply substituting it for DLookup and leaving the additional
argument
blank, I get error message: ELookup Error3061 “Too few parameters.
Expected
1.â€

The article at "http://allenbrowne.com/ser-42.html" is said to address
this
under Limitations (#2.) but I do not understand the issue. Can anybody
help
please?
Click to expand...
Click to expand...
 
The quotes are not correct:

DespatchPhoneDate = ELookup("LastReminder", "tblPickUpReminder",
"JobNo = " & Forms!frmCustomerG!subfrmJob.Form!ID,
"LastReminder DESC")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Grimwadec said:
getting there but slowly. I tried

DespatchPhoneDate = ELookup("LastReminder", "tblPickUpReminder", "JobNo =
&
"Forms!frmCustomerG!subfrmJob.Form!ID", "LastReminder DESC")
but get a "list separator or )" message. I can't work out how to fix the
code. Help please.
--
Grimwadec


Allen Browne said:
Concatenate the value from the form into the 3rd string.

The example on the webpage you quote says to use:
ELookup("Surname", "Clients", "ClientID = " &
[Forms].[Form1].[ClientID])
instead of:
ELookup("Surname", "Clients", "ClientID =
[Forms].[Form1].[ClientID]")

Grimwadec said:
Re Allen Browne's ELookup function, no matter in what circumstances I
use
it,
even simply substituting it for DLookup and leaving the additional
argument
blank, I get error message: ELookup Error3061 “Too few parameters.
Expected
1.â€

The article at "http://allenbrowne.com/ser-42.html" is said to address
this
under Limitations (#2.) but I do not understand the issue. Can anybody
help
please?
Click to expand...
Click to expand...
Click to expand...
 
Thanks heaps - works beautifully
--
Grimwadec


Allen Browne said:
The quotes are not correct:

DespatchPhoneDate = ELookup("LastReminder", "tblPickUpReminder",
"JobNo = " & Forms!frmCustomerG!subfrmJob.Form!ID,
"LastReminder DESC")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Grimwadec said:
getting there but slowly. I tried

DespatchPhoneDate = ELookup("LastReminder", "tblPickUpReminder", "JobNo =
&
"Forms!frmCustomerG!subfrmJob.Form!ID", "LastReminder DESC")
but get a "list separator or )" message. I can't work out how to fix the
code. Help please.
--
Grimwadec


Allen Browne said:
Concatenate the value from the form into the 3rd string.

The example on the webpage you quote says to use:
ELookup("Surname", "Clients", "ClientID = " &
[Forms].[Form1].[ClientID])
instead of:
ELookup("Surname", "Clients", "ClientID =
[Forms].[Form1].[ClientID]")

Re Allen Browne's ELookup function, no matter in what circumstances I
use
it,
even simply substituting it for DLookup and leaving the additional
argument
blank, I get error message: ELookup Error3061 “Too few parameters.
Expected
1.â€

The article at "http://allenbrowne.com/ser-42.html" is said to address
this
under Limitations (#2.) but I do not understand the issue. Can anybody
help
please?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top