Understanding Dlookup function ... - Microsoft Access / VBA

Ronny Sigo

Hello all,
When I use the Dlookup function I get the errormsg "Runtime error 2001 - You
canceled the previous operation" ... Can anybody tell me what I do wrong
here ?
Here is the snippet ... :

DoCmd.GoToRecord , , acNewRec
[Docnummer] = nBriefnum
[Docnummerstr] = sBriefstr
[Datumgemaakt] = Date
Me!txtOreflettersA.Value = DLookup("[Initialen]", "tblMwerkers",
"[Volledigenaam] = sNaamschrijver")

Any help very much appreciated ...
Ronny Sigo

Nov 12 '05 #1

Subscribe Reply

3302

Rick Brandt

"Ronny Sigo" <ro********@skynet.be> wrote in message
news:3f*********************@reader2.news.skynet.b e...

Hello all,
When I use the Dlookup function I get the errormsg "Runtime error 2001 - You
canceled the previous operation" ... Can anybody tell me what I do wrong
here ?
Here is the snippet ... :

DoCmd.GoToRecord , , acNewRec
[Docnummer] = nBriefnum
[Docnummerstr] = sBriefstr
[Datumgemaakt] = Date
Me!txtOreflettersA.Value = DLookup("[Initialen]", "tblMwerkers",
"[Volledigenaam] = sNaamschrijver")

If sNaamschrijver is a text variable it needs to be delimited so that the
expression gets the value of the variable passed to it instead of the name of
the variable.

Me!txtOreflettersA.Value = DLookup("[Initialen]", "tblMwerkers",
"[Volledigenaam] = '" & sNaamschrijver & "'")

Nov 12 '05 #2

Ronny Sigo

Thanks Rick ... works perfectly ....

"Rick Brandt" <rv********@sbcglobal.net> wrote in message
news:bl************@ID-98015.news.uni-berlin.de...

"Ronny Sigo" <ro********@skynet.be> wrote in message
news:3f*********************@reader2.news.skynet.b e...
Hello all,
When I use the Dlookup function I get the errormsg "Runtime error 2001 - You canceled the previous operation" ... Can anybody tell me what I do wrong
here ?
Here is the snippet ... :

DoCmd.GoToRecord , , acNewRec
[Docnummer] = nBriefnum
[Docnummerstr] = sBriefstr
[Datumgemaakt] = Date
Me!txtOreflettersA.Value = DLookup("[Initialen]", "tblMwerkers",
"[Volledigenaam] = sNaamschrijver")
If sNaamschrijver is a text variable it needs to be delimited so that the
expression gets the value of the variable passed to it instead of the name

of the variable.

Me!txtOreflettersA.Value = DLookup("[Initialen]", "tblMwerkers",
"[Volledigenaam] = '" & sNaamschrijver & "'")

Nov 12 '05 #3

Similar topics

20736

DLookUp of multiple records in a query

by: KLAU | last post by:

I have a field that retrieves information from an expression in a query. I have used a DLookup function to get the calculated field from the query. However, the relationship is 1-to-many so one...

Microsoft Access / VBA

440

DLookup problem

by: David B | last post by:

I have a Public function which creates a back up copy of a back end. It works fine with the source path and source file as C:\folder\etc. I thought I would try to store the paths in a table so...

Microsoft Access / VBA

14922

Dlookup function gives "You canceled the previous operation" errmsg

by: Ronny Sigo | last post by:

Hello all, I already put the same question, only now I have more to tell ... Although I used this code before in the same routine (only the fieldname of the table differs) ___ at this point in the...

Microsoft Access / VBA

2354

My Dlookup is 'canceled'

by: Thelma Lubkin | last post by:

I am still struggling with trying to match a user supplied string with strings in a field of a table, where spaces are to be ignored. Arno suggested that I use the Dlookup function, but I...

Microsoft Access / VBA

508

Help with DLookup

by: Don Sealer | last post by:

I've written this expression for a DLookup function. It works almost alright. What I'm trying to do is type in a description and the ID field (number) populates automatically. It works almost as...

Microsoft Access / VBA

2928

Dlookup

by: nzyui | last post by:

Trying to lookup a field from a table called condition this is a separate table not linked to anything: setup as shown Code S M L DG 1 2 3 RI 2 4 5 need...

Microsoft Access / VBA

2259

Help with DLookup/ I'm stumped!

by: Don | last post by:

Can someone help me fix my DLookup problem. I'm far from proficiency with Access. I've been creating databases for several years for work with the help of many of you and trial and error. I have...

Microsoft Access / VBA

3626

Criteria works for FindFirst but not for Dlookup when text containsdouble quotes

by: Denise | last post by:

Front end is Access 2002, back end is linked Oracle tables. My users need to describe things in feet and inches and want to use the standard ' and " abbrevations. On a testing form I go to a...

Microsoft Access / VBA

1747

DLookup Question

by: Breezwell | last post by:

This is probably a simple question for someone out there. I understand that the DLookup function takes has the following syntax: DLookup(expression,domain,) From what I have read, domain can...

Microsoft Access / VBA

6993

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7162

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7197

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6881

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

4584

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3088

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3078

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1411

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

287

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General