 |  |  |  |  |  |  |  |
Create new row in table
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
I am trying to create a database for the inspection of properties.
I have a created a table and form with the following 6 fields.
InspectionID Index Primary Key
PropertyAddress Address of the property Text
DateOfInspection Date of inspection format dd/mm/yyyy
InspectionDone Y/N tick box
InspectionBy Lookup
Comment Memo
What i am trying to do is initially for each property i will type in the information example in datasheetview
PropertyID PropertyAddress InspectionDate InspectionBy Inspecti
1 Gedding Road 73 08/04/2009 Ash -1
2 King Edward Road 25 06/04/2009 Salim 0
3 Trevino Drive 61 10/04/2009 Ash 0
What i am trying to do is once an inspection is done, and the box INSPECTIONDONE is clicked a new record is created in the next row with the following informatin
InspectionID to change to the next number up
PropertyAddress to stay the same
DateOfInspection to change to current date plus 3 months
InspectionDone to stay the same
InspectionBy to stay the same
Comment to stay blank
I hope you understand and help me sort out the code
Rafik
Ps for those who surf the forums I did post this elsewhere but have not solved the problem.
I have a created a table and form with the following 6 fields.
InspectionID Index Primary Key
PropertyAddress Address of the property Text
DateOfInspection Date of inspection format dd/mm/yyyy
InspectionDone Y/N tick box
InspectionBy Lookup
Comment Memo
What i am trying to do is initially for each property i will type in the information example in datasheetview
PropertyID PropertyAddress InspectionDate InspectionBy Inspecti
1 Gedding Road 73 08/04/2009 Ash -1
2 King Edward Road 25 06/04/2009 Salim 0
3 Trevino Drive 61 10/04/2009 Ash 0
What i am trying to do is once an inspection is done, and the box INSPECTIONDONE is clicked a new record is created in the next row with the following informatin
InspectionID to change to the next number up
PropertyAddress to stay the same
DateOfInspection to change to current date plus 3 months
InspectionDone to stay the same
InspectionBy to stay the same
Comment to stay blank
I hope you understand and help me sort out the code
Rafik
Ps for those who surf the forums I did post this elsewhere but have not solved the problem.
|
Similar Threads
- create graph/table (C#)
- Update 1 row from a table (PHP)
- Create Pagination table or GridView - .NET C# (ASP.NET)
- How To get the 5th row from a table. (MS SQL)
- Create an extra table (copy the columns and new table) for every existing table (MS SQL)
- Create HTML Table with Dynamic Rows (PHP)
- how to create a sql table through coding in vb.net (IT Professionals' Lounge)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: vb insertion problem
- Next Thread: Hangman Game
| 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
