Solved

MS Access Form Filters Working with Dates and Date Ranges

Posted on 2013-01-21
8
432 Views
Last Modified: 2013-01-21
I made quite a few additions to the attached database so I understand the If statments in the VB code now, but dealing with the dates is a little bit tricky and I am not sure if I know how to handle it in the VBA.

Please take a look at what I am trying to do here.

Scenario1: manager A would like to see all Providers with a [from_date] greater than or equal to 1/1/2003 and a [term date] less than or equal to 8/12/2008, for example.

As I have it right now, I added filter buttons that don't account for the different categories of dates and if I click one filter button, it will work, then I will click the other filter button and it will also work. The problem is that if I put in dates for different fields, the filter buttons won't account for the other fields. You will see when you open my attached database.

Can we get it so that each of the filter buttons filters the entire date range criteria (from_date, term_date, fromfrom_date, tofrom_date, fromterm_date, toterm_date)??
0
Comment
Question by:IEHP1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38802642
you forgot to attach the db
0
 

Author Comment

by:IEHP1
ID: 38803190
Oh, check out my revised Form (super sweet!!!)

Let me know what you think.

I don't have vendorid or vendorname sample data, but you can get the idea (it works with production data).

Can filter on any of the top section fields now using the If statements in VBA (super!!!)
Form-Building-Using-FiltersRev-3.accdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38803198
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:IEHP1
ID: 38803405
so you didn't change anything except for the form itself? I am looking at it, it works, super!!

What did you change (I am checking what you changed right now)....?

Thx so much (I did get a lot of feedback about "what does this and this date mean" so that design works best because it is clearer).
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38803458
i added an option group, and filter the dates based n the option selected..

see the codes inside the

 Select Case Me.Date_filter
0
 

Author Comment

by:IEHP1
ID: 38803470
Yeah tested it, works great!!

Thanks so much capricorn1!!!
0
 

Author Comment

by:IEHP1
ID: 38803473
i saw the Case Statements--I see how that works perfectly...
0
 

Author Closing Comment

by:IEHP1
ID: 38803475
Perfect Solution. Capricorn1 mastered this project using VBA syntax that matches the query results exactly!!!! Perfect!!!!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question