So i have a list box that's row source is bound to a query (qryCompanyAndAssoc) that filters company information. There's two columns in this list box that display dates. Right now I'm trying to implement a date range filter, where the user selects a from and to date via two text boxes and the listbox would display the results. This is what I have so far:
Private Sub Command81_Click()
Dim srchCriteria, task As String
[login to view URL]
If IsNull([login to view URL]) Or IsNull([login to view URL]) Then
MsgBox "Please enter the date range", vbInformation, "Date Range Required"
[login to view URL]
srchCriteria = "([AAEndDate] >= #" & [login to view URL] & "# And [AAEndDate] <= #" & [login to view URL] & "#)"
task = " SELECT * FROM qryCompanyANDAssoc WHERE (" & srchCriteria & ") order by [AAEndDate]"
[login to view URL] task
AAEndDate = Association Agreement End Date
txtFrom = Date From
txtTo = Date To
The text boxes are set to Short Date format and when I select a date range then click search I'm given an error saying "Error: 2491 The action or method is invalid because the form or report isn't bound to a table or query" and [login to view URL] task is highlighted yellow.
If anyone has some suggestions or advice on how to solve this, a rookie like me, I would really appreciate it!
18 freelance font une offre moyenne de $29 pour ce travail
We have successfully finished over 520 projects in last 18 years. ID : 17992688 Greetings, We are interested to work on this project, please find my comments inline with yours, 1)Ms access databases So i have Plus
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Plus
Can you please provide me with the sample database so that i could look at the stuff. 1- I guess Recordsource should be used with where clause instead of "ApplyFilter " , but i can comment after looking at the stu Plus
Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
Hi, This is a fairly simple task. It doesn't need that much code. Let me get remote access to your computer and I will show you how to get it set up. Kindly, Alaeddin
I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert Plus
Hello sir I am MS Access expert. I have read your project description and very much interested in your task. I can help you with the task if you give me a chance. So Please contact me. Thanks.
Hi there, I can do this right away. Please authorize me to do this. I will be waiting for your reply. Thanks, Rayyan
Hi,I have read your requirements of Ms access dattabase and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can rea Plus
Hello, good day to you..i am very good using [login to view URL] and very familiar using this application. I can do this project for you for good as you [login to view URL] do not hesitate to contact me if you interest to hire me. Thank Plus
Hi I can help you to solve your issue easily and quickly. I just need a short discussion with you to confirm my understanding of your issue and then I will complete it. Please share and discuss with me so that I ca Plus
Hi there, I recreated the problem in my access database and found the problem. I have a new suggested method to do this work. Please hire me, you will not be dissapointed. I'm located in the US. Regards, Milton
I am experienced Ms Access and VBA solutions developer. I have developed number of different database solutions in past.
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
Hi. I have over 20 years actively programing vb6. This looks like a minor issue. What's the offer?
Hi everyone So i have a list box that's row source is bound to a query (qryCompanyAndAssoc) that filters company information. There's two columns in this list box that display dates. Right now I'm trying to implemen Plus