 |  |  |  |  |  |  |  |
Error message due to empty row, (VB6-ADO-ACCESS)
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Question TWO
I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. I use 5 tables with some info in one table to be used in another. Hope it is OK to ask few questions but will put them one by one:
2. I have a button that with the code: DataList.Recordset.AddNew
But if I do not want to fill in the info in runtime I get an error message: "Empty row cannot be inserted.Row must have at least one column value set." Any suggestions?
Per
I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. I use 5 tables with some info in one table to be used in another. Hope it is OK to ask few questions but will put them one by one:
2. I have a button that with the code: DataList.Recordset.AddNew
But if I do not want to fill in the info in runtime I get an error message: "Empty row cannot be inserted.Row must have at least one column value set." Any suggestions?
Per
•
•
•
•
Originally Posted by peroberg 
Question TWO
2. I have a button that with the code: DataList.Recordset.AddNew
But if I do not want to fill in the info in runtime I get an error message: "Empty row cannot be inserted.Row must have at least one column value set." Any suggestions?
Per
Field1_Data = InputBox("Field1")
Field2_Data = InputBox("Field2")
etc...
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
Luck!
OK, thanks however was not able to get it right.
Gets error "Expected Function or variable".
Marked is "Private Sub ..." with yellow and
marked with blue is on the first line ".AddNew"
So what have I missed?
Have a nice day
Per
Gets error "Expected Function or variable".
Marked is "Private Sub ..." with yellow and
marked with blue is on the first line ".AddNew"
So what have I missed?
Have a nice day
Per
|
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: PLz Help
- Next Thread: how to make my vb6 program become a installer
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 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 timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
