|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
July 25th, 2003, 01:42 PM
|
|||
|
|||
|
Access: Add Record from fields with command button
I have several fields on a form and I need to be able to add the info from the fields to an existing table as a new record.
For example: Take the info from Text1 & Text2 and put it as new record in the table called 'tblAnalysts' under the fields 'Name' (for text1) and 'Locaiton' (for text2). I pretty much need to know how to access a table (add records, remove records, update/change records), but without having the table linked to the form or text boxes. Hopes this makes sense  I'm not a noob, but certainly not an expert. Any help/insight will be appreciated. thanks, michael
|
|
#2
September 11th, 2003, 02:59 PM
|
|||
|
|||
|
What version of Access are you using? The best way to accomplish this is to use DAO or ADO. If you give me more info I can give you some example code. It is important to know exactly what version of access you are useing as well as what your referances are to DAO and ADO. To get to the references:
Module tab Either double click an existing module or start a new one. Once you are in the VB design window us the toolbar commands: Tools -References
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Access: Add Record from fields with command button |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
