Search results

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

Thanks so much

I think I fixed this. I use this code Text34.Value = Nz(DateDiff("n", [Review Start Time], [Review End Time]) / 60, 0) Text34.Value = Round(Text34.Value, 2) Thank You

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

Thanks a lot

Thanks a lot for your Help.

Please find the Attachment This is Datasheet view of my Table:

Yes. Exactly

Hi, I have created a separate Table and Form for storing Review Hours. So 1 File will be Reviewing by three levels by Admin Asst, Business Analyst and Manager. I want to prevent Duplicate Data Entry. By Duplicate I mean, a File should not be Reviewed by Admin Asst. for the Same Day and Time...

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

It worked Perfect. Thanks a lot

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

Thank You. I have put my Code in the Got Focus event of strName and it is working,

I have put my Code in the Got Focus event of strName and it is working. Though I am not sure this is the correct way to solve this Thank You

Yes I am able to Edit Thanks

It is Enabled and this is Not an Auto Number Thanks

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

Thanks a lot

Hello Guys, I am transferring data from Excel spreadsheet to Access Table by using Transfer Spreadsheet method. Is there any way to Display a Warning Message Box if there is any Duplicate values in the Access Table? For Example, I have an Employee ID Field and the Value of this Field is 100...

Sorry. My colleague doesn't have access to the Folder where the Database is Backing Up. My apologies, that was a very stupid Question I asked.