I've read a few previous posts but none have really given me the answer
I was looking for (I'm also very new to access). I am creating a form
generator that would allow users to select multiple clauses (they vary
in length from 25 to over 255 characters) from a list to be output to a
report. I would like to create a form that allows the user to view the
complete listing of clauses and simply highlight which ones they need.
I also would like to give the user the ability to create additional
clauses to add to the existing clause list and the ability to edit and
delete existing clauses.
At present the best way I have found to do this is through creating a
datasheet based on a table that includes a clause field and a selector
Yes/No field. The report is then based on a query which displays the
clauses which match the criteria of Yes.
However, I saw a similar program which allows the user to select from a
list box which clauses they would like to add, and then by using some
sort of macro control they can add the clause to the report. Also, the
form had the ability to display the full text of the listbox, which was
condensed due to the window size, in a large text box below the list.
Increasing the wow factor for me was the fact that there were simple
control buttons which allowed the user to add/edit and delete clauses.
Unfortunately, the program was proprietary so I couldn't take a peak at
some of the code. Any tips that anyone has to help me improve my
existing form generator to be more like the one I mentioned I would
greatly appreciate.
|