[AccessD] Manually populate a listbox

Turns out the easy way to go was to create a Dates table and a form that
generates rows in said table. It looks for Dmax() and offers that as the
starting row, then accepts an End date and manufactures rows to suit. 

Then I can just (from another form) query the Dates table and present
the multi-select listbox. 

Turned out straightforward once I translated previous code from SQL back
to MDB. After that it was a piece of cake and works pretty well (unless
the user wants to select 100 dates or so; then it's problematic but I'm
handing that blame to William Gates).

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, August 15, 2004 2:39 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Manually populate a listbox


In rereading your question Arthur, I think the problem's different from
what I first thought -- you need to create those dates? You're not just
querying existing data?

Susan H. 


I want to manufacture all dates between the start and end date and
populate the listbox with same. I forget how to do it. I'm used to
grabbing data using SQL etc. and I suppose I could just build a table
containing loads of dates and query that, but I'm wondering how to
manufacture the listbox rows instead.


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com