|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 21st, 2004, 07:39 PM
|
|||
|
|||
|
Update a table from a form
This is what I have setup so far:
2005Table 2005ID 2005Num I have a form that has a hidden unbound text box that is setup to add one to 2005Num =DMax("2005Num","2005Table") + 1 What I want it to do is be able to save the unbound textbox to 2005Num in 2005Table and be able to display it later. Hope this is enuff info. Thanks!
|
|
#2
March 22nd, 2004, 10:29 AM
|
|||
|
|||
|
Search the forum for this attached sample DB "VBAUnbound.zip" It shows you how to update tables with unbound forms using ADo or DAO. You can program you form to use you new ID you have created. Through the use of unbound form you don't half to use hidden text boxes and ( would recommend not finding you ID this way if you have a multi-user enviorment) can still get what you want.
S-
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Update a table from a form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
