Recent content by IMyself

  1. I

    Solved Education Students and Classes

    No, the combo box only shows the first field. I made a combo box next to yours. The student is what you made and Name is mine. it only shows the full name when its clicked.
  2. I

    Solved Education Students and Classes

    Hi Again. I did everything step by step, and there I see the students combo box doesn't show the name, only the ID I also used the same parameters in the Row Source of Your file
  3. I

    Solved Education Students and Classes

    Perfect at all! Many thanks dear
  4. I

    Solved Education Students and Classes

    Wow gorgeous job. Thank you very much for taking time and making this. I Really appreciate it 🙏
  5. I

    Solved Education Students and Classes

    Yes I should do that indeed. Many Thanks 👍
  6. I

    Solved Education Students and Classes

    And I'm very delightful about it, I didn't know about junction table and I guess this is the best solution I could get. But the only thing is that the students name doesn't show up under classes. Is there any chance I can see the students name and last name next to the SIDs ?
  7. I

    Solved Education Students and Classes

    Thank You very much. I guess this is the same thing MaJP told.
  8. I

    Solved Education Students and Classes

    Thank you so much 🙏 I think this is somehow complicated and confusing, and no, it's not homework :)) but I am intermediate in access. The institute teaches only abacus mental mathematic in other Schools in after school, and this is the one and only course. But this course has 6 levels and each...
  9. I

    Solved Education Students and Classes

    Hi, I was making a database for an educational institute, which has classes for each level of education. There are 3 tables engaged together: Schools working with this institute, Classes holding in the schools, and the Students participating in classes. the schools and classes are unique, and...
  10. I

    TextBox condition not working

    Absolutely Right !! Thanks Dear So why that didnt work ?? and what would the "" will do ??
  11. I

    TextBox condition not working

    to be made sure, I did this Also: sub CmdGotoID_Click () msgbox TxtBoxID.Value & Me.ID End Sub and in page have id 2, I did type 2 in text box and clicked the button, and a message popped showing "22" !
  12. I

    TextBox condition not working

    No, Nothing Happens at all
  13. I

    TextBox condition not working

    Hi there... I got a situation and something is wrong. I dont know the problem is with the code or what. there is a text box which is for typing id in it, and a button to go to the record of that id, and I wanted to input a condition like this: sub CmdGotoID_Click () If TxtBoxID.Value = Me.ID...
  14. I

    Play different sounds as Quick as DoCmd.Beep

    this is what I came along: You just need to declare this at first: Const SND_ASYNC& = &H1 or Public Const SND_ASYNC& = &H1 and then modify your code to this: sndPlaySound32 "C:\Windows\Media\Chord.wav", 0 + SND_ASYNC actually found that the SND_ASYNC job is to prevent to form to wait till the...
  15. I

    Play different sounds as Quick as DoCmd.Beep

    So, After hanging around I did some changes: deleting the "Public" statement, and modify the PlayWaveFile , the strSound to music path, because it didnt play! and change SND_LOOP to 0 to prevent non-stop sound playing!! : Sub PlayWaveFile() PlaySound "C:\Windows\Media\Chimes.wav", 0, 0 +...
Top Bottom