Recent content by Jesmine

thx Thax ReAn for your help through chatting! ;-)

thx :-) Thank you RichO... your simple totals query fixed my problem... once again thank you very much :-) Zena

Help about counting!!!! Hello, I have students table and I want to make one report that gives me the number of males and females, is that possible??? :confused: Thx in advance Zena

SELECT COUNT(ID) AS [Females Number] FROM MyTable WHERE Genger ="Female" CELECT COUNT(ID) AS [Males Number] FROM MyTable WHERE Gender = "Male" Good Luck! Zena

:( I still can't figure out what is the problem with my code.... so is there anybody can help me please!!!! :(

thx IP... I'll read it tonight ;-)

Hello all! thx Col for the link ;) ... I'm not that skilled with VBA, but a friend of mine who knows nothing about VBA asked me for a favor and I really wanted to help her... But I can figure out what's the problem with what I have done so far!!! When I'm Adding a new city the function in...

Well, when I wrote this code Dim strSQL As String If MsgBox("Are you sure that you want to add this new Record?", vbYesNo) Then DoCmd.RunSQL ("INSERT INTO City_T VALUES('" & Me.cmb_City.Text & "')") End If cmb_City.RowSource = "SELECT City_T.City...

thx Thaks Rich and sfreeman@co.mer (Sam_F) for you help Rich please is it possible to tell me where I can find those examples you told me about them? thank you both once again

The problem is that I have a table called student, and in it there is a city field... in the student form I want to get the student's city from a combo box which gets it's information from the city table.... now if the student is from a city doesn't already exists in the city table... I want to...