J
JString
Hello everyone.
I'm having a bit of trouble creating a search option that will work for the
business that I'm building my application for. At first I tried adding a few
buttions that utilized Access's built in filter functions. That didn't work
out so well because these functions weren't doing exactly what users wanted,
and I found that they're very difficult to work with in VBA when trying to
customize them, so I had to remove them.
I then implemented a dynamic SQL generator which does everything that the
users want, but its interface isn't as convenient as the built in 'filter by
form' feature.
Is there some better method that's out there? Ideally I would like to be
able to force a form into a state that's similar to 'filter by form', and
then use the user entries to develop an SQL statement which I could grab and
use elsewhere.
Any suggestions would be greatly appreciated.
I'm having a bit of trouble creating a search option that will work for the
business that I'm building my application for. At first I tried adding a few
buttions that utilized Access's built in filter functions. That didn't work
out so well because these functions weren't doing exactly what users wanted,
and I found that they're very difficult to work with in VBA when trying to
customize them, so I had to remove them.
I then implemented a dynamic SQL generator which does everything that the
users want, but its interface isn't as convenient as the built in 'filter by
form' feature.
Is there some better method that's out there? Ideally I would like to be
able to force a form into a state that's similar to 'filter by form', and
then use the user entries to develop an SQL statement which I could grab and
use elsewhere.
Any suggestions would be greatly appreciated.