Whe i use a combobox, and i want it to update it's value i use the code
ME.cbxname.Requ ery
How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :( 6 15624
eclypz wrote: Whe i use a combobox, and i want it to update it's value i use the code
ME.cbxname.Requ ery
How can i do that to update the value of a textbox? i have already try to use the same expression, but it doesn't work :(
Let's say you have a combo box with 3 columns. There is a property
called Column that starts at 0. To reference the 3rd column, it could
be column(2)
In the AfterUpdate event of the combo box you could enter
Me.TextBoxName = Me.ComboboxName .Column(1)
to store the value of the second column into the text box.
salad escreveu: eclypz wrote:
Whe i use a combobox, and i want it to update it's value i use the code
ME.cbxname.Requ ery
How can i do that to update the value of a textbox? i have already try to use the same expression, but it doesn't work :( Let's say you have a combo box with 3 columns. There is a property called Column that starts at 0. To reference the 3rd column, it could be column(2)
In the AfterUpdate event of the combo box you could enter Me.TextBoxName = Me.ComboboxName .Column(1) to store the value of the second column into the text box.
Well, is not really that that i want...
What i want is this:
I have a form in which i have one txt box that presents the maximum
value in the table xpto.
to have this informacion, i have a query that give me the maximum, and
then the source in the text box is that maximum.
The value only update when i open the data base, but i want is that
when i click in the button to update the table, in the end of the
actualization that text box will present the new maximum.
Did u understand what i want?
Ah! the data in the table to be presented is date/time.
* eclypz: salad escreveu: eclypz wrote:
Whe i use a combobox, and i want it to update it's value i use the code
ME.cbxname.Requ ery
How can i do that to update the value of a textbox? i have already try to use the same expression, but it doesn't work :( Let's say you have a combo box with 3 columns. There is a property called Column that starts at 0. To reference the 3rd column, it could be column(2)
In the AfterUpdate event of the combo box you could enter Me.TextBoxName = Me.ComboboxName .Column(1) to store the value of the second column into the text box.
Well, is not really that that i want...
What i want is this:
I have a form in which i have one txt box that presents the maximum value in the table xpto. to have this informacion, i have a query that give me the maximum, and then the source in the text box is that maximum.
The value only update when i open the data base, but i want is that when i click in the button to update the table, in the end of the actualization that text box will present the new maximum.
Did u understand what i want?
Ah! the data in the table to be presented is date/time.
If the ControlSource of your textbox is something like:
=DMax("Col", "Table")
Add this to the end of the code that updates the table from your button
click.
Me.Recalc
That will cause it to "recalculat e" that DMax value and update your text
box.
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Randy Harris wrote: * eclypz: salad escreveu: eclypz wrote:
Whe i use a combobox, and i want it to update it's value i use the code
ME.cbxname.Requ ery
How can i do that to update the value of a textbox? i have already try to use the same expression, but it doesn't work :(
Let's say you have a combo box with 3 columns. There is a property called Column that starts at 0. To reference the 3rd column, it could be column(2)
In the AfterUpdate event of the combo box you could enter Me.TextBoxName = Me.ComboboxName .Column(1) to store the value of the second column into the text box.
Well, is not really that that i want...
What i want is this:
I have a form in which i have one txt box that presents the maximum value in the table xpto. to have this informacion, i have a query that give me the maximum, and then the source in the text box is that maximum.
The value only update when i open the data base, but i want is that when i click in the button to update the table, in the end of the actualization that text box will present the new maximum.
Did u understand what i want?
Ah! the data in the table to be presented is date/time.
If the ControlSource of your textbox is something like: =DMax("Col", "Table")
Add this to the end of the code that updates the table from your button click.
Me.Recalc
That will cause it to "recalculat e" that DMax value and update your text box.
-- Randy Harris tech at promail dot com I'm pretty sure I know everything that I can remember.
It Doesn't work :(
I don't know why...
I have this table with this name T00-Documents and then i have the text
box that had in de controlsource =Max([DateRead]![T00-Documents]), but
with this it always appear an error #Error... so what i did was. Create
a Selection Querie from the Table T00-Documents, and in the querie i
put this. Maximu:Max([DateRead]). Then in the controlsource just wrote
Maximu. And Like this it works.... but it only update when i open the
Form.
Now i don't know how to do :(
"eclypz" <eg************ *@gmail.com> wrote in
news:11******** *************@g 10g2000cwb.goog legroups.com: Randy Harris wrote: * eclypz: > salad escreveu: >> eclypz wrote: >> >>> Whe i use a combobox, and i want it to update it's value >>> i use the code >>> >>> ME.cbxname.Requ ery >>> >>> How can i do that to update the value of a textbox? i >>> have already try to use the same expression, but it >>> doesn't work :( >>> >> Let's say you have a combo box with 3 columns. There is a >> property called Column that starts at 0. To reference the >> 3rd column, it could be column(2) >> >> In the AfterUpdate event of the combo box you could enter >> Me.TextBoxName = Me.ComboboxName .Column(1) >> to store the value of the second column into the text box. > > > Well, is not really that that i want... > > What i want is this: > > I have a form in which i have one txt box that presents the > maximum value in the table xpto. > to have this informacion, i have a query that give me the > maximum, and then the source in the text box is that > maximum. > > The value only update when i open the data base, but i want > is that when i click in the button to update the table, in > the end of the actualization that text box will present the > new maximum. > > Did u understand what i want? > > Ah! the data in the table to be presented is date/time. >
If the ControlSource of your textbox is something like: =DMax("Col", "Table")
Add this to the end of the code that updates the table from your button click.
Me.Recalc
That will cause it to "recalculat e" that DMax value and update your text box.
-- Randy Harris tech at promail dot com I'm pretty sure I know everything that I can remember.
It Doesn't work :(
I don't know why...
I have this table with this name T00-Documents and then i have the text box that had in de controlsource =Max([DateRead]![T00-Documents]), but with this it always appear an error #Error... so what i did was. Create a Selection Querie from the Table T00-Documents, and in the querie i put this. Maximu:Max([DateRead]). Then in the controlsource just wrote Maximu. And Like this it works.... but it only update when i open the Form.
Now i don't know how to do :(
=Max([DateRead]![T00-Documents]) OR Max([DateRead])
should be Dmax("[dateread]","[T00-Documents]")
Also put in the form's AfterUpdate Event
me.textbox.requ ery and change textbox to the real name of the
textbox.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
* eclypz: It Doesn't work :(
I don't know why...
I have this table with this name T00-Documents and then i have the text box that had in de controlsource =Max([DateRead]![T00-Documents]), but with this it always appear an error #Error... so what i did was. Create a Selection Querie from the Table T00-Documents, and in the querie i put this. Maximu:Max([DateRead]). Then in the controlsource just wrote Maximu. And Like this it works.... but it only update when i open the Form.
Now i don't know how to do :(
Why didn't you post this to begin with?
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark |
last post by:
A beginner in this area, I have been able to read a record from a
MySQL database and populate an HTML form (wow!). Now, my goal is to
allow the user to edit the contents of the form and then update the
record in MySQL.
The problem is, as soon as the "Update" button (type="submit") is
pressed, all of the data disappear from the form. How can that be
prevented?
Here is my code:
|
by: revolnip |
last post by:
As attached is the code :
<% Option Explicit
dim lngTimer
lngTimer = Timer
%>
<!--#include file="Connect.asp" -->
<!--#include file="Settings.asp" -->
<!--#include file="Common.asp" -->
|
by: toedipper |
last post by:
Hello,
PHP4 and MySql
I have the code below, a mixture of handcoded and Dreamweaver genaratd
php code. Basically it's an update record form - I load the values from
a db and bind text boxes etc. This works ok. But I also have an update
action - if a user changes any of the text box values then he can click
update and the code should write the new values to the db. Should, but
it does'nt! When I go and look in the db I can see...
|
by: M. David Johnson |
last post by:
I cannot get my OleDbDataAdapter to update my database
table from my local dataset table. The Knowledge Base
doesn't seem to help - see item 10 below.
I have a Microsoft Access 2000 database which indexes
computer magazine articles for personal reference.
I am developing a Visual Basic.NET program whose sole
purpose is to enter new records into the database. No
updates to existing entries, no deletions, and no display
|
by: sdash |
last post by:
I'm working on a simple formview screen that should update a SQL Server 2000
record. I'm sure there must be something simple wrong, but when I press
update, the screen refreshes and the changes are not committed to the table.
Can anyone give me some suggestions here?
Thanks in advance (code below)
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EditItem.aspx.cs"
Inherits="EditItem" %>
| |
by: Stephen Plotnick |
last post by:
I'm very new to VB.NET 2003
Here is what I have accomplished:
MainSelectForm - Selects an item
In a public class I pass a DataViewRow to
ItemInformation1 Form
ItemInformation2 Form
|
by: explode |
last post by:
I made a procedure Public Sub Novo(ByVal nova1 As String, ByVal nova2 As
String) that creates a new oledbDataAdapter with insert update select and
delete commads. I also added that commands can change depending how many
columns are in a Table.
I add a new column with this code:
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button4.Click
Try...
|
by: Selvakumar |
last post by:
hai friends,
I am new to .net programming. I did the inserting data into MS-access database but i couldn't able to perform the update command. I used only textbox and command button for inserting and updating the data. I performed Insert command successfully but i donno y the update command is not working.Pls help.. i ve used all possible update commands. i enclosed all my code( comments also)...
Protected Sub Button1_Click(ByVal sender...
|
by: Michel Esber |
last post by:
Hi all,
DB2 V8 LUW FP 15
There is a table T (ID varchar (24), ABC timestamp). ID is PK.
Our application needs to frequently update T with a new value for ABC.
update T set ABC=? where ID = ?
|
by: sirdavethebrave |
last post by:
Hi guys -
I have written a form, and a stored procedure to update the said form.
It really is as simple as that. A user can go into the form, update some fields and hit the update button to update the information which is stored in a SQL database.
In testing we noticed that the form was updating correctly but the update mechanism was also updating the first record of the table in the sql database every time. No error messages are on...
|
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: 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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |