Custom Function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 03/03/04 

Date: Wed, 3 Mar 2004 03:59:21 -0800

Please, give me a hint on why the following custom
function does not work:

Option Compare Database

Function BranchName(ID)
    BranchName = DLookup_
("[BranchName]", "Branches", "[BranchID]=ID")
End Function

The purpose of the function is to retrieve the full name
of a company branch from "Branches" table.
"Branches" table has 2 columns: [BranchID](text field),
[BranchName](text field)

Relevant Pages

  • Re: Greebs n Sheel
    ... >Hint - Keep your Opening page small and simple, ... It is as bad as using Word or Publisher for that purpose. ... Word Processors and Desktop Publishers are made for their job ...
    (uk.education.staffroom)
  • Re: Whats the looooongest word in English? :-?
    ... made up for a particular occasion or purpose; ... from custom, habit, or design; not natural or spontaneous; ...
    (alt.usage.english)
  • Re: Windows Update Fails
    ... For the purpose of troubleshooting this I have set the security ... custom or express, but when i woudl click custom I will get the ... What patches do you have so far (specifically - what service pack level are ...
    (microsoft.public.windowsupdate)
  • Re: Pop Up without Titlebar?
    ... but this won't serve my purpose. ... title bar completely and have a custom one..It will have a different color, ...
    (microsoft.public.scripting.jscript)
  • Re: Handling file system of PPC by HTML/javascript
    ... isn't this possible with an ActiveX crafted for this purpose? ... I'm not familiar with PocketPC though -- my experience is with custom ... WinCE automation devices, often with a local Web interface. ...
    (microsoft.public.dotnet.framework.compactframework)