Ms access dattabase

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 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()

'Search button

Call Search

End Sub

Sub Search()

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

End If

End Sub

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!

Habilidades: Programación de bases de datos, Excel, Microsoft Access, Arquitectura de software, Visual Basic

Ver más: microsoft access online, what is microsoft access used for, access database download, ms access tutorial, ms access database examples, access database tutorial, ms access download, ms access 2007, accesse data ms access search vb, access ms access database manually, accounting projects ms access samples, add record ms access net, airline reservation project ms access, airline reservation system project ms access, set currency ms access, convert ms access to sql server, data entry from website form to ms excel spreadsheet, hiring a webdevolper to set up from template and install eccommerce and affilate marketing, migrate ms access database to live, ms access to web

Información del empleador:
( 0 comentarios ) United States

Nº del proyecto: #17992688

18 freelancers están ofertando el promedio de $29 para este trabajo


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 Más

$55 USD en 3 días
(332 comentarios)

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 Más

$80 USD en 1 día
(294 comentarios)
$29 USD en 1 día
(235 comentarios)

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 Más

$30 USD en 1 día
(199 comentarios)

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

$25 USD en 1 día
(55 comentarios)

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

$25 USD en 0 días
(68 comentarios)

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 Más

$30 USD en 1 día
(37 comentarios)

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.

$10 USD en 1 día
(5 comentarios)

Hi there, I can do this right away. Please authorize me to do this. I will be waiting for your reply. Thanks, Rayyan

$25 USD en 1 día
(7 comentarios)

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 Más

$24 USD en 2 días
(3 comentarios)

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 Más

$25 USD en 2 días
(1 comentario)

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 Más

$25 USD en 1 día
(0 comentarios)

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

$25 USD en 1 día
(0 comentarios)

I am experienced Ms Access and VBA solutions developer. I have developed number of different database solutions in past.

$30 USD en 1 día
(0 comentarios)
$10 USD en 3 días
(0 comentarios)

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

$15 USD en 2 días
(0 comentarios)

Hi. I have over 20 years actively programing vb6. This looks like a minor issue. What's the offer?

$25 USD en 1 día
(0 comentarios)

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 Más

$25 USD en 1 día
(0 comentarios)