Hi
File attached.
My problem:
When i change an entry in database ("change" button in form), it only change one cell in the row.
Hi
File attached.
My problem:
When i change an entry in database ("change" button in form), it only change one cell in the row.
...more precise; it only changes the "user name", not other contents when I try change that.
This should al work now.
Thanks Roy for going through all my vbas. The change button works properly now. Nice!
But there came two new problems, perhaps you have a solution for that too?
1: The listbox in form do not have headings longer.
2: But more importenly, I want the newest entries to be first/at the top in the table/listbox, (because newest will be most relevant for users to look at).
You have defined the RowSource manually . I have changed it to be changed within the code, but the HeaderRow does not work as expected.
I have added a separate ListBox that shows the headers, which is much better for the coding.
The code also now sorts the dates so that the latest is at the top
Thanks, the list headers is a good solution for keeping the headers in listbox.
About date, and sorting, it seems like it dont get a date-format, and so the sorting dont get right.
You need to use a proper date format in the worksheet. I thought you wanted that format.
Yes, it is the format dd/mm/yyyy i want to use, and it seems like that format in the worksheet, but excel doesnt recognize it as date, but text, and therefore it sorts wrongly. The april line stays at the top, and latest dates seems to place randomly. I have tried to change format both in worksheet and vba, but cant get it right.
It isn't that format in the sheet.. You use 02.05.2020, which is not a Date Format
Don’t have an account yet? Register yourself now and be a part of our community!