Search results

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.

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

Perfect at all! Many thanks dear

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

Yes I should do that indeed. Many Thanks 👍

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 ?

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

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...

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...

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

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" !

No, Nothing Happens at all

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...

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...

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 +...

You know, when using your code, this part: Public Const SND_ALIAS& = &H10000 Public Const SND_ASYNC& = &H1 Public Const SND_FILENAME& = &H20000 Public Const SND_NODEFAULT& = &H2 Public Const SND_NOWAIT& = &H2000 Public Const SND_RESOURCE& = &H40004 Public Const SND_SYNC& = &H0 Public Const...

Yesssss! Muchas Gracias Amigo ! but actually I combined your code with killerflappy's to work. it modified to this: Private Declare PtrSafe Function sndPlaySound32 _ Lib "winmm.dll" _ Alias "sndPlaySoundA" ( _ ByVal lpszSoundName As String, _ ByVal uFlags As LongPtr) As...

It worked! Many thanks!

It sounds pretty cool! but I guess it is for 32bit version, because I used it in my 64bit version and it didnt work and the below part of code got red: Private Declare Function PlaySound& Lib "winmm.dll" Alias _ "PlaySoundA" (ByVal lpszName As String, _ ByVal hModule As Long, _...

You know what I did again? I made a save button which does the same job as Ctrl-S, and I added this part to your code and it worked too: Private Sub SaveComm_Click() bolSave = True so now I'm a newcomer to vba too thanks to You! and I'm ambitious to learn more!