1 Attachment(s)
I seriously need some help with this simple DAO DB!
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.
Re: I seriously need some help with this simple DAO DB!
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
Re: I seriously need some help with this simple DAO DB!
1 Attachment(s)
Re: I seriously need some help with this simple DAO DB!
Hi,
I think I've sorted it. If not I'll look again. Yes ADO is much better and easier.
Re: I seriously need some help with this simple DAO DB!
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 ?
Re: I seriously need some help with this simple DAO DB!
It Just depends on the driver you are using to get the data and controls to
show it.
Re: I seriously need some help with this simple DAO DB!
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.
Re: I seriously need some help with this simple DAO DB!
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 ;)