Solved

Date Box - A couple of things

Posted on 2011-02-14
3
220 Views
Last Modified: 2012-05-11
Hi all,

Please see the attached database.  Jez created the form frm_KPI_Main.

As you can see the MonthID is a text field and the order field is used to sort them into the correct order.  I am going to be adding some buttons to launch some reports directly from this form and I want to use the Month ID as the search criteria in the query.  

However the date combo box doesn't return what is selected (i.e. December 2010) but it returns the order (01) - Is there a way around this?

Also is it possible to arrange the dates into descending order?

Regards

Chris
Copy-of-ee5.mdb
0
Comment
Question by:smods
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34887521
you can extract the date column from the listbox by using

Me.[Order].Column(0)
0
 

Author Comment

by:smods
ID: 34887573
Excellent! Cheers for that capricorn1

Is there also a way to sort the combo box data in descending order?
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 34887611
just set the order by clause to Desc in the rowsource of the list box

select monthid,[order] from tableName order by [order] desc
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access query expression 6 21
Archiving Access table older than 6 months 9 39
Reference Controls on subforms 7 28
Modify report 8 8
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 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