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 code I get the error "You
canceled the previous operation" err msg. When clicking on Help I get a
white screen. I haven't got the slightest idea what it means ....
I pinned down that this error comes from the Dlookup function, because if I
put some other text to replace the Dlookup function it works .... here is
the code ... Can anybody help please ?
sBody = sBody & sAanhefNE & vbCrLf & vbCrLf & DLookup("[ISFOLLOWUP1NL]",
"tblMailTeksten ") & _
vbCrLf & vbCrLf & "Met vriendelijke groet," & vbCrLf & vbCrLf & _
"MyName" & vbCrLf & "MyFunction " & _
vbCrLf & "mailto:my****@ myprovider.be" & vbCrLf & vbCrLf & vbCrLf
2  14939 
DLookup() does generate this message if you misspell or misform one of its
arguments. Is there a space or spurious or missing character or misspelling
in one of the names?
To find the problem, open the Immediate Window (Ctrl+G).
Enter:
? DLookup("[ISFOLLOWUP1NL]", "tblMailTeksten ")
Once you get that working, you will have found the problem with your line.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ronny Sigo" <ro********@sky ynet.be> wrote in message
news:40******** *************@n ews.skynet.be.. . 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 code I get the error "You
canceled the previous operation" err msg. When clicking on Help I get a
white screen. I haven't got the slightest idea what it means ....
I pinned down that this error comes from the Dlookup function, because if
I put some other text to replace the Dlookup function it works .... here is
the code ... Can anybody help please ?
sBody = sBody & sAanhefNE & vbCrLf & vbCrLf & DLookup("[ISFOLLOWUP1NL]",
"tblMailTeksten ") & _
vbCrLf & vbCrLf & "Met vriendelijke groet," & vbCrLf & vbCrLf & _
"MyName" & vbCrLf & "MyFunction " & _
vbCrLf & "mailto:my****@ myprovider.be" & vbCrLf & vbCrLf & vbCrLf
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Perhaps:
You don't have a "WHERE" clause in the DLookup() function. Is there
only one record in the table "tblMailTeksten "? If there isn't you
have to have a WHERE clause. E.g.:
DLookup("ISFOLL OWUP1NL", "tblMailTeksten ", "ID=25")
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQDF9mYechKq OuFEgEQLJtACg1p kzsqCxyhUrJGRVl TY6cXqY3hAAoMEL
WQ1wXZxJzp3s2Je ih7ALtGfg
=kNOt
-----END PGP SIGNATURE-----
Ronny Sigo wrote: 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 code I get the error "You
canceled the previous operation" err msg. When clicking on Help I get a
white screen. I haven't got the slightest idea what it means ....
I pinned down that this error comes from the Dlookup function, because if I
put some other text to replace the Dlookup function it works .... here is
the code ... Can anybody help please ?
sBody = sBody & sAanhefNE & vbCrLf & vbCrLf & DLookup("[ISFOLLOWUP1NL]",
"tblMailTeksten ") & _
vbCrLf & vbCrLf & "Met vriendelijke groet," & vbCrLf & vbCrLf & _
"MyName" & vbCrLf & "MyFunction " & _
vbCrLf & "mailto:my****@ myprovider.be" & vbCrLf & vbCrLf & vbCrLf This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Gilles Arnaud |
last post by:
Hello,
I've got a nasty bug and no idea to deal with :
here is the method :
<method>
def denormer(self, var) :
" denorme un vecteur d'entree "
try:
#a = map(self.decerner, self.param, var)
|
by: Giulio |
last post by:
I'm studying Craig Larman's "Applying uml and Patterns" (third ed.)
reading at the book it seems (16.6) that Operations and Methods in a
Class diagram are something different but it's not explained what's the
difference.
I always thought they were the same thing.
Do someone knows what's the difference?
thanx alot
Giulio
|
by: RWC |
last post by:
Hi,
I'm running into a problem with Access XP (SP2) that's driving me up the
wall. It's Error 2001 "You canceled the previous operation". There is no
voodoo going on really when I get this message. The following Dlookup field
is causing this message. All field data types are correct.
DLookup("tDescription", "RelatedTable", "iIntegerField = " &
(DLookup("iIntegerField", "TableOne")))
|
by: John Phelan-Cummings |
last post by:
After creating a button on a (parent) form linking to another (child)
form, I received the following error when clicking on the command
button:
"The OpenForm action was canceled"
No the child form is not a subform.
I should also add that I created code in the properties window stating
that the "child" "number" field on the form (that I was navigating to),
|
by: Alex |
last post by:
my app was working fine in VB.NET 2003 (and framework 1.1). Now with
VB.NET 2005 (framework 2.0) the uploading to an http server (ie.
www.sharebigfile.com) stops with the error "The request was aborted:
The request was canceled" after about 7 MB.
For example, I might be uploading a 73MB file. After about 11% done the
upload aborts. :shake:
It works great for files < 5MB. I can upload those every time.
| | |
by: Scorpio1769 |
last post by:
I've got a macro on an mde. database that has been working for years.
all of the sudden, my user reports to me that upon execution of the
macro, he gets the error message
"The function you entered cannot be used in this expression.
*You may have used a DoEvents,....."
This macro fires on the after update event of a combo box and simply
creates a purchase order number according to the following.
|
by: pukhton |
last post by:
I am getting a yellowish block on Refresh statement under Medication_Name_AfterUpdate, and If i take it out it comes to the End sub... dont know what is goign on?
This is what I have under Text52
=DLookUp("Concentration","medquery")
and under Text54
=DLookUp("Units","medquery")
|
by: paulw4 |
last post by:
I have the code below to run a query, that is created from a "fill in the blanks" form. I am now getting the error "You cancelled the previous operation"
Earlier when I got this I closed the database and open it and the query ran, now it does not run. As far as the form is concerened no "cancellation" was done.
Any ideas, since the message is so generic, I can't find what it is referring to.
Dim db As DAO.database
Dim qdf As...
|
by: news.microsoft.com |
last post by:
I am getting the following error on the return from a function call.It
specically happens on the assignment of the return value from the function
call. No error happens inside the function. The function is returning an
Integer with a value of 1.
Err.number =5
Err.Description=Operation is not supported on this platform.
Err.Source=System.Web
Anyone ever seen this error or can explain why I am getting this? Thanks,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
