Recent content by JithuAccess

Hi, Could you guys please let me know how do I sort Numbers correctly? In my List Box there is a field File Number and it's value is coming from a query. Though I have sorted the File Numbers in the Query, it's not displaying correctly. In this above scenario I want to display the File...

Thank you so much.

Hi, Is there any method to give a Border for Titles in a List Box? This is my List Box and I want to display this in my Form like This: Thanks

Thank you so much. I have changed my code in the Control Source of my Text box as =DCount("*","tblFIleRequestData","FIle_Requested_Date BETWEEN [Forms]![frmReturnedFileStatusInput]![txtBeginDateFIlesReturned] AND[Forms]![frmReturnedFileStatusInput]![txtEndDateFIlesReturned]") And it works...

Thank you so much. It works. Could you please let me know the correct syntax to put a range of dates? This is my code in the Report Activate Event Private Sub Report_Activate() Dim BDate As Date Dim EDate As Date BDate = [Forms]![frmReturnedFileStatusInput]![txtBeginDateFIlesReturned] EDtae...

Hello, Thank you so much for all your replies. Is there any method to find the Total Number of Records in the Table in a Report? The Record Source of my Report is a Query and I want to find the Total Number of Records in a Table Because Query is based on certain criteria and I want to find...

Thank you so much. It works perfect. Sorry for bothering you again. I want to add one more criteria. I want to find the total count if the File_Return_Date comes between a certain date range and this is my Code: =Sum(IIf([File_Return_Date] Is Not Null,1,0)) And [File_Return_Date] Between...

Please note that I don't want to use N Number of queries as we can do it simply by using a IIF Function in the control Source of a Text Box. I am sure there is an Error in my coding and it would be highly appreciate if you could let me know what's the correct Syntax of Count IIF Function. In my...

Hi, In my Report I want to find the Total Number of the Files not returned. I have added the following code in the Coontrol source property of a Text Box =Count(IIf([File_Return_Date]=IsNull()) and I am getting the Following Error: Could you please let me know the correct code? Thanks

It's not that much complicated database, just 2 Tables.

Thank you so much. It works

Hi, I want to Insert Into the values of the selected items in my list box in to a table. This is my code: Private Sub Command74_Click() Dim db As Database Dim FlNum As String Dim FlNam As String Dim flReqBy As String Dim FlReqDate As Date Dim...

Thank you so much. It works

Hi, How do I deselect the previously selected values from my list box? I have created a query and it's based on the key words I texted in a text box. The row source of my list box is that query. Like this: Now, if I keyed another keyword in the Text box the previously selected values...

Thank you so much. I am going with your first code. It works. Thanks a lot