Very Computer

Using the VB Data Forms Wizard in VB5, I've created a form with a dozen
fields in it; 6 from Table A and 6 from Table B. The code just places a data
control on the form, points all the text boxes towards this control as their
data source, and throws add, delete, refresh, update, and close buttons on.
I'm sure everyone has played with this feature when doing their first
database application.

Standard fare, but I have a problem with this, for if I type anything into a
text box or modify the contents of a text box, the field in the underlying
table gets updated automatically, without needing to press the update
button. Closing the form and re-opening it, or exiting the application and
looking at the database with some other method, and there is the new data.
This is not good, as I want to have to press the update button to update,
not just have it siphon in as soon as I type.

Is there a fix for this? I've looked at some sample applications done the
same way, and they all suffer the same problem: the update button is
redundant and the data in the underlying tables is modified live.
--
Win95 Error: 079 Mouse not found - A mouse driver has not been installed. Please click the left mouse button to continue.  
----------------------------------------------------------------------------
Plexus Technologies Pty. Limited. Electronics Consulting, Research & Development.
http://www.plexus-technologies.com
Mobile: +61 (0)411 470 880
ICQ: 719010

That's what it means when it says the text boxes are bound to the data, it
goes both ways. You could have them not bound, then cycle through each text
box and put their values into the database when the user clicks on the
update button. The update button is normally for multi-user apps to see any
changes another user has made.

Quote:>---------------------------------------------------------------------------
-
>Plexus Technologies Pty. Limited. Electronics Consulting, Research &
Development.
>http://www.plexus-technologies.com
>Mobile: +61 (0)411 470 880
>ICQ: 719010

Buy a book before starting in this manner!

These datacontrols behave this way because you haven't learned to suppress
this behaviour yet!

(Validate event, UpdateControls)

Dean Malandris heeft geschreven in bericht

Quote:>Using the VB Data Forms Wizard in VB5, I've created a form with a dozen
>fields in it; 6 from Table A and 6 from Table B. The code just places a
data
>control on the form, points all the text boxes towards this control as
their
>data source, and throws add, delete, refresh, update, and close buttons on.
>I'm sure everyone has played with this feature when doing their first
>database application.

>Standard fare, but I have a problem with this, for if I type anything into
a
>text box or modify the contents of a text box, the field in the underlying
>table gets updated automatically, without needing to press the update
>button. Closing the form and re-opening it, or exiting the application and
>looking at the database with some other method, and there is the new data.
>This is not good, as I want to have to press the update button to update,
>not just have it siphon in as soon as I type.

>Is there a fix for this? I've looked at some sample applications done the
>same way, and they all suffer the same problem: the update button is
>redundant and the data in the underlying tables is modified live.
>--
>Win95 Error: 079 Mouse not found - A mouse driver has not been installed.

Quote:>---------------------------------------------------------------------------
-
>Plexus Technologies Pty. Limited. Electronics Consulting, Research &
Development.
>http://www.plexus-technologies.com
>Mobile: +61 (0)411 470 880
>ICQ: 719010