Thanks once again Alex.
I've sussed it now. Now I like the idea of a creating a login screen and ID, which would automatically be entered to this field. Have you done this type of work before?
Regards
Cristobalito
Hello Darrylles
thanks for your comment. I'm a bit naieve with access. I've put a field named 'UpdatedBy' now where do I put the 'Textbox = CurrentUser()'?
Sorry to bother you again
Kindest Regards
Cristobalito
OK Folks,
I've had success! Thank you all very much.
What I did was to create a one to many relationship between the main table and the version table. Then I created a main form with a subform embedded. I've added a button to the subform to update the versions as required. Yippee, one task of...
Thank you for your idea Nigel. This access stuff is quite complex hey! But I think with people like you guys around things should become manageable and acheivable for me..
kindest regards
cristobalito
Thank you all for your guidance. Your tips seem most usful for me.
I think I have understood the table linking concept very well. However, how do I get a user to input the data into the right tables using forms? Should I have a 'new version' button which changes all the input boxes to point at...
Hello EJC
thanks for your reply. I'm a bit new to VBA, can you tell me are your selected items stored within one field related to one record as this is what I'm trying to acheive? I think I some how need to seperate the selected list box items with a comma so that they can be stored into the...
Hello again dear people
I have another issue. This time related to different versions of one record.
For example, I have main table where a new record would be entered. In a few months' time, the user may need to update some of the information related to that record. However, I do not want...
Hello dear people
When I use multi select on a list box, the selected items are not stored into the underlying table. In addition, when I move to the next record, the same values remain displayed on the list box.
I want to be able to store the chosen values with one record in the table, then...
Hello iainm
thank you very much for your suggestion. I do not want to strain your patience and help, however, i'm not as far on as you think! I'm not sure how to generate the table you suggested and then the accompanying form! If you can offer help here as well I could then go on to try and use...
Hello, has anyone managed to multi select on a treeview control? I want to create a treeview with checkboxes so that if a parent node is 'checked' all the child nodes are automatically checked. then i want to be able to save all the checked nodes, parents and children, as a record in my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.