| | |
add record in table with button and textbox
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Aug 2005
Posts: 1
Reputation:
Solved Threads: 0
hi,
i have soms big troubles.
can anyone help me?
i have to make a database in access. Now for some functions i need to use vb in forms i made. What is now the problem?
Well, i want to add text to a table by writing my text in a textbox and then push on a button (button and textbox are located in the form), automatically the text disappears and when you open the table in which one you wanted to add the new record, the text is added as a new record.
has anyone a solution for the problem
many thanks
greetz
i have soms big troubles.
can anyone help me?
i have to make a database in access. Now for some functions i need to use vb in forms i made. What is now the problem?
Well, i want to add text to a table by writing my text in a textbox and then push on a button (button and textbox are located in the form), automatically the text disappears and when you open the table in which one you wanted to add the new record, the text is added as a new record.
has anyone a solution for the problem
many thanks
greetz
hi feeder23
ok here is a help from me and i hope this one will help you...but make sure you have your ADO control already with valid connections and everything.
private sub command1_click
with adodc1.recordset
.addnew
.fields("fieldname") = text1.text
text1.text = ""
.update
end with
end sub
i think its done...well just reply if things didnt work out. have a nice day!
ok here is a help from me and i hope this one will help you...but make sure you have your ADO control already with valid connections and everything.
private sub command1_click
with adodc1.recordset
.addnew
.fields("fieldname") = text1.text
text1.text = ""
.update
end with
end sub
i think its done...well just reply if things didnt work out. have a nice day!
![]() |
Similar Threads
- how to delete duplicate record in a table by using SQL query (MS SQL)
- Refresh a table (Java)
- Wysiwyg Sql (MS Access and FileMaker Pro)
- VB with SQL (MS Access and FileMaker Pro)
- error message when I click a button (ASP)
- Adding a record from a table to another (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VB6 & Adobe Pagemaker
- Next Thread: Opening HTML file from Program
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





