Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Date Box - A couple of things

Posted on 2011-02-14
3
Medium Priority
?
238 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 2000 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

569 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