Click here to Skip to main content
15,892,161 members
Home / Discussions / Database
   

Database

 
GeneralPlugin to Enterpriser Manager Pin
cbmdk16-Sep-04 23:21
cbmdk16-Sep-04 23:21 
QuestionHow do i insert a blank value? Pin
xiaowenjie16-Sep-04 17:54
xiaowenjie16-Sep-04 17:54 
AnswerRe: How do i insert a blank value? Pin
Mekong River17-Sep-04 6:32
Mekong River17-Sep-04 6:32 
GeneralRe: How do i insert a blank value? Pin
xiaowenjie17-Sep-04 18:59
xiaowenjie17-Sep-04 18:59 
GeneralRe: How do i insert a blank value? Pin
Mekong River18-Sep-04 3:40
Mekong River18-Sep-04 3:40 
GeneralLocking Database Pin
WinDotNet16-Sep-04 0:53
WinDotNet16-Sep-04 0:53 
GeneralRe: help in simple access query Pin
David Salter16-Sep-04 10:37
David Salter16-Sep-04 10:37 
GeneralRe: help in simple access query Pin
Mekong River16-Sep-04 15:22
Mekong River16-Sep-04 15:22 
It is very difficult to search for the last record without any notification for each specific record. In my opinion, you should create one more fied that store a uniqe ID of the record. The structure as follow.

ID    fname    lname    age
1     abc1     bbb      22
2     xyz2     bbb      32
3     klm      css      23


So everytime when you insert new record it will generate the new unique ID. So when you want to call the last record use the following method (suppose that you use Ms access database and DAO.

dim dbs as DAO.Database
dim rst as DAO.Recordset

' Use this code in any procedure where you want to
' call the database.

set dbs = CurrentDb

' Suppose that tblData is the table that store your data.

set rst = dbs.OpenRecordset("SELECT * FROM tblData ORDER BY tblData.ID")

with rst
    if .Recordcount > 0 then
        .MoveFirst
        .MoveLast       ' Populate the recordset.
    end if
    ' Post the record on the form.
    txtId.value = .Field(0).value
    txtfname.value = .Field(1).value
    txtlname.value = .Field(2).value
    txtage.value = .Field(3).value
end with


Try to do it and hope it is working Laugh | :laugh:



A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

QuestionHow to get two or more params' value in the Extend Procedure DLL ? Pin
fu015-Sep-04 22:21
fu015-Sep-04 22:21 
AnswerRe: How to get two or more params' value in the Extend Procedure DLL ? Pin
David Salter16-Sep-04 10:43
David Salter16-Sep-04 10:43 
QuestionCan set auto-increament value in Ms Access database? Pin
DotNet15-Sep-04 21:57
DotNet15-Sep-04 21:57 
AnswerRe: Can set auto-increament value in Ms Access database? Pin
David Salter16-Sep-04 10:34
David Salter16-Sep-04 10:34 
GeneralHelp required for implementing the rowlevel locking trough ADO Connection Object Pin
chintan197915-Sep-04 20:42
chintan197915-Sep-04 20:42 
GeneralRe: Help required for implementing the rowlevel locking trough ADO Connection Object Pin
Steven Campbell16-Sep-04 8:41
Steven Campbell16-Sep-04 8:41 
GeneralRe: Help required for implementing the rowlevel locking trough ADO Connection Object Pin
WinDotNet6-Oct-04 22:50
WinDotNet6-Oct-04 22:50 
GeneralADO Connection Application Pin
Greg Horwood15-Sep-04 16:06
Greg Horwood15-Sep-04 16:06 
GeneralRe: ADO Connection Application Pin
Steven Campbell16-Sep-04 8:30
Steven Campbell16-Sep-04 8:30 
GeneralRe: ADO Connection Application Pin
Greg Horwood16-Sep-04 13:24
Greg Horwood16-Sep-04 13:24 
GeneralRe: ADO Connection Application Pin
RichardGrimmer17-Sep-04 5:37
RichardGrimmer17-Sep-04 5:37 
GeneralRe: ADO Connection Application Pin
Anonymous17-Sep-04 15:23
Anonymous17-Sep-04 15:23 
QuestionHow to connect to MSSQL through SSL channel using ADO Pin
Zro15-Sep-04 15:32
Zro15-Sep-04 15:32 
AnswerRe: How to connect to MSSQL through SSL channel using ADO Pin
Zro15-Sep-04 15:43
Zro15-Sep-04 15:43 
QuestionHo do i connect to an XML file using C#.net? Pin
JDUK15-Sep-04 14:04
JDUK15-Sep-04 14:04 
AnswerRe: Ho do i connect to an XML file using C#.net? Pin
Christian Graus15-Sep-04 15:08
protectorChristian Graus15-Sep-04 15:08 
GeneralRe: Ho do i connect to an XML file using C#.net? Pin
JDUK15-Sep-04 15:27
JDUK15-Sep-04 15:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.