Search results

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

Hello Guys, I have two Fields in my Table Review Start Time and Review End Time and the Data type is Date/Time. These are the values in these Fields: When a user enter a Time between 8:15 AM and 4:20 PM in the Form, I want to find the count of these Records. For Example if a user Enter 8:16...

Hello Guys, I want to find the Total Review Time. This is my Code Text34.Value = Nz(DateDiff("n", [Review Start Time], [Review End Time]) / 60, 0) This is working Perfect. But when I change Times like: Total Review Time is showing Decimals like this. These are the Properties of my Text...

Hello Guys, I am trying to Track Reviewed Hours of Files by various Departments. There are 3 Levels of Reviewing, 1) Admin Assistant 2) Business Analyst and 3) Manager. I want to eliminate Duplicate Entry. For Example an Admin Asst Reviewed a File on 31-May-2021 from 8:15 AM to 4:30 PM. Again...

Hello Guys, This is my Code Private Sub strName_GotFocus() Dim db As Database Dim rst As Recordset Dim STRSQL As String Set db = CurrentDb() STRSQL = "Select [tblMaster Table].[strID], [tblMaster Table].[strName],[tblMaster Table].[strKeywords],[tblMaster Table].[datMeeting Date],[tblMaster...

Hello Guys, This is my Code Private Sub strPHN_LostFocus() Dim db As Database Dim rst As Recordset Dim STRSQL As String Set db = CurrentDb() STRSQL = "Select [tblMaster Table].[strID], [tblMaster Table].[strName],[tblMaster Table].[strKeywords],[tblMaster Table].[datMeeting Date],[tblMaster...