Recent content by CamL
-
C
List Box - Placing the most recent year at the top of the list
Hi Paul, Got it to work. I thought that I had tried this already. SELECT DISTINCT Table.Year FROM Table ORDER BY Table.Year DESC; Thanks for the quick response! -
C
List Box - Placing the most recent year at the top of the list
I have populated a list box using the following SQL in the row source: SELECT DISTINCT Table1.Year FROM Table1; The list box populates fine but sorts in ascending order which means I have the oldest year populating first. I would like to have the list populate in descending order so I have... -
C
Select Fields, Multi Select listboxes problem
Hi all, I thought that I would paste in my code manipulation here. I know it is a mishmash. I have three list boxes. The first listbox, labelled 'Select fields from: qrySearch' selects for fields The other two listboxes 'Customers' and 'Employees' selects on a query. The listboxes are... -
C
Select Fields, Multi Select listboxes problem
Hi, I want to combine the functionality of two sample databases found on this forum. Select Fields_demo.mdb allows you to select fields from a list box. Multi Select list boxes as criteria Access 2000. mbd allows you to make multiple selections on a query. My knowledge of VB is limited. I... -
C
Two List Boxes - Attempting to modify sample db - Multi Select list boxes as criteri
Hi everyone, I had a colleauge looking at this as well and he solved the problem. I had everything correct just one comma too many in the SQL. I have attached the corrected version in case anyone is interested. Have a good day, Cam -
C
Two List Boxes - Attempting to modify sample db - Multi Select list boxes as criteri
Hi, I am trying to modify Jon K’s sample database, “Multi Select list boxes as criteria Access 2000”, but I am not having much luck. I am attaching a database with my work The main difference between the two databases: I am using three tables: employers, customers and orders. The query is...