Recent content by Raabi

Bravo! It worked. It really worked. You have made my day. I have best wishes for you, the real geek! Best regards.

Thanks again. SQL string for the qryStudentsByClass is: PARAMETERS [ClassName] Text ( 255 ); SELECT tblStudents.StudentID, tblStudents.StudentName, tblStudents.DOB, tblStudents.Class, (Date()-[DOB])/365.25 AS Age, tblStudents.Section, tblStudents.FatherName, tblStudents.ContactNum...

Further to my previous reply, please note that I am using the Query because it contains a calculated field, Age, as well.

Thanks Sneuberg for your attention. I tried your suggestion, with exactly the same result it is still prompting for the ClassName. Further suggestion will be appreciated.

Hello geeks! I am grappling with the Query design view of Access 2013 for two days, day and night, in the following way :-( It is a very simple Query, named "qryStudentsByClass" with a few fields, notably: StudentID, StudentName, DoB, Age (Calculated field), and Class etc. I have entered the...

Thank you very much, nIGHTmAYOR for the tip.

Hello everybody I have an Access Form with a number of controls - all bound to different Fields from a Table. Everything is working fine except 2 problems, as below. I need to find a value of a Field of the Current Record, in the bound Table; which is not associated with any Form Control. I...

Yah! this is much easeir to understand and to remember. Thanks DCrake for the tip.

Sorry, I have another problem with testing the form status. Please refer to my following code: Private Sub Form_Open(Cancel As Integer) Dim Msg As String Msg = "Please Open the 'frmViewEdit' Master-form to view this." If SysCmd(acSysCmdGetObjectState, acForm, "frmViewEdit") <> _...

Thanks for the help, Ajutrumpet. But, the constant conObjStateClosed does not seem working. However, if that is replaced by acObjStateOpen, it is all right. I just wonder, if there can be a simpler (more digestable :-)) solution for finding the form status, as well.

Good day everybody I am making good progress in my project with the help of you geeks. Presently, I am facing couple of problems as below. I want to know; if a particular form, "frmViewEdit" for example, is open or not. If a user tries opening a Child-form, it should see the Parent-form...

Hello geeks The Custom Menus are working fine with MS Access 2003; but they fall under AddIn menu. Is there a way to move them out on the main Ribbon? Please help.

Hi Wayne Actually, most of the time I am looking for the solutions for academic purpose. Still I could not find fully automated way to find the max. possible size of a record. I am still expecting there mus be a function, or something like; SizeOf(dbStructure) etc. Because, I remember there...

Hi Wayne It seems I have offended; which I never mean. I asked for a professional answer just out of frankness. Anyhow, sorry for the unintentional expression. Regards,

Salute to you, Dreamdelerium for so precise and accurate tip. Thank you very much and have a great time. Regards,