Recent content by MK1999

  1. M

    show name in a combo box but store id

    what i did is Form bound to Program, subform bound to Program_coordinator with a combobox to select coordinator and control source for the combobox is coordinatorID row source is coordinaterID, name with 2 columns.. when the user click on the drop down menu is shows both name and id.. but from...
  2. M

    Export Report to Excel. Columns move position

    just got the same problem.. you mean delete the text boxes and put them again?
  3. M

    show name in a combo box but store id

    But the name only store in coordinator table, and store the ID using coordinator_program table. in order to avoid duplicates name.. here is the ERD
  4. M

    show name in a combo box but store id

    yes.. ID from the composite table (cooridnator_program) and name from coordinator table.. then is there any way to do this?
  5. M

    show name in a combo box but store id

    hi! thank you i followed this tutorial.. it shows the name but i got this error.. the arabic says cordinator_program.ProgramId !
  6. M

    show name in a combo box but store id

    it show s the name but i got in error (oyu must inpur value from id) something like that
  7. M

    show name in a combo box but store id

    hello, i have a table [coordinator] and table [program] linked together through table [coordinator_program] which contain primary keys of both.. i have a form with combo box that let the user choose the coordinator of program but it shows the id because the record source is coordinator id from...
  8. M

    How to update ID

    the problem is that the other tables have incorecct infomation because the number is diffrenet from this table to the others
  9. M

    How to update ID

    hello, i have a table with a relationship with other tables.. i want to update all table records id to be in order (it is already autonumber but i needed to delete some records so there is a gap) i dont want to keep the gap is there is anyway code to update all the records to be in order?
  10. M

    Solved how to listbox for specific record

    thankyou but didnt work.. same issue blank listbox
  11. M

    Solved how to listbox for specific record

    hi, i want to view all programs for a coordinator to appear in a listbox with other information such as year.. i wrote this command Dim stringCo as string StringCo = "SELECT [CoordinatorID],[year],[nameÌ],[Co_name]" & "FROM Qco" & _ "WHERE [CoordinatorID] = Me.CoordinatorID.Text"...
  12. M

    dropdown menu in subforms

    thank you problem solved! but is there is any way to show the name in the combo box instead of Id's? but store the id
  13. M

    sort a list box from newest record to oldest

    hello, i have a list box including program name, year, code when the user click on the search bar the records pop up to the list box i want to sort the records from the newest one to the oldest (descending order) is there any way to set descending order in the setting or a code that will sort...
  14. M

    dropdown menu in subforms

    but how it will go the same trainer record by id for example? because if insert a name even from a combo box it create new trainer with new id.. it will be hard to retrieve trainer information.. here is the relationship
  15. M

    dropdown menu in subforms

    thank you.. now i have a combobox.. but to clarify this.. when i insert the name its create a new record. The point is i dont want to duplicate the trainer name if it is already exists in the database.. because after i i will create a page when the user click on the trainer name it will show all...
Top Bottom