Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

DLookup #NAME problem

Hello,

with clue of a previous experts exchange guy, I noticed  that I had to use a Dlookup function for the purpose I assigned myself:
In a formular, frmCourseMain, I just want to add a textbox (SUM in red in the file) which contains the sum of the fees of the student registered for the course chosen.

nevertheless, even if I read tutorial  on it, I still have a #name problem on the textbox names Sum
So, maybe you should fix it, again!
Thanks in advance!
example.mdb
0
Noero
Asked:
Noero
  • 3
  • 2
1 Solution
 
mbizupCommented:
You need an "=" sign before the DLookup in the control source:

= DLookup( etc...
0
 
NoeroAuthor Commented:
Thank you but that doesn't seem to work (use a combination of space thereafter).
May be it's because I am using a french version of Access 2000
capture1.bmp
capture2.bmp
0
 
mbizupCommented:
It shouldn't make a difference...

Try this:

0
 
mbizupCommented:
Hmm.  The upload didn't get uploaded.

Try this:


example.mdb
0
 
NoeroAuthor Commented:
Indeed, that works! I am surprised that Access accept only the function of the language chosen. Thanks!!!
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now