I seriously need some help with this simple DAO DB!

[haruki]

Take a look at this project.


I HAVE NO IDEA how to make this work!!

When I press delete it should delete the record im currently on, and when it has deleted it it should view the next record.

Ex; I want to delete record nr 3 out of 5. When it is deleted it should view the 4 / 5 but as the 3'rd record is deleted it will be 3 / 4.

I cannot make this work, the MoveLast and AbsolutePosition, RecordCount is confusing. CAN anyone help?

I've included the project.

[Fishy]

Hi I'm having a look at your project I'm trying to get the record position in the cmd_delete and then working from there. Not very good with DAO. I'll try again later.

Fishy

[haruki]

Thnx. I appreciate it!

[Fishy]

Hi,

I think I've sorted it. If not I'll look again. Yes ADO is much better and easier.

[haruki]

Yes, I agree. Thats why I use it now, I didnt know if I would get an answer so I looked for some ADO examples at pscode and build up the applikation all over again.


A question. Can I load the database without a ADODC ?

[Fishy]

It Just depends on the driver you are using to get the data and controls to
show it.

[haruki]

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;Persist Security Info=False


Is there another way to load a database than using a ADODC controller.

[si_the_geek]

Yes, you can just use an ADODB Connection and Recordsets, there is a tutorial at the top of this forum which explains how to do it