A few data entry form questions

[GridCube]

Good evening to all.

Im doing my first data entry form using visual basic forms, its going pretty well and for the most part its working as i need to.

But a critical issue I can't figure out is if its possible to edit previous entries. I'll explain:

I work on a library and I need to keep a record of which books are given to which people, to consult in the library reading room, so i have a few combo boxes for all the users types and all, then a simple text box for the book id number. Then i need to add two more field, one is the time stamp of the moment i provide the book to the user, and the other is the time stamp of the moment the user returns the book.

I can easily add the first one using simply .Value = Format(Now, "hh:mm:ss"), but thats where the easy parts end.

I figure i need to add an ID column to identify the entries, then somehow call that id number to retrieve all the fields data and only change the fHoraOut field and save again (thats what i used to do when I made some forms using php and mysql)... i hope im making some sense here... anyway here is my code so far:

Please Login or Register  to view this content.

and the columns i have are:

Please Login or Register  to view this content.

the "Observaciones" one is to be filled by me in case i need to manually to the worksheet.

Any help would be greatly appreciated.

[royUK]

Lok at the DatabaseForm example here

[john55]

as an option you can double click in col (what column you want) to add the time

Please Login or Register  to view this content.

[GridCube]

Lok at the DatabaseForm example here

Thanks! I looked at it and it seems pretty much to be what I need, the ability to search and amend entries is exactly what i need.

Now I have to figure out how to add a few comboboxes to it.

Thank you very much again, this has pointed me into what i think is the right direction.


and to john55, thanks for your answer but i don't seem to understand what you meant.