Ditutup

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]

Else

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!

Keahlian: Pemrograman Database, Excel, Microsoft Access, Perancangan Perangkat Lunak, Visual Basic

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 0 ulasan ) United States

ID Proyek: #17992688

18 freelancer menawar dengan rata-rata $29 untuk pekerjaan ini

illuminesoft

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 Lebih banyak

$55 USD dalam 3 hari
(332 Ulasan)
7.6
schoudhary1553

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 Lebih banyak

$80 USD dalam 1 hari
(294 Ulasan)
7.7
$29 USD dalam 1 hari
(235 Ulasan)
7.1
customizedata

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 Lebih banyak

$30 USD dalam 1 hari
(199 Ulasan)
7.0
abugosia

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 dalam 1 hari
(55 Ulasan)
6.1
alaeddindhahri

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 dalam 0 hari
(68 Ulasan)
5.8
crypthne

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 Lebih banyak

$30 USD dalam 1 hari
(37 Ulasan)
4.8
Rasel2543

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 dalam 1 hari
(5 Ulasan)
4.1
rayyankabir

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 dalam 1 hari
(7 Ulasan)
3.4
krishnaagr89

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 Lebih banyak

$24 USD dalam 2 hari
(3 Ulasan)
2.9
pegasus9529

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 Lebih banyak

$25 USD dalam 2 hari
(1 Ulasan)
3.1
mdanwarulkabir

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 Lebih banyak

$25 USD dalam 1 hari
(0 Ulasan)
0.0
mim757s

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 dalam 1 hari
(0 Ulasan)
0.0
imranmukati92

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

$30 USD dalam 1 hari
(0 Ulasan)
0.0
$10 USD dalam 3 hari
(0 Ulasan)
0.0
josna70

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 dalam 2 hari
(0 Ulasan)
0.0
mdidiake

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

$25 USD dalam 1 hari
(0 Ulasan)
0.0
Sunnyraph

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 Lebih banyak

$25 USD dalam 1 hari
(0 Ulasan)
0.0