Filter by Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm sorry if I have already posted this question. I can't remember if I
did or not and couldn't find it as a scrolled through the list.

I want to allow users to use the filter by form option. BUT I want to lock
down the database. I have used databased in the past there there are
buttons that allow users to do this even though it is locked down, but don't
have access to one right now to find out how it is done.

If possible, I would like to do it through a button on the switchboard (i.e.
open it up in filter by form view - perhaps by a macro?), but will do so on
the form if required.

If this requires programming, please give me detailed instructions as I'm a
newbie at that part of Access

This is the last thing to be done on this database before it is ready to be
really tested!

Thanks!
 
cprav said:
Hi, I'm sorry if I have already posted this question. I can't
remember if I did or not and couldn't find it as a scrolled through
the list.

I want to allow users to use the filter by form option. BUT I want
to lock down the database. I have used databased in the past there
there are buttons that allow users to do this even though it is
locked down, but don't have access to one right now to find out how
it is done.

If possible, I would like to do it through a button on the
switchboard (i.e. open it up in filter by form view - perhaps by a
macro?), but will do so on the form if required.

If this requires programming, please give me detailed instructions as
I'm a newbie at that part of Access

This is the last thing to be done on this database before it is ready
to be really tested!

Thanks!
Click to expand...

You'll have to explain what you mean by "locked down" as that could be
interpreted several ways.

If you mean you want to distribute an MDE this has no effect on
Filter-By-Form.

If you mean you want to apply User Level Security this has no effect on
Filter-By-Form.

If you mean you want to disable all built in command bars then all you would
have to do is add a custom one that provides access to the Filter-By-Form
feature.

If you mean you intend that it be used in the runtime environment then
Filter-By-Form does not work and cannot be made to work in that situation.
You would have to create your own Query-By-Form feature to replace it.
 
Ah! I have done that, thanks.

However, I want to make it as 'idiot-proof' as possible without having to
write long explanation and was hoping to get a button built into my form that
said "search" and would bring up the 'filter by form' 'mode'. I have used a
database like this before.

As I'm typing this, I'm that perhaps it might involve creating a second form
that would run some kind of query? Sort of like a parameter query? Just not
sure how that would work if all the fields are searchable...

As for your question:
If you mean you want to disable all built in command bars then all you would
have to do is add a custom one that provides access to the Filter-By-Form
feature.
Click to expand...
I think this what I have done. I just have the status bar, a small menu bar
that says "file, edit, insert..." and the max/min/close buttons.


Thanks!
 
Back
Top