Search results

  1. K

    How to show related values in i subform.

    Hello people I have a form with two subforms within it. The first subform displays a table named "tblCalculation", the second subform displays table named "tblSubCalculation". The two tables are related in a one to many relationship as follows: "tblCalculation" [ one -> many ]...
  2. K

    How to add a new child record in a one to many relationship using vba

    Hi I have two tables, "tblCase" and "tblProject", they are related in a one-many relationship, so that I can have many Projects for each record in "tblcase". "tblCase" is parent "tblProject" is child. - I have a form with a listbox "lstProject", that shows the records in "tblProject". - In...
  3. K

    How to auto select first item in listbox when form opens

    Hello people If I have a listbox in a form. How can I make sure that the first item in the listbox is allways selected when I open the form? thx
  4. K

    How can I relate a table in a subform to a selected record in a list?

    Hello people I have a form with a list named "lstCases". This list shows the content of a specific table named "tblCases". I want to make a subform in the main form which shows the content of another table named "tblCalculation", which is related to the table "tblCases" in a one to many...
  5. K

    How to, automatically relate a new record to another record

    Hello people I have two tables "tblUser" and "tblCase" which are connected through a joint table "tblUSerCase" in order to make a many to many relationship. The tables has been build as follows: tblUser: ID (Primary key / Autonumber) First name Last name User name etc... tblUserCase...
  6. K

    Showing related records in a listbox.

    Hello people So I have a many to many relationship between two tables named "tblUser" and "tblProject". The tables are joined with a joint table named "tblUserProject". The idea is that a user can have many projects, and a project can have many users. I have also made a form with two...
  7. K

    Edit listbox from subform.

    Hello people I have been searching for this, but as I am a newbee in access, I find it difficult to understand the solutions given for other peoples projekts. So I will ask the question as if it was related to my problem only. I have mainform with a listbox, and subform with some textfields...
  8. K

    Edit listbox from subform.

    Hi guys I have a form with the name "frmMainMenu". In this form i have a listbox with the name "LstUsers", and a button with the name "edit". The listbox contains the records from a table named "tblUsers". In this table I have the following fields: "Name" "Last name" "User name" When I...
  9. K

    Hello people

    My name is Adam, I am from Denmark, and I am electrical engineer. Graduated 2 years ago. I have some programming experience with different languages like C, C++,Java, Matlab, and python, but mostly from courses at university, and small projects. I am now working for a small consulting...
Top Bottom