Adding dates to a combo/list box

[moben]

Dear All,

I have a Access 2000 database application.

I want to add dates to combo/list box (which ever is easier).

The values will be the current day, current day +1, and current day +2.

If the current date falls on a Friday, then Current day+1 should Monday etc.

The user can select one of the 3 dates from this box.

Does anybody have any idea how this can be done ?

Feedback/advice/solution really appreciated.

Moen.

 

[PaulBricker]

In a query you could use this sql

SELECT Date() AS Fld1, IIf(Weekday(Date())+1=7,Date()+3,Date()+1) AS Fld2, IIf(Weekday([Fld2])=6,[Fld2]+3,[Fld2]+1) AS Fld3;

This should do it, but you will want to test the iif's a bit further.

Paul

 

[PWise]

I woulde do it this way create a table <digits> with 1 <Digitid> field a number
Add at least 5 records to it 1-5
Set the recordsource of the combobox to
[
code JetSql]
SELECT TOP 3 DateAdd("d",[DigitID],Date()) AS Expr1
FROM Digits
WHERE (((Weekday(DateAdd("d",[DigitID],Date()))) Between 2 And 6));

[/code]

 

[moben]

Thank you very much for the quick responses.

I have managed to get a query to create the dates, but if I link the combo to the query.... only 1 row is returned (unless I increase the value of the column count of the combo box) i.e. can only scroll horizontally.

I need the query to return the dates as individual records, which would be displayed within the combo, probably similar to Pwise has said ?

regards,

Moben

 

[PaulBricker]

Sorry, my bad. I was not thinking about this correctly.

Paul

 

[PWise]

if you will tell me what is wrong with my query I can help you

 

[PHV]

Verticalisation of PaulBricker's query:
SELECT Date() AS Fld1
UNION SELECT IIf(Weekday(Date())=6,Date()+3,Date()+1)
UNION SELECT IIf(Weekday(Date())>=5,Date()+4,Date()+2)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[moben]

Thanks for your help, I have not yet tried your solutions, aim to do so this weekend, will get back to you.

Regards,

Moben.

 

[moben]

Thanks for your help.

I used Pwise's code (modified it slightly to include current day i.e. [DigitID]-1 )and it works.

Thanks,

Mob.