Results 1 to 5 of 5

Thread: problem with DLOOKUP function access 2003

  1. Mar 28th, 2006, 03:03 PM #1
    sweet_dreams
    sweet_dreams is offline

    Thread Starter
    Addicted Member sweet_dreams's Avatar
    Join Date
    Apr 2005
    Location
    Poland, Lodz
    Posts
    189

    problem with DLOOKUP function access 2003

    Hi all,

    I have such a problem I am trying to assing DLOOKUP function to textbox in report in access:

    VB Code:
    1. =DLookUp("nick";"users";"id_user=" & number)

    where number is global variable defined as long

    unfortunatelly it doesn't work it returns #error.

    Please help.
    regards,
    sweet_dreams
    Reply With Quote Reply With Quote
  2. Mar 28th, 2006, 03:06 PM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: problem with DLOOKUP function access 2003

    Use commas as separators rather than semi-colons.
    VB Code:
    1. =DLookUp("nick","users","id_user=" & number)
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. Mar 28th, 2006, 03:15 PM #3
    sweet_dreams
    sweet_dreams is offline

    Thread Starter
    Addicted Member sweet_dreams's Avatar
    Join Date
    Apr 2005
    Location
    Poland, Lodz
    Posts
    189

    Re: problem with DLOOKUP function access 2003

    hi DKenny,

    when I try change semi-colons on commas I get the message saying that I should use semi-colons,

    sweet_dreams
    Reply With Quote Reply With Quote
  4. Mar 28th, 2006, 03:16 PM #4
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: problem with DLOOKUP function access 2003

    Can you post the entire procedure?
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  6. Mar 28th, 2006, 03:31 PM #5
    sweet_dreams
    sweet_dreams is offline

    Thread Starter
    Addicted Member sweet_dreams's Avatar
    Join Date
    Apr 2005
    Location
    Poland, Lodz
    Posts
    189

    Re: problem with DLOOKUP function access 2003

    i have assign above manually code to textbox's control source property. textbox is on the report
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width