newbe question

[unixguy303]

This may be in the wrong forum, but here it goes.

I have a small AccessDB 8-10 fields 6k records
1 of the fields contain creation date.

I need a macro,button or something that when clicked would bring up a dialog box and ask date wanted, user puts date and submit button selects all records meeting the date crieteria and produces a csv with all fields in the file in a particular directry with a particular name of the file.

Would this be hard? Any help would be very much appreciated Thanks in advance

Brandt
American Postal Workers Union Health Plan

 

[dhookom]

There is a query by form applet at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

which will do that for you. Users can select any or all fields, set criteria for any field, and view the results. The results are about 2 clicks from sending to csv, print, Word Merge, Word Table, Excel, graph, HTML,...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[unixguy303]

Just what I was thinking of thanks very nice tool!!!!