Search results

Thank You so much

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

Thank You

Thank you so much for your reply. Do I have to install this in all the user's system? Thanks

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

Thank you so much. I got this What I did is, I have added a text box in the StartDate Header Section then bound that text box with StartDate field and then change the Format of that text box to mmmm Now it's working the way I want. Thank you so much for your effort and time.

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

Thanks a lot. It worked Perfect. :)

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

Thanks a lot. It worked perfect

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

Thanks a lot. It worked perfect

It worked :) =DCount("[strID]","[tblDaily Snap Shots SPU]","Not IsNull([datDate of Events])") Thanks

Thanks a lot. I tried this code =DCount("[strID]","[tblDaily Snap Shots SPU]","Not Is Null([datDate of Events])") But getting #Error"

Thanks a lot. It worked perfect. Now how do we find the count of Not Null Values? I tried =DCount("[strID]","[tblDaily Snap Shots SPU]","IsNull(0)[datDate of Events])") Thanks

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

Thanks a lot. It works

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