i made this
private sub date_afterupdat e()
dim huidigeDB as database
dim rsklanten, rspunten as recordset
set huidigedb = currentdb
set reklanten= huidigeDB.openr ecordset('tblle veranciers", dbopentable
set rspunten = HuidigeDB.openr ecordset("qryto taalspel", dbopendynaset
reklanten.movef irst
rsklanten.indes = "primaryKey "
rspunten.movefi rst
do until rsklanten.eof()
rsklanten.seek "=", rspunten!Levid
rsklanten.edit
rsklanten!punt4 = rspunten!sumOfa anwezigpunten
rsklanten.updat e
rspunten.movene xt
rsklanten.moven ext
loop
rsklanten.close
rspunten.close
de bedoeling is met de qrytotaalspel heb ik van het veld aanwezigpunten het
totaal berekend die sumOfaanwezigpu nten zie als naam
dat totaal wil ik plaatsen in tabel tblleveranciers
bij het laten lopen van dit stukje code
stop hij steeds op
run-time error 3061
to few parameters.expe cted 1.
deze foutmelding zegt mij niets
enfin: ik heb een tabel tblpunten met punten, ik wil daarop met een qeury
een totaal berekenen per speler van het totaal aantal punten en dit totaal
wil ik in een veld zetten van de tabel leveranciers bij de overeenkomstige
speler
ik werk er al een week op.....lukt mij niet.....
is hier iemand met dergelijke routine???
dank u....
1  2719 
I didn't get farther than the first line.
private sub DATE_afterupdat e
You named your field, [Date]? Do you have, by any chance, another one
named [Number] or [Text] or [Memo]? How about [ASC] or [DESC]?
Fortunately, the VBA editor doesn't allow you to name variables with
keywords like Dim string As Integer or Dim double As Object. It
crapps out and says, "You can't do that!"
Access table designer, however, does allow you to shoot yourself in the
foot. Maybe I'm wrong, but I bet you have a column in your table named
Date and you placed that on a form as a text box, which got the name Date
with a recordsource of Date.
The way I figure it ...
Date_AfterUpdat e = Tomorrow at Midnight + 1 second
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com
"Foxie Foxster" <ve************ @skynet.be> wrote in message news:3f******** **************@ reader3.news.sk ynet.be... i made this
private sub date_afterupdat e()
dim huidigeDB as database
dim rsklanten, rspunten as recordset
set huidigedb = currentdb
set reklanten= huidigeDB.openr ecordset('tblle veranciers", dbopentable
set rspunten = HuidigeDB.openr ecordset("qryto taalspel", dbopendynaset
reklanten.movef irst
rsklanten.indes = "primaryKey "
rspunten.movefi rst
do until rsklanten.eof()
rsklanten.seek "=", rspunten!Levid
rsklanten.edit
rsklanten!punt4 = rspunten!sumOfa anwezigpunten
rsklanten.updat e
rspunten.movene xt
rsklanten.moven ext
loop
rsklanten.close
rspunten.close
de bedoeling is met de qrytotaalspel heb ik van het veld aanwezigpunten het
totaal berekend die sumOfaanwezigpu nten zie als naam
dat totaal wil ik plaatsen in tabel tblleveranciers
bij het laten lopen van dit stukje code
stop hij steeds op
run-time error 3061
to few parameters.expe cted 1.
deze foutmelding zegt mij niets
enfin: ik heb een tabel tblpunten met punten, ik wil daarop met een qeury
een totaal berekenen per speler van het totaal aantal punten en dit totaal
wil ik in een veld zetten van de tabel leveranciers bij de overeenkomstige
speler
ik werk er al een week op.....lukt mij niet.....
is hier iemand met dergelijke routine???
dank u....
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: lawrence |
last post by:
I'm not sure how this is normally done, on a large site, perhaps one
running Phorum. Occassionally a thread will have hundreds of entries,
perhaps a meg or two worth of data. You won't necessarily print all
that to the screen, but PHP has to hold it in memory. Run some
operations on it, or, more likely, have an array that you keep adding
things to, and very soon you run into the 8 meg limit that is the
default limit for PHP scripts.
...
|
by: Jenbo |
last post by:
I know this has come up frequently but I can't seem to put my finger on
the precise problem as it applies to me. I have a workgroup with a 2003
box with Sql server on it. Also, on this, I have an XP pro machine. So
the xp pro machine is running IIS. When I try and open a connection to
the Sql Server I get the Sql Server does not exist etc.
I am wondering what I need to do to correct this exactly. Because it is
on a workgroup and not a...
|
by: David Mathog |
last post by:
If this:
int i,sum;
int *array;
for(sum=0, i=0; i<len; i++){
sum += array;
}
is converted to this (never mind why for the moment):
|
by: Hazz |
last post by:
In this sample code of ownerdraw drawmode, why does the '(ComboBox) sender'
line of code need to be there in this event handler?
Isn't cboFont passed via the managed heap, not the stack, into this
cboFont_DrawItem event handler? Why does it need to be cast? -hazz
,.................
cboFont.Items.AddRange(FontFamily.Families);
}
private void cboFont_DrawItem(object sender,
|
by: Anoop |
last post by:
Hi,
I am new to this newsgroup and need help in the following questions.
1. I am workin' on a GUI application. Does C# provides Layout Managers the
way Java does to design GUI? I know that it can be done using the designer
but I intentionally don't want to use that. The one reason is that you
cannot change the code generated by the designer. The other could be that
you have more free hand and control to design your GUI.
2....
| | |
by: Cuthbert |
last post by:
After compiling the source code with gcc v.4.1.1, I got a warning
message:
"/tmp/ccixzSIL.o: In function 'main';ex.c: (.text+0x9a): warning: the
'gets' function is dangerous and should not be used."
Could anybody tell me why gets() function is dangerous??
Thank you very much.
Cuthbert
|
by: webEater |
last post by:
I have a problem, it's not browser specific, and I don't get a
solution. I have an (X)HTML document, I show you a part of it:
....
<!--<div class="pad">-->
<div id="eventImages"><img src="" id="eventImage0"
class="eventImage"><img src="" id="eventImage1"
class="eventImage"></div>
|
by: =?Utf-8?B?UmF5IE1pdGNoZWxs?= |
last post by:
Hello,
I know I sound like a one-note Johnny on this but I'm still looking for a
solution. I need to display characters coming in from a serial port or a
socket. I also need to be able to type characters into the display myself -
but that's not the main issue at this time. I've tried a scrolling multiline
text box but once the original viewable area fills up and it starts scrolling
the flashing of the entire area drives me nuts. The...
|
by: =?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?= |
last post by:
I get the above error in some of the ASP.NET web applications on a
server, and I need some help figuring out how to deal with it.
This is a rather long post, and I hope I have enough details that
someone who bothers to read all of it have some pointers.
Note, I have posted the stack trace and the code exhibiting the problem
further down so if you want to start by reading that, search for +++
Also note that I am unable to reproduce...
|
by: Sh4wn |
last post by:
Hi,
first, python is one of my fav languages, and i'll definitely keep
developing with it. But, there's 1 one thing what I -really- miss:
data hiding. I know member vars are private when you prefix them with
2 underscores, but I hate prefixing my vars, I'd rather add a keyword
before it.
Python advertises himself as a full OOP language, but why does it miss
one of the basic principles of OOP? Will it ever be added to python?
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
