Search results

Hello Guys, What is the Query Syntax to find a Week's prior Data? In my Table I have a field "Max Date" and there is Value From 01-Jan-2021 to 31-Jan-2021. I want to create a Query to get the data only from 25-Jan-2021 to 31-Jan-2021. I have created a query and in the Criteria of MaxDate I...

Hello Guys, Many thanks for all of your valuable suggestions and support. I think I solved this. In my Database there isn't any Login Forms. So I can't set the security Level based on users. At first I have created an InputBox for a user to Enter a Password. It was working fine. But I was not...

Many Thanks for your Help

Thanks a lot for your reply. Very Happy to know that this can do in Access. Though I don't know anything about how to do this. Thank You

Thanks a lot. To be very Honest I don't know how to do this. But I will check in Youtube Tutorials. If you have any Links to how to do this, that will be really helpful. Thank You

Hello Guys, Our database in a Network Folder. Is there any method to restrict some users From Editing the Data of some forms? We have Forms for Entering Basic Details of Employers like Name, Employment History etc And we have Forms for Entering the Pay Details of the Employers. what we need is...

Many Thanks. I have changed the Function like this and it's working perfect. =Count(IIf([strCountry]="USA" And [datReceived Date] Between Date() And Date()-7,0)) Thanks a lot for your help

Sorry. But still getting Error

Hello Guys, I want to get the total count based on two criterias. The first criteria is Country and the Second criteria is Date Received. The date received should be 7 Days prior to Today's Date. Today's date is 02-Mar-2021 and I want to find the total count between the dates between...

Thanks a lot. It works Perfect

Hello Guys, In my Report I want to show the Total count based on multiple criteria. I have put the following Function in the Control Source property of a Text Box: =Count(IIf([strCountry]="USA",1) And ([strState]="CA",1) And ([StrCity]="Los Angeles",1)) But I am getting an Error Could you...

Yes I guess that's the Error. Apologies

I am not sure about that but this is working perfect now. Before your suggestion for adding Option Explicit I put the Code like this: Dim db As Database Dim rst As Recordset Dim STRSQL As String Set db = CurrentDb() Set rst = db.OpenRecordset(Select [Table1.ID] from [Table1]) End Sub And...

Thanks a lot. There wasn't Option Explicit at the Top of my Code Window. It works perfect when I add this.

Hello Guys, This is my Code: Dim db As Database Dim rst As Recordset Dim STRSQL As String Set db = CurrentDb() STRSQL = "Select [Table1.ID] from [Table1];" Set rst = db.OpenRecordset(STQSQL) I am getting an error message like: I have this Table1 in my Database. I have no idea why I am...

Thanks a lot. Million Thanks for your kind Help

Hello Guys, I think I solved this with VBA Code. I have put the following code: Private Sub ID_LostFocus() Dim db As Database Dim rst As Recordset Dim STRSQL As String Set db = CurrentDb() STRSQL = "Select [Test.ID], [Test.Fname], [Test.DoB],[Test.Facility Name], [Test.City]...

MS Access 2016. Thanks

Got it MS DAO 3.6

Hello Guys, Which Reference I should Activate to view Database and Recordset properties in Code Window. When I am trying to declare the variables I am getting like this: Thanks