user friendly interface, input parameters

[janco]

Hi there,


I would like to ask you for a piece of advice, again. I have a big table and a code for exporting all records from this table to .txt file with a specific format and this code works perfectly. Of course, there is no problem to export records within given conditions, i.e. to export only data with "Names" between letters A and K, say, and/or "Dates" between 1st January 2011 and 31st July 2011 and/or "Funds" from 1000$ to 100000$ just by calling sql SELECT query (where Names, Dates, Funds are names of fields in the table. Maybe there is better way how to do this, I don't know). However, the problem is that the table may be used by other users who may want to export data with the similar conditions like above but without doing changes in vba code or modifying access queries like I have to do now.

So, I think that the easiest way is to make some graphical interface where user just specify the conditions he/she wants to apply, like he/she just write 1000 and 100000 for Funds in this interface, and these conditions will be the inputs to vba function that will export records with Funds between 1000$ and 100000$. I hope you can see what I mean.

This graphical interface (maybe Access Form?) can be very simple and I will be very thankful for every comment, advice. It remains to note that I am not very good in access, just beginner.

If there is a simple way how to solve my problem, I can apply it, no problem.

Maybe you solved similar problem in the past but I haven't found nothing useful, probably calling wrong tags.

Huge thanks for taking the time to answer.

Jan

[orange]

A form may be exactly what you could use.
See this site for some ideas
http://www.fontstuff.com/access/acctut17.htm

[janco]

A form may be exactly what you could use.
See this site for some ideas
http://www.fontstuff.com/access/acctut17.htm

Hey orange, thank you for your reply, I went through the website and made something that seems to work, so thanks again