Search results

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

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

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

Hello Guys, I have a list box and I have enabled Multi selection as Simple. I want to display the values I have selected from this List Box in to a Text Box. Is it possible? Thanks

Hello Guys, I want to display File Name from my Table tblFileBasic in to a Text in my Form frmFileRequest if the File Number in the text box of the Form matches the File Number in the Table. This is my Code: Dim db As Database Dim rst As Recordset Dim strsql As String strsql = "Select...

Hello, I was trying to create a query based on the parameters a user enter. I have created a user form and when user select "Yes" I want to display all the records which are completed. The field Completed is a Check Box. In the Query design view when I enter Yes (without double quotes) query...

Hello, Can we create backup of Access Tables data in to an Excel file by using VBA code? Thanks

Hi, This is my code to find the total number of Denials in an Application and I want to use Like =DCount("[strID]","[tblMaster Table]","[datDate Application Received] between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31) And [strStatus of Application] like "*" & 'Denied'...

Hello, Is there any way to create a folder by current month and take Backup of the Database on that folder? In a button click I want to create a folder for example 2022 Feb and then create a Backup of my Database in that folder like from 01-Feb-2022 to 28-Feb-2022. On next month I want to...

Hi, My database is in a Network folder and it was working fine and multi users can open the database. But since 2022 when another user try to open the database we are getting the message like: and now only one user can able to open the database at a time. Could you please let me know how to...

Hello, I have grouped my report by Month. But I have no idea how to put a Title in the header. This is the design view of my Report And this is my report I want to display April 2021, May 2021 in the report. Could you guys please guide me? Also, there is a gap between the title and the...

Hello Guys, The Record Source of my Report is a query. There is a field "Reviewed By" in this query. I want to display the Text "No" if the Reviewed By field is Null and "Yes" if the Reviewed By Field is Not Null in my Report. Can we do this in a Report? Thanks

Hello Guys, I have a Table to store a new application. I have another table to store review hours. I want to find the details of the applications which are not yet gone for review. For Example, if there are 10 Applications and out of them only 4 has gone for review, I want to find the details...

Hello Guys, This is my code =DSum("[strID]","[tblDaily Snap Shots SPU]","[datDate of Events]='IsNull'") Here I want to display the total number of Records where the Field [datDate of Events] is null in a Text Box. I am getting #Error Could you please let me know how to solve this

Hello Guys, This seems to be very simple but I am not getting a solution. I have a field in my Form "Data Entry By". This field is a mandatory field. So I have wrote this code in the LostFocus Event of "Data Entry By" Private Sub strDataEntryBy_LostFocus() If IsNull(Me.strDataEntryBy) Then...

Hello Guys, I have a field "Data Entry By" and there are 10 Staffs using the database. Is it possible, to set the default value of "Data Entry By" field as Windows User Name? For Example, if a user ABC123 is using the Form for Data Entry, in the Table, I want to display ABC123 as "Data Entry...

Hello Guys, I want to find a query for overlapping Time Entries. These are the fields of my Table: And these are the values in my Table: I want to create a query to display the result of the overlapping entries. In this case: I am attaching my database with the query which I tried to...

Hello Guys, I have a Table to store the Total of Expenses in a Financial Year. I have created queries to break down the Expenses by Month (April, May and June). Then I have created another query to combine these. This is my Query Result: I want to transpose this Query Result like: Could...

Hello Guys, I want to sort entries in my Form by Entry Time. So I have created a new field in the Table and set the current date and time as default value. Then I have make this Text invisible. I want to display the latest Record when I open the Form. Could you please let me know how to set...

Hello Guys, May be a very stupid question, But is there any way we can add Fields in a Query on fly? There are 5 Fields in my Query and in a Form all the Fields I am showing in a Check Box when a user select 3 Fields from the Check Box and click on Run Query Command Button, I want to just show...