Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: using Listbox based on query of date

    ok ready here we go...5 cups of coffee deep bout to start the hard liquor cuz i can't figure this out for nothin

    I am using the Calendar ActiveX control and a listbox on a form that shows which shipments are being shipped today. here is where i'm at

    Main Table - Reference#, ShipDate, MustDeliverBy(These are the fields I need, but not all the fields in the table)
    qryShipTracing - Reference#, ShipDate, MustDeliverBy
    ShipDate(criteria) = Calendar0.value

    There will always be a different amount of shipments
    using the listbox I want to be able to choose the reference# and it open a form showing all the information for that reference#
    how do i setup the code with an undefined Case amount?

    some days,let's say, there will be 31 shipments Case 0-30
    other days 51 shipments Case 0-50
    what can I do?

  2. #2
    Join Date
    Dec 2004
    Posts
    277
    also if possible... maybe a quick WHERE tutorial, that statement confuses the hell outta me.........THANKS HELP!!!!!!!!!!!
    Last edited by DackJaniels; 12-23-04 at 15:06.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Why do you need a case statement? You're pulling 30 (or 50 or XXX) # of shipments displaying them in (what kind of?) form ... I'd think a continuous form.
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Dec 2004
    Posts
    12

    CAlendar ActiveX control

    can i know what's the function of calendar activeX control?what it is do?how to use it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •