473,738 Members | 6,332 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Formular

Hallo zusammen,

ich habe folgendes Problem:

Ich habe ein Formular in dem ein Gesamtwert in einem Feld errechnet
wird. Jetzt möchte ich diesen Gesamtwert automatisch in ein anderes
Feld im nächsten Formular übernehmen. Ist dies möglich?
Hinzu kommt: Diese Gesamtsumme ist abhängig von einer Nummer (d.h.
wenn ich mit einer Nummer einen Gesamtwert errechne dann kann ich
natürlich im nächsten Formular auch nur mit der Gesamtsumme rechnen,
wenn die Nummer noch übereinstimmt. Sollte eine andere Nr. eingegeben
werden muss natürlich neu -mit einer anderen Zahl gerechnet werden
d.h, immer Nummerbezogen. Ich habe keine Möglichkeit gefunden dieses
Problem zu beheben. Habe auch schon einige FAQs abgesucht - leider
ohne Ergebnis. Vielleicht habt ihr ja eine Idee??? Ach so bevor ich es
vergesse ich habe Microsoft Access 2000.
Ich bedanke mich schon mal für ihre Bemühungen.
Nov 13 '05 #1
1 2807
Niko Mann wrote:
Hallo zusammen,

ich habe folgendes Problem:

Ich habe ein Formular in dem ein Gesamtwert in einem Feld errechnet
wird. Jetzt möchte ich diesen Gesamtwert automatisch in ein anderes
Feld im nächsten Formular übernehmen. Ist dies möglich?


Wollst du diese Wert auch speichern? Ich hoffe nicht.
Wenn es nur gezeigt werden muss, wuerde ich einfach dieselbe Formular
verwenden (copy-paste).

Welches Verhaeltnis besteht zwischen die Nummer und die Gesamtwert? Ist
die Nummer irgendwie eine Reihenfolge, oder Schluessel? Dann erfolgt es
immer ueber eine Query, tatsaechlich.

zz Man redet hauptsachlich Englisch hier. Wenn ich die Frage nicht gut
verstanden habe, koennte es noch der Sprache halber sein.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

63
5924
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that would eliminate the Access version problem as well I guess.
13
2949
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded. I believe a dotNet solution is better, but I'm trying to be as convincing as possible -- and maybe I'm wrong! I would appreciate any input or references which could help me.
2
3807
by: amir | last post by:
Hallo liebe Gemeinde, ich möchte aus einem Formular aus, eine bereits vorhandene Laufendenummer aus einer Tabelle.spalte auslese und dazu noch eine 1 addiere und dann das Ergebnis in ein Textfeld dieses Formulars schreiben! Danach werden weitere Daten von dem User eingegeben und dann werden alle diese Daten (die neue Laufendenummer auch) in der gleichen Tabelle als neuer Datensatz gespeichert. Ich denke an:
3
2064
by: James P. | last post by:
Hello there, I'd like to have my minutes convert to hours and minutes in Access report in this format: hh:mm. For examples: 150 minutes converts to 2:30. I have this formula below used to work with my machine using Access 2002 SP3. =\60 & Format( Mod 60,"\:00") However, if I run it on someone else's machine who has a newer
0
1152
by: Brunner | last post by:
Hi, I'd like to print a diagram which is embedded in a formular. The only possibility I found is to draw the diagram in print event handler by hand on a Graphics. However this seems to be very circumstantial, because the diagram already exists on that formular. Is there a way to print the diagram or the whole formular without redrawing it manually? thanks.
2
1435
by: k.bel | last post by:
The table I created is very easy: it consists of one field "Nomen" (datatype 'text' size 50) and 10 fields m1 to m10 datatype 'text' size 3. Now, having an array of some records with different "Nomen" and after that to fill m1 of the first record with 1 and m1 of the second with 2 by using the "down"-key for going forward, MS-ACCESS will fill m1 of the following records automatically with 3; 4; 5;.... when only using the "down"-key. The...
2
8592
by: bill.gates | last post by:
Hallo, Ich bin absoluter Access Anfänger und würde gerne ein Startformular in Access erstellen. In diesem Startformular soll der Benutzer seinen Namen und sein Passwort (zuvor gepflegt in der Tabelle Benutzer) eingeben und je nach dem welchen Benutzernamen er eingibt kommt schließt sich das Startformular und öffnet sich ein Stammdatenberarbeitungsformular oder Auswertungsformular oder oder oder.
1
2788
by: G.Weinerth | last post by:
Hallo zusammen, ich suche ein Ereignis, das ausgelöst wird, wenn eine Access-Datenbank inaktiv wird. (Access 2003) Hintergrund ist: Anwender macht ACCESS-Datenbank auf und arbeitet damit, lässt geöffnetes Formular stehen. Anschließend arbeitet der Anwender im Word weiter. Jetzt schlummert die Access-DB im Hintergrund.
1
1436
by: jamesonworld | last post by:
Hi I am finding it hard to understand the script below <SCRIPT language=JavaScript> <!-- Begin var i = 0; // interest var m = 0; // months var f = 0; // factor var den = 0; var s = "0"; // string var d = 0; // decimal place
0
8968
marktang
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...
0
8787
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,...
0
9208
tracyyun
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...
1
6750
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6053
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();...
0
4824
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3279
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 we have to send another system
2
2744
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2193
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.