Help with DateAdd function

[miltie]

Hello. I'm not sure of the best way to set this up, but I have a table with a document_name field and a due_date field. Here's my dilemma: I want to have a form that I can input a document name in a text box and have a drop down with a weekday listed. Then after the user selects the due date, i.e., Friday, have my table populated with records with the same document name but show a due date of every Friday in 2012. So there would be roughly 48 records in my table added. I'm assuming I can use the dateadd function for my drop down box? Any help would be greatly appreciated.

 

[dhookom]

Can you please share some table structures with field names and data types?

Do you want to populate with past Fridays or only future dates?

Duane
Hook'D on Access
MS Access MVP

 

[lameid]

I think a more fundamental question is do you just want to report that it is due on Fridays or do you want to create he records for all Fridays? I ask because there are completely different considerations to each.

In any case, some samples like Duane suggest will be helpful.

 

[MazeWorX]

To select a date I like to provide my users with a little bling. I didn't write this but it works well to select dates. This may be a good starting point >> see the attachment

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[TheAceMan1]

How are ya miltie . . .
I'm stuck in the followimg quote:

[blue]I want to have a form that I can input a document name in a text box and have a drop down with a weekday listed.[/blue]

You need to expand on this! ... I have no idea what you mean ...

Understand ... we don't know whats in your head ... nor can we see what you see!

[blue]Your Thoughts? . . .[/blue]


See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]